Disconnect Database Immediately with 0 timeout

[lwd]

If you set the timeout to 0 in Advanced Settings for a data set, will this
disconnect the data source immediately after it is used? For security reasons,
I need to close the data set immediately after it is used.

[jdeline]

Go to the CF admin page, select ODBC Data Sources, click on your datasource and
click the CF Settings button. You'll see a checkbox that permits you to remain
connected to your datasource or not. Make sure you have it selected to NOT
maintain datasource connectivity.

[paross1]

Like I said in my answer to your previous post, if you de-select Maintain
Database Connections in your data source configuration in CF Admin, your
database will be released after each query/ transaction.

Phil

[lwd]

Phil,
Thanks again. I understood this as the answer also, however, I received a
subsequent message that said "For disconnecting individual data sources, the
best bet is to configure them with a short timeout."

Are you saying that the timeout (min) parameter refers to "Maintain Database
Connections" and that once you unclick this setting that the database will
close after each query/transaction?

I've received emails saying: Regarding connections ? when are they broken ?
Broken at the end of each user session? Broken at the end of every call?
Broken after a specific time?

You are saying that they are broken at the end of every call if this parameter
is checked.

[paross1]

I am saying that if you un-select / un-check Maintain Connections, the connection between ColdFusion and your database should be dropped after each transaction.

Phil

[OldCFer]

The timeout is how long it will wait while running a query action before
returning
an error. For instance, you're querying a table that has an exlusive lock by
another
process. How long should it wait? It has nothing to do with releasing the
connection
after the query has completed.