User b5f79361ac
23-07-2008 01:34:35
I used the following JAVA code to change structure from Long Raw to String (molfile)
String dbMolfile = new String(DatabaseTools.readBytes(result,2),"ASCII");
But it doesn't work for Blob.
javax.servlet.ServletException: Cannot handle type in field "CD_STRUCTURE": oracle.sql.BLOB
java.sql.SQLException: Cannot handle type in field "CD_STRUCTURE": oracle.sql.BLOB
Who can tell me how to show/express BLOB type compound structure in Java code?
Thanks a lot!
ChemAxon 909aee4527
23-07-2008 06:47:50
Hello Yinghua,
the topic was moved to the Structure search and chemical database forum, we will answer your question soon.
Kind regards,
Judit
ChemAxon e274e1bada
23-07-2008 08:53:12
Hi Yinghua,
Could you post me your JChem, Java, Oracle and JDBC driver version numbers?
Regards, Edvard
User b5f79361ac
23-07-2008 14:43:14
JChem 5.0.2
Java 6 Update 7
Oracle 10g
JDBC driver JDBC thin classes12.jar (not sure version)
Do you think I need update JDBC driver?
Thanks a lot!
Yinghua
ebuki wrote: |
Hi Yinghua,
Could you post me your JChem, Java, Oracle and JDBC driver version numbers?
Regards, Edvard |
ChemAxon 9c0afc9aaf
23-07-2008 15:28:03
User b5f79361ac
25-07-2008 17:26:17
I updated JDBC driver. But the error still comes up.
Any other ideas?
Thanks!
Yinghua
ChemAxon 9c0afc9aaf
25-07-2008 17:36:53
Hi,
Please remember to restart the JVM, e.g. the (web) application if you upgrade the driver.
Use ojdbc14.jar. (and no other driver in the classpath)
Please check the the application "sees" the correct driver.
E.g. in the case of Tomcat the system CLASSPATH is irrelevant, check the files in the lib directory.
You may find this topic useful:
http://www.chemaxon.com/forum/ftopic1397.html
Best regards,
Szilard
User b5f79361ac
25-07-2008 18:04:19
Thanks a lot!
I modified the path, but didn't restart tomcat. Thanks again!
Yinghua