How to show BLOB type structure in Mavin on web browser?

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

Hi,





I recommend getting the latest JDBC driver from Oracle from here:





http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html





(From 9.2 until the latest 11 version all JDBC and DB versions are compatible with each other)





Please let us know if this helps.





Best regards,





Szilard

User b5f79361ac

25-07-2008 17:26:17

I updated JDBC driver. But the error still comes up.


Any other ideas?


Thanks!


Yinghua





Szilard wrote:
Hi,





I recommend getting the latest JDBC driver from Oracle from here:





http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html





(From 9.2 until the latest 11 version all JDBC and DB versions are compatible with each other)





Please let us know if this helps.





Best regards,





Szilard

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