About Coldfusion 9 database sessions

5 replies
624 views
Translate

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?

This topic is closed to new replies. Start a new post to keep the conversation going.

WolfShadeCorrect answer

Legend

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,

^ _ ^

義

義昭渋27371070Author

Participant

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

The session continues to remain now.

Translate

WolfShadeCorrect answer

Legend

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,

^ _ ^

Translate

Charlie Arehart

Community Expert

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.

Translate

/Charlie (troubleshooter, carehart. org)

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.