setup JChemProperties table in database

Hi


I am evaluating JChem as possible chemistry library for use with a text mining tool. I am trying to create a database of molecules using JChem Base for substructure matching by calling your Java API ,using the chemaxon.jchem.db.Importer class to update the table. However the above class is throwing an Exception as it is looking for a table called JChemProperties. From what I can gather it has something to do with licensing here us the Stacktrace

Code:

java.sql.SQLException: Table not found in statement [SELECT prop_name FROM JChemProperties]    at org.hsqldb.jdbc.Util.sqlException(Unknown Source)    at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)    at org.hsqldb.jdbc.jdbcStatement.executeQuery(Unknown Source)    at chemaxon.jchem.db.DatabaseProperties.getChemTermColumns(DatabaseProperties.java:828)    at chemaxon.jchem.db.TableInfo.<init>(TableInfo.java:102)    at chemaxon.jchem.db.TableInfo.getTableInfo(TableInfo.java:359)    at chemaxon.jchem.db.Importer.init(Importer.java:629)    at chemaxon.jchem.db.Importer.run(Importer.java:370)    at jchemtest.Test.main(Test.java:58) chemaxon.jchem.db.TransferException: Table not found in statement [SELECT prop_name FROM JChemProperties]    at chemaxon.jchem.db.Importer.init(Importer.java:649)    at chemaxon.jchem.db.Importer.run(Importer.java:370)    at jchemtest.Test.main(Test.java:58)

Could you tell me how I can setup the above table with the correct licences.


Thanks


Wiraj

Hi,





Every JChem database needs a property where it stores information about the structure tables.


The property table is automatically created when you first connect to the database with JChem Manager or Instant JChem.





To create this table programatically use DatabaseProperties.createPropertyTable():





http://www.chemaxon.com/jchem/doc/api/chemaxon/jchem/db/DatabaseProperties.html#createPropertyTable(chemaxon.util.ConnectionHandler)





You can read more on the property tables here:


http://www.chemaxon.com/jchem/doc/admin/multiuser.html





You may also find the JChem Administration Guide and Developer's Guide useful:


http://www.chemaxon.com/jchem/doc/admin/





Best regards,





Szilard