connect to sqlite database with jchem

Is there a proceedure for doing this?

I have a driver, sqlite-jdbc-3.7.2.jar, and I put it in,

C:\Program Files\ChemAxon\JChem\lib\jdbc\

where it looks like the jdbc drivers are.

 

In the JChem manager "connect to database" window, I entered,

sqlite-jdbc-3.7.2.jar

as the JDBC driver, and then the path to the database,

jdbc:sqlite:E:/path_to_file

but I get an error for ClassNotFoundException for sqlite-jdbc-3.7.2.jar.

Jchem does not appear to know where to look for the class, so do I have to register it somehow?

I am using JChem 5.7.1 windows if that matters.

LH_medchemist

Hi,

 

Unfortunately, sqlite is not supported by JChem. But you can choose from a few other dbms-es. See the list here:

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

 

Best regards,

Szabolcs