JChem Cartridge ASP Example

The example can be found in the <JChem home>/examples/cartridge/asp directory.

The example can be used either with a regular table containing molecular structures or a JChem table (created by JChemManager or via the JChem Java API).

A regular table must contain the following columns as a minimum:

• id of type NUMERIC(10,0)
• structure of type VARCHAR2 or BLOB
• name of type VARCHAR2
• stock of type NUMERIC
• comments of type VARCHAR2

In case of a JChem table, the columns name, stock and comments above must be present in addition to the standard JChem table columns (cd_...).

Steps of installation:

1. In case a regular table is used for holding the molecular structures, a sequence must be created which will be used to generate the primary key values.
2. Populate the structure table with the necessary test data.
3. Create a JChem index on the column which holds the molecular structures.

4. Make sure that Internet Information Server is set up correctly.

5. Create a web application for JChem in Internet Information Server.

   • Open Internet Service Manager in JChem's home directory.
   • Create a virtual directory for the default web site
     • Alias: jchem
     • Path: JChem's home directory
     • Accept default settings
   See Internet Information Server's documentation for more details on creating web applications.

6. Review the constants in <JChem's URL>/examples/cartridge/asp/init.asp and modify their values if necessary. Each constant definition is copiously commented to help you decide which value is appropriate for your environment.

7. Copy the file adovbs.inc from C:\Program Files\Common Files\System\ado\ to <JChem's URL>/examples/cartridge/asp/

8. When the example system is set up, try it by loading <JChem's URL>/examples/cartridge/asp/index.asp into your browser.

   If the web server is located on your machine, load http://localhost/jchem/examples/cartridge/asp/index.asp

9. You can test different GUI-s or JVM-s if they are installed by adding one of the following options to the URL:

   • ?jvm=builtin&gui=awt (default)
   • ?jvm=builtin&gui=swing (swing.jar should be included in the system's classpath)
   • ?jvm=plugin&gui=awt
   • ?jvm=plugin&gui=swing
   The Java plugin is needed to be installed for the jvm=plugin option. Please note that the example doesn't work with the Java plugin in the case of Netscape's present versions.

10. If you receive the message "Error: Maximum number of searches allowed per minute is exceeded. Please try it later", then please for a license key that allows more frequent searching.

11. If you get the message "Unable to load archive ...", find the applet tags in the ASP files, and replace the path in codebase="../../../marvin" with the absolute path (URL). This seems to be caused by a bug in an ASP engine (iPlanet 4.0).

If you have any problem concerning the installation of the example, visit our forum or .