Error using import in JCMAN

User 4140faeba5

19-02-2007 11:33:22

Hi.


JCHEM_CORE_PKG.GETENVIRONMENT()


--------------------------------------------------------------------------------


Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production


PL/SQL Release 9.2.0.6.0 - Production


CORE 9.2.0.6.0 Production


TNS for Solaris: Version 9.2.0.6.0 - Production


NLSRTL Version 9.2.0.6.0 - Production


NLSRTL Version 9.2.0.6.0 - Production


JChem version in the database: 3.1.7


JChem version in the Tomcat server: 3.1.7


java.vm.version: 1.4.2_10-b03


java.vm.vendor: Sun Microsystems Inc.


Apache Tomcat/5.5.12





JCHEM_CORE_PKG.GETENVIRONMENT()


--------------------------------------------------------------------------------


Major JDBC version in Tomcat: 1


Minor JDBC version in Tomcat: 0








I am trying to import an sdfile using JCMAN. The SDfile contains (besides the structure) also 2 other fields where one of them i a CLOB.


I get the following error when I try.


ava.lang.ClassCastException


at chemaxon.jchem.db.UpdateHandler.isBigLOB(UpdateHandler.java:1276)


at chemaxon.jchem.db.UpdateHandler.checkBigLOB(UpdateHandler.java:1583)


at chemaxon.jchem.db.UpdateHandler.execute(UpdateHandler.java:1454)


at chemaxon.jchem.db.FileToSQLHandler.importFile(FileToSQLHandler.java:262)


at chemaxon.jchem.gui.Importer.run(Importer.java:137)


at java.lang.Thread.run(Thread.java:534)


chemaxon.jchem.db.TransferException


at chemaxon.jchem.db.FileToSQLHandler.importFile(FileToSQLHandler.java:316)


at chemaxon.jchem.gui.Importer.run(Importer.java:137)


at java.lang.Thread.run(Thread.java:534)








What am I missing ?


Regards,


Mikael

ChemAxon 9c0afc9aaf

19-02-2007 11:46:39

Dear Mikael,





Support for custom LOB fields have been implemented since JChem 3.2.


I suggest you to upgrade to the latest version.





Best regards,





Szilard

User 4140faeba5

19-02-2007 11:48:48

thanks.


Will do that.


Regards,


Mikael