Adding a New Schema

A Schema is the IJC term for the contents of a database that can be accessed from a particular database connection that you set up. When you create a database connection you are creating an IJC Schema that lets you work with those database contents. In doing so you are creating some special database tables (names beginning with IJC_) in which IJC stores its meta data and user data.

Connecting to a database is a necessary step to working in IJC. If you chose to create a project with a local database , a database and its respective connection has already been set up. If you created an empty IJC project, or if you want to connect to multiple databases, you can create a new connection at any time.

To connect to a remote database you must obtain an IJC license key. To purchase a license key, please email: sales at chemaxon dot com To enter a license see Adding Instant JChem Licenses

To add a new Schema:

In the Projects window, right-click the selected project and choose New Schema. The New Connection wizard opens to guide you through the process:

Step 1. Choose Template:

  • Select a database template. This step allows you to choose the appropriate template for your database type. The Embedded Derby connection will set up a new local database. MySQL, Oracle or Microsoft SQL Server will set up a connection to a remote database.

  • Click Next.

images/download/attachments/42173086/mysql.png

The instructions for the remaining steps depend on whether you have selected a local or remote database. If you selected a local database then this next step is not seen.

Step 2. Database Connection:

  • Enter the database URL, username and password. You may need to ask your database administrator for these details.

  • Specify whether you wish to have the database password stored. Note: the password will be stored in a file on your computer.

  • Enter any extra details that might be needed for your database type e.g. the name of the database schema for Oracle. Usually you should leave this as the schema for the database user, but in some cases you might need to specify a different database schema. This is the database schema that is used as the default schema (the one that contains the IJC_* tables).

  • You can optionally encrypt the connection details (URL, username and password) by specifying a password. This prevents the connection details being stored in plain text.
    Note: This only prevents the details being directly visible. The level of security is relatively low.

  • Click Next.

images/download/attachments/42173086/mysql2.png

Note about database schemas: Currently IJC only supports use of the default schema name for the database user in Oracle (e.g. the database username in upper case). MySQL does not support schemas so this property is not present for MySQL databases. The term 'schema' used here is distinct from the IJC term Schema which represents the contents of a database you are connected to and the IJC_* tables that contain the IJC meta data and user data.

Step 3. Schema Name:

  • Enter a name for the Schema. This is the name that will display in the Projects window.

  • Specify the JChem property Table name. You can change the property table name if you want, but the default JChemProperties is recommended. You can use the Verify button to check whether the properties table already exists. The property table is used by JChem for storing internal information. It is required by JChem, and should not be directly manipulated.

  • Click Finish. A new IJC Schema is created according to the details specified for the database connection. Note that a new Schema node ( images/download/attachments/42173051/Connection16.gif for a local database or images/download/attachments/42173051/ConnectionRemote.gif for a remote database) is added to the relevant project in the Projects window.

images/download/attachments/42173086/mysql3.png