java.sql.SQLException: Logical handle no longer valid
Hi,
I have the "java.sql.SQLException: Logical handle no longer valid" problem, in a severe way. Let me give the details:
win 2000 advanced server or win NT (we tried both, it doesn't matter.)
tomcat 3.2.3 web server
oracle 8.1.6 / 8.1.7 database
sqlj and jdbc drivers for oracle 8.1.7
We are using connection pooling. I have tried several times, and noticed that, when two servlet threads try to access the database(e.g. run a select statement) using different connections from the pool, I directly get this 'Logical handle no longer valid' error.
The basic problem here is, concurrent database access is so frequent that, all of my pooled connections fail one by one in about 10 minutes! Then I have to restart the web server, obtain pooled connections again, etc.
Is there a solution to this problem in any way?
Thanks in advance,
Best Regards.
Onur.