File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes JDBC java.sql.SQLException: Serialization failure Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "JDBC java.sql.SQLException: Serialization failure" Watch "JDBC java.sql.SQLException: Serialization failure" New topic

JDBC java.sql.SQLException: Serialization failure

Vinod Subramaniam

Joined: Aug 17, 2003
Posts: 19
Iam porting J2EE application from Tomcat to OC4J 10.1.3. Its using HSQL as database. All the data are in files. One of the file has insert script which inserts Portal User Id and PortalUser Object(its blob) into in memory HSQL. When i read the PortalUser details and do getObject on ResultSet iam getting the following error. The Same is working on Tomcat which Uses JDK 1.3. The Record is written using Tomcat Server. Iam using the same HSQL driver on OC4J 10.1.3 which loads the Insert script created on Tomcat into in memory HSQL but still getting the following error. Is there any vendor specific Read and Write happening by the vendor even if we use same drivers(HSQL driver)? If yes is there a way to overcome it.

Code for which Iam getting Error
Object obj = theResult.getObject("PORTALUSEROBJECT");

de.svi.svis4j.allgemein.portal.datenpflege.PortalDBConnect] Select-Statement auf Tabelle PortalUser fehlgeschlagen!
java.sql.SQLException: Serialization failure
at org.hsqldb.jdbc.jdbcUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.getObject(Unknown Source)
at org.hsqldb.jdbc.jdbcResultSet.getObject(Unknown Source)
at de.svi.svis4j.allgemein.portal.datenpflege.PortalDBConnect.getPortalUserByID(

Any hints, Pointers or Help would be apprecitaed in this regard.
Thanks in advance for your help.

Vinod S
I agree. Here's the link:
subject: JDBC java.sql.SQLException: Serialization failure
It's not a secret anymore!