About Coldfusion 9 database sessions

New Here ,
Nov 27, 2017 Nov 27, 2017

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?

Views

217

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines

correct answers 1 Correct Answer

LEGEND , Nov 30, 2017 Nov 30, 2017
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,^ _ ^

Likes

Translate

Translate
New Here ,
Nov 29, 2017 Nov 29, 2017

Copy link to clipboard

Copied

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

The session continues to remain now.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Nov 30, 2017 Nov 30, 2017

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,

^ _ ^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Community Professional ,
Nov 30, 2017 Nov 30, 2017

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.


/Charlie (server troubleshooter, carehart.org)

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Nov 30, 2017 Nov 30, 2017

Copy link to clipboard

Copied

Thank you for your reply.

Thank you very much for explaining the procedure.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Nov 30, 2017 Nov 30, 2017

Copy link to clipboard

Copied

LATEST

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

V/r,

^ _ ^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines