java.sql.SQLException: Closed Connection

Hi

I am getting this exception from the Application, very sporadically. This happens when a call is made to prepareStatement. I do not understand this very new behaviour. This is occuring in Oracle 10G AS.

Can someone throw me a bone as to how can i get rid of this issue?

Thanks

Arvind

[318 byte] By [ariyera] at [2007-10-3 8:10:46]
# 1
Is the error in the same place when it does happen? Have you tried `logging` the events that lead up to the error?
elmeromeroa at 2007-7-15 3:15:11 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 2

> I am getting this exception from the

> Application, very sporadically. This happens when a

> call is made to prepareStatement. I do not

> understand this very new behaviour. This is occuring

> in Oracle 10G AS.

Did you check your database session timeout? That can be what you are looking for.

:D

TikkyChaia at 2007-7-15 3:15:11 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...
# 3

Tried that also. But had that been the problem this would exception would have been raised at multiple places in the application. One more piece of information that I think might be useful is, that this issue occurs only when the application is run through RT scripts (automated test scripts). It is not reproducible manually.

ariyera at 2007-7-15 3:15:11 > top of Java-index,Database Connectivity,Java Database Connectivity (JDBC)...