JAVA ISSUES

Classification:
UNCLASSIFIED

Caveats: FOUO

I
am evaluating JChem (and all associated programs and modules) and have so far been completely unsuccessful at opening a database in JChem.
 The initial dialog box that opens upon running “jcman” requests
locations for the JDBC driver and the URL of the Database to be accessed. I
have tried to follow the instructions on the online “guides” however they state what to put into the
dialog boxes, but do not explain what to do when the recommended values do not
work. I created a blank MS Access database for test purposes to try and get
into the program, to no avail. I tried to link the database using odbc drivers
via SQL server and encountered issues there too. I am not a programmer and have
never worked with java code or SQL Server databases, so a lot of the documents
on the website are Greek to me, for example:

 

The URL format for the datasource should be, according to the JChem FAQ, “jdbc:odbc:[odbc data source]” however I have been unable to find anything in the JChem documentation on how to create a odbc data source, or how to properly call it in this code.

Is there a walkthrough on how to get started with this program? I feel that just getting the program started shouldn’t be this difficult and I must be missing something.

Any tips would be appreciated.

Hi,

 

I created a blank MS Access database for test purposes to try and get


into the program, to no avail.

This post describes the correct procedure:

http://www.chemaxon.com/forum/viewpost9059.html#9059

We will add this to the documnetation so users won't have to look it up at the Microsoft site.

I tried to link the database using odbc drivers

via SQL server and encountered issues there too

We only support MS Access trough ODBC.

All other databases should be accessed via JDBC:

 

http://www.chemaxon.com/jchem/FAQ.html#dburl

Note: we recommend ODBC only for Microsoft Access. For other databases

the native JDBC drivers should be used.



    

 

I recommend to a take a look at Instant JChem:

http://www.chemaxon.com/product/ijc.html

 

It installs with a few clicks, contains an embedded database
(nothing to set up), so you can easily start importing and searching
your structure files in a few minutes.

The chemistry engine is the same as in JChem Base, so we recommend it for easy testing even if the final production system will be based on Jchem Base or on JChem Cartridge.

Kind regards,

 

Szilard