are we using Oracle cartridge?

We recently received an email that the JChem Oracle cartridge would soon no longer be available under the academic package license. I don't think we are using the JChem Oracle cartridge -- we use the JDBC connector to our Oracle database -- but how do we tell for sure?

Hi Bob,

1)

The JChem Oracle Cartridge provides access to ChemAxon functionality via SQL statements (opposed to using Java classes as for JChem Base for example).

https://www.chemaxon.com/products/jchem-oracle-cartridge/

It also has to be separately installed into Oracle and also runs as a service process outside Oracle (but often on the same machine).

I would expect your colleagues would remember / know about it? :)

 

2)

If you use Instant JChem you should tell from the entity types:

https://docs.chemaxon.com/display/instantjchem/Editing+Entities

 

3)

If you have access to the source code, then you can look if you use JChem Base or the cartridge (or unlikely both).

For example if you use "JChemSearch" for database structure search, then you are using JChem Base.

If you use "jc_compare" or similar calls in SQL then you are using the cartridge.

In fact most of the SQL ApI starts with "jc_", so you might as well look for that

https://docs.chemaxon.com/display/jchemcartridge/Cartridge+API

 

4)

If all else fails, you may also look for cartridge calls (such as described above) in the Oracle logs.

If there are none, I would shut down the JChem Cartridge Service, if still no complaint then uninstall the cartridge.

 

Best,

 

Szilard