This week's book giveaway is in the General Computing forum. We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line! See this thread for details.
Hello, I was accessing ingres directly via a Java application, using jdbc-odbc. But, i sometimes get this error:
failed to set isolation level: Unable to allocate a connection
NOTE: I am using the Caribou Lake driver
Any ideas? Thanks. -------------------------------------------------------------------------------- Posts: 11 | Registered: Feb 2004 | IP: Logged
Sutham Rojanusorn greenhorn Member # 76563 posted July 10, 2004 10:13 AM -------------------------------------------------------------------------------- I think you should consult with your jdbc driver document for this to see .. whether you can set database transaction =========================================================================== *************************************************************************** From Manish:
I think Sutham is correct, refer the jdbc driver doc. May be you need to set the transaction level. And what is the default transaction level with this driver would be helpful for you.
regards, Manish SE, PCS
Its difficult to break a hard nut but its not impossible.
i guess this happens when you try to create multiple SQL statement in the same instance of the connection. The JDBC-ODBC bridge does not support this. If you want, you can create another instance on your JDBC connection then create your other SQL statement to this connection(resource intensive activity). Other than that try using the JDBC driver that comes with your database, besides JDBC-ODBC bridge has limitted functionality.
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
