Hi,
On Fri, 28 May 1999, Ross J.P. Ethier wrote:
RJPE |If this is the type 4 driver supplied by Oracle, it seems to only handle 50
RJPE |uses per connection and then the connection blows up!
We use these type 4 drivers (JDBC-thin) on a production server and we
can use one connection for serveral 100k transactions in a connection
pool.
We had problems with errors like 'too many open cursors'-errors or
the like first (I think that is what you mean with 'connection blows up').
But this seems to be a bug in ResultSet and Statment handling of oracle.
If you consequently close your ResultSets and Statemets (which you should
do anyway) after use, the type 4 drivers are quite stable.
To make sure that we close rsets and statements we utilize the finally
clause auf java:
----
ResultSet rset=null;
Statement stmt=null;
try {
stmt = new Statement();
rset = ..
// do processing here
}
catch () {
}
finally {
if (rset != null) rset.close();
if (stmt != null) stmt.close();
}
-----
ciao,
-hen
---
Henner Zeller [EMAIL PROTECTED]
PGP pub key [77F75B39]: finger [EMAIL PROTECTED]
"One difference between SuSE and Red Hat is that the former operates in a
country where people don't sue each other over coffee being too hot."
Linus Torvalds
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Problems?: [EMAIL PROTECTED]
