Supported database versions

Database support is primarily determined by the JDBC driver compatibility. IJC generally uses recent versions of the drivers and relies on the driver being backwardly compatible for older versions of the databases. The driver version that is used is reported in the Help -> About Instant JChem dialog in IJC. It will report something like this:
org.apache.derby/1 [10.3.2.1 080529]
which means the version number is 10.3.2.1.

Whilst it is not possible to test every version or each database, IJC is believed to support the following database versions:

Derby

The Derby database is bundled in IJC as the local database and IJC is tied to the specific current version. You can find out which is the current version by looking at the module version number of the org.apache.derby module as described above.

MySQL

IJC is tested with MySQL versions 5.x. The 4.x version are expected to work but are not tested.

For transactions and foreign key constraints to work correctly MySQL must use the InnoDB table type. Please ensure your MySQL database supports the InnoDB table type. In versions of IJC prior to 2.3 InnoDB had to be specified as the default table type (e.g. the table type that is used if no table type is specified). Since IJC 2.3 this is not longer essential, but is still recommended. Please consult your database administrator to make these configuration changes.

You can find out which is the current version by looking at the module version number of the com.mysql.jdbc module as described above.

Oracle

Oracle is tested on Oracle 9i upwards (including the XE version). Compatibility depends on the compatibility of the Oracle JDBC driver which is supposed to be backwardly compatible. We have had reports that very early versions of 9i (9.0.1.1.1) do not work due to a driver incompatibility.

You can find out which is the current version by looking at the module version number of the oracle.jdbc module as described above.

Oracle 10g's flashback tables (table names begriming with BIN) are ignored by IJC.

JChem cartridge for Oracle

Use of the JChem cartridge is tested on Oracle 10g and 11g. Oracle 10g with the latest patch sets is recommended as this has been found to be more stable than the 11g release. The JChem cartridge does not run in the XE version of Oracle. See the JChem Oracle Cartridge page for more information on setting up and using the JChem cartridge.

Problems?

If you find problems with particular database versions then please report them to the IJC forum.