Installation problem?

I installed JCHEM with postgres. And I used the following command to create a structure table.


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


jcman c testy --coldefs ", cid int4" -l youjkim --driver org.postgresql.Driver --dburl jdbc:postgresql://localhost:5432/biochemdb -s


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





And I have the following files set for CLASSPATH.





/usr/local/pgsql/jdbc/postgresql-8.1-407.jdbc3.jar:/z/local/youjkim/pathwayfinder/java/jdk1.5.0_08/lib/dt.jar:/var/www/html/pathwayfinder/cgi-bin





But I got the following excpetions. Do you have any idea how I can fix it?





Exception in thread "main" java.lang.NoClassDefFoundError: chemaxon.jchem.db.UpdateHandler


at java.lang.Class.initializeClass (libgcj.so.7)


at chemaxon.jchem.Command.createTable (Command.java:688)


at chemaxon.jchem.Command.main (Command.java:420)


Caused by: java.lang.ClassNotFoundException: oracle.sql.CLOB not found in gnu.gcj.runtime.SystemClassLoader{urls=[file:/z/local/youjkim/pathwayfinder/jchem/bin/../lib/jchem.jar,file:/usr/local/pgsql/jdbc/postgresql-8.1-407.jdbc3.jar,file:/z/local/youjkim/pathwayfinder/java/jdk1.5.0_08/lib/dt.jar,file:/var/www/html/pathwayfinder/cgi-bin/], parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}


at java.net.URLClassLoader.findClass (libgcj.so.7)


at java.lang.ClassLoader.loadClass (libgcj.so.7)


at java.lang.ClassLoader.loadClass (libgcj.so.7)


at java.lang.Class.initializeClass (libgcj.so.7)


...2 more

Quote:

gnu.gcj.runtime.SystemClassLoader{urls=[file:/z/local/youjkim/pathwayfinder/jchem/bin/../lib/jchem.jar,file:/usr/local/pgsql/jdbc/postgresql-8.1-407.jdbc3.jar,file:/z/local/youjkim/pathwayfinder/java/jdk1.5.0_08/lib/dt.jar,file:/var/www/html/pathwayfinder/cgi-bin/], parent=gnu.gcj.runtime.ExtensionClassLoader{urls=[], parent=null}}

We don't currently support GNU Java. Please, use Sun Microsystem's Java implementation, if available on your platform. Java implementations other than Sun Microsystem's may also work, but GNU Java is specifically known not to work with JChem/Marvin.





Thanks


Peter