Database configuration

Note: It is highly recommended that these panels only be used for development servers. Please refer to the Apache Tomcat user guide and your database administrators guide for configuring data sources for production installations.

The panels that follow provide the ability to configure an Apache Tomcat data source file. The information that is entered here is only a subset of the options that can be configured for a data source.

Setting Default Value Description

Driver Class:

None

(Required.) The name of your JDBC driver's implementation of java.sql.driver.

Some driver examples are shown here:

  • MySQL = com.mysql.jdbc.Driver
  • MS SQL SERVER = com.microsoft.sqlserver.jdbc.SQLServerDriver
  • ORACLE = oracle.jdbc.OracleDriver
  • DB2 = com.ibm.db2.jcc.DB2Driver

Driver url:

None

(Required.) Used to connect to your database. Typical URLS are shown here; however, please refer to your database and JDBC driver documentation for further information.

  • MySQL = jdbc:mysql://[host]:[port]/[database_name]?useUnicode=true&characterEncoding=UTF-8&characterSetResults=utf8 (Default port is 3306)

    • UTF-8 encoding is required.

  • MS SQL SERVER = jdbc:sqlserver://[host]:[port];databaseName=[database_name] (Default port is 1433)

    • UTF-8 encoding is highly recommended.

  • ORACLE = jdbc:oracle:thin:@//[host]:[port]/[database_name] (Default port is 1521)

    • UTF-8 encoding is highly recommended.

  • DB2 = jdbc:db2//[host]:[port]/[database_name] (Default port is 50000)

    • UTF-8 encoding is highly recommended.


Example:

jdbc:mysql://localhost:3306/ActiveBPEL?useUnicode=true&characterEncoding=UTF-8&characterSetResults=utf8

Database name:

ActiveVOS

(Required.) The name of your database. It must match the database_name provided in the Driver URL.

Driver jar:

None

Driver .jar file must be selected using the Select File button to the right of this field. Select your driver file so that is can be copied to the correct location.

Some driver file examples are shown here, but we strongly recommend you check the Prerequisites details before making your selection.

  • MySQL = mysql-connector-java-5.0.7-bin.jar
  • MS SQL SERVER = sqljdbc.jar
  • ORACLE = ojdbc14.jar
  • DB2 = db2jcc.jar and db2jcc_license_cu.jar

Username:

bpeluser

(Required by default.) The name associated with the privileges to access your database. Unless you modified this name, it is described in the DDL schema.

Password:

bpel

(Required by default.) The password of the above Username. Unless you modified this name, it is described in the DDL schema.

Connection Timeout:

1000

The maximum time to wait in milliseconds for a database connection to become available.

Minimum Connections:

10

The maximum number of idle connections in the database pool.

Maximum Connections:

100

The maximum number of connections in the database pool.

Validate Connection:

Checked

Checking this entry will cause the configuration wizard to attempt to connect to your database with the supplied information.

After entering the information described above, click Next to save your values and to continue.