Server Installation, Configuration, and Deployment

9.2.4.6
- 9.2.7
- 9.2.6
- 9.2.5

Back Next

Database Configuration

It is highly recommended that these panels only be used for development servers. Refer to your application server user guide and your database administrators 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. Ensure that you have completed the configuration of a JNDI data source prior to completing this step. For details, see Configuration
.

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, 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] DB2 = (Default port is 50000) UTF-8 encoding is highly recommended. Example : jdbc:mysql://localhost:3306/ActiveVOS?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 user name. Unless you modified this name, it is described in the DDL schema.
For Tomcat and JBoss: Connection Timeout	1000	The maximum time to wait in milliseconds for a database connection to become available.
For Tomcat and JBoss: Minimum Connections	10	The maximum number of idle connections in the database pool.
For Tomcat and JBoss: 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.

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 this information, click Next
to save your values and to continue.

Rename Saved Search

Table of Contents

Server Installation, Configuration, and Deployment

Server Installation, Configuration, and Deployment

Database Configuration

Database Configuration