Stephen Richards wrote: > > The top output only shows one postgres connection as not being idle.
And if you run the offending query from psql and ColdFusion at the same time? > The fake queries separated by a time delay showed interesting results: while > that was executing, I could perform CF operations from another screen. > > This tends to point to CF rather than the ODBC driver, no? CF makes the > connection to the database, executes a query, gets the result, then knows > that it has to wait around, so looks about for other queries to do, and does > them. > > Whereas, with the long query, it issues the query and then just waits for > the answer, not doing anything else until it gets one or times out. This proves that unixODBC can have more as one open connection, but it still could be unixODBC not being able to have more as one active connection. I think that you need to be able to look deeper into ColdFusion/unixODBC as the default compilation allows to find out more. I'm sorry, all I can say for sure is that the problem does not occur for me with CF MX and the stock JDBC driver and didn't occur for me with CF 4.5 on windows with the default ODBC driver. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
