The Network Adapter could not establish the connection

[RichardDeray]

Hi,

I use APACHE/TOMCAT 4.0 with ORACLE 8i on a PC/XP plateform.

Occasionnally only, I have an error message from ORACLE : "java.sql.SQLException: Exception d'E/S: The Network Adapter could not establish the connection".

This append only when I create many records in a loop (more than 200).
If I create 3000 records in 15 groups of 200 separated by 120 seconds of waiting time, all the records are created whithout any problem.

When the server is not used during a ceratin number of hour this deconnection append.

Could somebody help me.

Thanks.

 

[sedj]

What port are you going in on. Are you using Oracle shared server on 1526 ? Are you using Connection pooling ?

When you execute this loop, are you attempting to get a brand new Connection each time ? If so, I expect you are overloading the network !