JChem simple_db_search Example

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

Steps of installation:

1. Make sure that all required software pieces to run JSP scripts using JChem Class Library are installed. Check if JSP scripts can be run.

   If you don not have an existing JSP capable web server, we recommend installing Apache Tomcat.
   

2. Include all jar files located in <JChem home>\lib\ and the jar or zip file containing the JDBC driver in the classpath of the servlet server.
   Note : This is not the same as the system classpath.
   Tomcat instructions

   Don't forget to update these files whenever you install a new version of JChem.

3. Create a web application for JChem.
   Tomcat instructions

4. Initialize a database for structure handling using JChemManager.

5. Create a table called editexample using JChemManager.

6. Import an SD file containing chemical structures into the new table.

7. When the example system is set up, you have to edit the following file: <JChem's URL>/examples/simple_db_search/init.jsp into your browser.

   You can alter the following settings here:

   • sessionVarPrefix: A sequnce for your sessions, which ensure its uniqueness.
   • driver: The class name of the JDBC driver. Please see the FAQ for examples.
   • url: The JDBC URL of the database. Please see the FAQ for examples.
   • user: The name of the database user.
   • password: The password of the database user.
   • structureTableName:The name of the table where JChem stores your chemical structures. Please see the administration guide for further information.
   • propertyTableName*:The name of the table where JChem stores its settings. Please see the administration guide and the description of multiuser options for further information.

   Modify the values of the predefined constants if it is required.

   * The property table name is

   • "JChemProperties" by default.
   • Will appear as specified, but but not stored in the browser as cookie.
   • The last entered value stored in the browser as cookie (strongest).

8. 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.

9. Please note that some less sophisticated databases like MS Access don't support parallel update or insert operations.

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