Problem with the export in JChemManager

Hello,


I have installed JChemManager on my linux computer. I had created before a postgres database named BD_CMBA_SA and I use a JDBC driver for postgres localised in:


usr/local/jdk1.5.0_02/jre/lib/ext/postgresql-8.0-314.jdbc3.jar


The version of JChemManager I use is 3.1.5 (as you can see on the jcman_about.jpg image).


I don't have any problem to connect my database with JChemManager using the parameters listed on the image jcman_log.jpg. I don't have problems anymore to create a table, import structures in my table, delete rows, etc... But when I tempt to export my table in a SDF format (or any other format, excepting sometimes in SMILES...), a message error is prompted on the console:





[aci@delta4002 aci]$ java.lang.NullPointerException


at chemaxon.jchem.db.SQLToFileHandler.dbRowToRecord(SQLToFileHandler.java:308)


at chemaxon.jchem.db.SQLToFileHandler.writeNext(SQLToFileHandler.java:434)


at chemaxon.jchem.gui.Exporter.run(Exporter.java:123)


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





and a pop-up window give me the same shortly message, given on the image jcman_error1.jpg.


I have the same problem when I use your jsp example (jchem/examples/jsp1_x/). All the modules work except the export of the molecules. Please, could you give me an explanation and, if possible, a solution for this problem?


Thanks a lot in advance, best regards,


Samia ACI

Hi,





We could reproduce the problem.


It is PostgreSQL specific, and occurs when some data fields are also exported - this can explain why it might work better with SMILES, as we do not export data for this format by default.





We have located and fixed the problem, our the next JChem release will contain the fix.


Until then I have prepared a jchem.jar with the same code as 3.1.5, the only difference is this bugfix.








You can download it from the following location:





http://www.chemaxon.com/download.php?d=/data/download/jchem/3_1_5_mod1/





Just replace the old jchem.jar with this one, and everything should work fine.





Many thanks for the detailed bug report.





Kind regards,





Szilard

Thanks a lot for your so quick answer and for the new jchem.jar file. My JChemManager works perfect now.


Best regards


Samia ACI