Many thanks Darin. I added it to my cfc and the spikes in memory seem to be
under control now.
-Dusty
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Darin Kohles
Sent: 01/23/2008 11:51 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] closing database
Actually, you should wrap your code in a try/catch/finally block. The
closing of the connection should always happen in the finally block to
ensure that it closes if an exeption occurs.
That being said, once this object is out of scope, garbage collection
should close the connection for
That was an excellent thought. I've never used cffinally but just looked up
what it does.
thx
-Dusty
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe
Sent: 01/24/2008 6:56 AM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] closing database
I'd actually wrap this whole thing in a very simple helper object
which can handle creating the DB connection and destroying it. Also,
make sure you use parameterized queries to prevent any SQL injection.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
If liberty means anything at all, it
to answer the other questions, you don't have to worry about this in CF
code, CF handles the closings for you. Also note that unless you have
connection pooling off for some reason, CF handles that too. Your direct
approach is bypassing any sort of connection pooling.
DK
On Jan 24, 2008 8:12
Good point, Doug. So if your connections are limited by the DB
server, the connection pool + these connections outside the pool may
be maxing out your possible DB connections...
Is there a good reason to avoid using the built in connection pools?
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL
That pretty much covered it. It's also one of the benefits to CF in my
opinion.
As far as a case where you would want to turn off connection pooling. I
haven't run across a situation that would call for that.
Here's an interesting article by Steven Erat about conection pooling..
Max, have you considered just telling it not to scan the CF directories? If
some rules mandate that all dirs be scanned, how about setting up a process
to do it only on a scheduled basis when CF is down?
/charlie
_
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Max
Thanks, Charlie. I had previously checked for information, but this is
one site I did not see.
I did find where others have encountered various versions of this
update issue.
I worked on the problem and finally concluded that the problem was that
eclipse.org was in the search list,
and that