Derby Type 4 Driver

The Derby JDBC driver is included with the Application Server by default, except for the Solaris bundled installation, which does not include Derby. Therefore, unless you have the Solaris bundled installation, you do not need to integrate this JDBC driver with the Application Server.

The JAR file for the Derby driver is derbyclient.jar.

Configure the connection pool using the following settings:

• Name: Use this name when you configure the JDBC resource later.

• Resource Type: Specify the appropriate value.

• Database Vendor: Derby

• DataSource Classname: Specify one of the following:

  org.apache.derby.jdbc.ClientDataSource
  org.apache.derby.jdbc.ClientXADataSource

• Properties:

  • user - Specify the database user.

    This is only necessary if Derby is configured to use authentication. Derby does not use authentication by default. When the user is provided, it is the name of the schema where the tables reside.

  • password - Specify the database password.

    This is only necessary if Derby is configured to use authentication.

  • databaseName - Specify the name of the database.

  • serverName - Specify the host name or IP address of the database server.

  • portNumber - Specify the port number of the database server if it is different from the default.

• URL: jdbc:derby://serverName:portNumber/databaseName;create=true

  Include the ;create=true part only if you want the database to be created if it does not exist.