The difference between JChem Cartridge and JChem Base

What is the actual difference between JChem Cartridge and JChem Base?

Using JChem Cartridge, you can access many operations of JChem from Oracle's SQL. An SQL example for substructure searching:

Code:

select cd_id from scott.jchemtable where jc_contains(cd_smiles, 'CN1C=NC2=C1C(=O)N(C)C(=O)N2C') = 1

You can use the cartridge from any environment (C++, Visual Basic, Java, PHP, Perl, ...) where SQL statements can be invoked. However, this product works only with Oracle. See more details in the cartridge manual.





Using JChem Base, you access the whole API from Java code. (Several features can also be accessed from other environments using the ActiveX interface of JChem Base). A Java example for substructure searching:

Code:

searcher = new JChemSearch(); searcher.setQueryStructure("CN1C=NC2=C1C(=O)N(C)C(=O)N2C"); searcher.setConnectionHandler(conHandler); searcher.setStructureTable("cduser.structures"); searcher.setSearchType(JChemSearch.SUBSTRUCTURE); searcher.run();

Structure searching and SQL queries can be combined. JChem Base works with several database engines, like Oracle, MySQL, PostrgeSQL, DBII, Interbase, MS SQL Server, MS Access, etc. For more details see the Developer Guide of JChem.





Both tools can use JChem Manager for managing structure tables. JChem Cartridge requires JChem Base.