Copy link to clipboard
Copied
I am using windows server 2008 R2 and Coldfusion 9
using.
I am using oracle for the database.
Sometimes the session of Coldfusion 9 and oracle will continue to remain,
Is there a way to deal with it?
Are you referring to the setting for each Data Source, "Maintain Database Connection"?
Log on to CFAdmin. From the left pane, expand "DATA & SERVICES", then click "Data Sources".
Click on the DSN related to your question. Click on "Show Advanced Settings". Scroll down to "Maintain connections across client requests." Uncheck the checkbox if it is checked. Submit changes.
V/r,
^ _ ^
Copy link to clipboard
Copied
I'd like to disconnect the session between database and cold fusion.
The session continues to remain now.
Copy link to clipboard
Copied
Are you referring to the setting for each Data Source, "Maintain Database Connection"?
Log on to CFAdmin. From the left pane, expand "DATA & SERVICES", then click "Data Sources".
Click on the DSN related to your question. Click on "Show Advanced Settings". Scroll down to "Maintain connections across client requests." Uncheck the checkbox if it is checked. Submit changes.
V/r,
^ _ ^
Copy link to clipboard
Copied
And note there the options regarding the connection timeout and interval, which would relate to how long the connections are "maintained". The timeout is how long, and the interval is how often CF checks to remove unused ones.
Copy link to clipboard
Copied
Thank you for your reply.
Thank you very much for explaining the procedure.
Copy link to clipboard
Copied
Thank you for marking my answer as correct. I appreciate it.
V/r,
^ _ ^