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.

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.

Note: 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 and Oracle will set up a connection to a remote database.
Click Next.

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

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.

Step 3. Schema Name:

Enter a name for the Schema. This is the name that will display in the Projects window.
Specify the JChem Properties 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.
Click Finish. A new IJC Schema is created according to the details specified for the database connection. Note that a new Schema node ( for a local database or for a remote database) is added to the relevant project in the Projects window.