Skip to main content
義
義昭渋27371070
Participant
November 28, 2017
Answered

About Coldfusion 9 database sessions

  • November 28, 2017
  • 1 reply
  • 594 views

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 has been closed for replies.
    Correct answer WolfShade

    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,

    ^ _ ^

    1 reply

    義
    義昭渋27371070Author
    Participant
    November 30, 2017

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

    The session continues to remain now.

    WolfShade
    WolfShadeCorrect answer
    Legend
    November 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,

    ^ _ ^

    Charlie Arehart
    Community Expert
    Charlie ArehartCommunity Expert
    Community Expert
    November 30, 2017

    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 (troubleshooter, carehart. org)
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices