Cannot update the database scripts for my database environment

You cannot update the database scripts for your environment in the IBM Content Navigator Configuration and Deployment Tool.

Symptoms

The test connection fails when you do any of the following steps on the Configure Your Database and Data Source task:
  • Click Test Database Connection.
  • Click Next to continue in the wizard.
  • Click Run in manual configuration and deployment mode.

Causes

The database scripts can fail to be updated for any of the following reasons:
  • One or more of the following prerequisite tasks were not completed:
    • Copy the JDBC driver to the IBM Content Navigator server.
    • Add the JDBC driver class path to the web application server.
  • A JDBC data source with the same name already exists on the web application server.
  • The database does not exist. The database must exist before you run the Configure Your Database and Data Source task.
  • The database user for the IBM Content Navigator database does not exist. The database user must exist before you run the Configure Your Database and Data Source task.
  • There are multiple versions of the JDBC JAR files for your database on the IBM Content Navigator server. IBM Content Navigator uses the oldest version and you cannot run the task Configure Your Database and Data Source task.

Resolving the problem

Address any data input errors, test the connection, and proceed to the next step.
  • If a prerequisite task was not completed, complete the prerequisite task and run the Configure Your Database and Data Source task again.
  • If a JDBC data source with the same name already exists on the web application server, use the application server administration tools to manually remove the data source before running the IBM Content Navigator Configuration and Deployment Tool.
  • The database must be created before you run the Configure Your Database and Data Source task. If the database does not exist, contact the database administrator to create the database, and then run the task again.
  • If an error is displayed when running the Configure Your Database and Data Source task, ensure that only the JAR files appropriate to your database server are installed. The JAR files should match the database server version. Remove any JAR files that are not appropriate for that version.