About Coldfusion 9 database sessions

[義昭渋27371070]

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?

[義昭渋27371070]

I'd like to disconnect the session between database and cold fusion.

The session continues to remain now.

[WolfShade · Accepted solution]

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,

^ _ ^

[Charlie Arehart]

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.

[義昭渋27371070]

Thank you for your reply.

Thank you very much for explaining the procedure.

[WolfShade]

Thank you for marking my answer as correct.  I appreciate it.

V/r,

^ _ ^