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");
Error
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(PortalDBConnect.java:82)
Any hints, Pointers or Help would be apprecitaed in this regard.
Thanks in advance for your help.
Thanks,
Vinod S