Re: cfquery options and connection pooling

2008-04-22 Thread Jon Clausen
Maureen, I had something similar happen on a machine running SUSE 9/CF7 connecting to a PostgreSQL database with a third-party driver. My understanding, as I've read it, is that connections are only pooled across the length of the request so if your code throws a database error somewhere

cfquery options and connection pooling

2008-04-21 Thread Maureen Barger
I am trying to figure out the technical ramifications of defining the username and password for a specific DSN in a separate text file and how it may relate to connection pooling v. supplying the user/pass directly in the DSN. Once the file is loaded, user and password are passed to cfqueries

RE: cfquery options and connection pooling

2008-04-21 Thread Dave Watts
I am trying to figure out the technical ramifications of defining the username and password for a specific DSN in a separate text file and how it may relate to connection pooling v. supplying the user/pass directly in the DSN. Once the file is loaded, user and password are passed to

Re: cfquery options and connection pooling

2008-04-21 Thread Maureen Barger
thanks, we are using Oracle driver provided in the macromedia.jar, 3.5 since Oracle's own driver does not support stored procedures. On Mon, Apr 21, 2008 at 1:56 PM, Dave Watts [EMAIL PROTECTED] wrote: I am trying to figure out the technical ramifications of defining the username and