Database configuration

Note: It is highly recommended that these panels only be used for development servers. Please refer to the application server user guide and your database administrator's guide for configuring data sources for production installations.

The panels that follow provide the ability to configure a 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.

Validate Connection. After you enter all required database connection information and click Next, the utility checks that your driver jar and URL are valid and that the database name matches the name in the URL. The utility does not check the username and password of the database. If the server cannot make a connection because these are in error, you can re-run the configure-deploy utility and enter new names. All other values are preserved.

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