This page contains an archived post to the Java Answers Forum made prior to February 25, 2002. If you wish to participate in discussions, please visit the new Artima Forums.

Message:

NotSerializableException when trying to store Oracle conections

Posted by Raul Delgado on June 27, 2001 at 7:45 AM

I have a problem with mi intranet application:
It runs trough an Oracle Database and each user haves his Oracle conection, when a new user logs in, a new Conection is created, and when he exits the conection is disconected.
I store all the Oracle conections in an static Vector of a class created for me, that also has a set method that stores a conection in the Vector and returns the index in wich it is stored and a get method which returns an Oracle conection receiving an int argument that is the index of the Vector where the conection we want is.
The problem is that from time to time and randomly occurs this error:
SessionSerializer: java.io.NotSerializableException: oracle.jdbc.driver.OracleConnection
and afterwards the Vector gets empty, because when I try to get a conection stored in a given index, I see this error:
java.lang.ArrayIndexOutOfBoundsException: 7 >= 0
at java.util.Vector.elementAt(Vector.java:420)

Please help me, It is very important