test

Sun Java System Web Server 7.0 Developer's Guide to Java Web Applications

ProcedureTo Configure a Simple Connection Pool

In this example procedure, the connection pool uses the ORACLE JDBC driver.

  1. Start wadm 


    $ ./bin/wadm --user=admin
Please enter admin-user-password>user-admin-password
Sun Java System Web Server 7.0 B01/02/2006 14:22
wadm>

  2. Verify the list of available configurations.


    wadm>list-configs

  3. Create the jdbc-resource configuration.

    For more information about all possible elements, see Sun Java System Web Server 7.0 Administrator's Configuration File Reference.


    wadm>create-jdbc-resource --config=test 
--datasource-class=oracle.jdbc.pool.OracleDataSource jdbc/MyPool

  4. Add properties to jdbc-resource.

    Properties are primarily used to configure the driver's vendor-specific properties. In the following example, the values for the properties url, user, and password are added to jdbc-resource.


    wadm>list-jdbc-resource-userprops --config=test --jndi-name=jdbc/MyPool 
password=mypassword user=myuser url=jdbcZ:oracle:thin:@hostname:1421MYSID

  5. Enable the connection validation.


    wadm>set-jdbc-resource-prop --config=test --jndi-name=jdbc/MyPool
connection-validation-table-name=test connection-validation=table
CLI201 Command "set-jdbc-resource-prop" ran successfully

  6. Change the pool setting.

    In this example, the maximum number of connections is set to 100.


    wadm>set-jdbc-resource-prop --config=test --jndi-name=jdbc/MyPool max-connections=100
CLI201 Command "set-jdbc-resource-prop" ran successfully.

  7. Deploy the configuration.


    wadm>deploy-config test
CLI201 Command "deploy-config" ran successfully.

    You can install a JDBC driver with Java Archive (JAR) files in one of the following ways:

    • Copy the driver's JAR file into the server's instance library directory. JAR files in the instance library directory will automatically load and available for server.

    • Modify the JVM class-path- suffix to include JDBC drivers jar file. The new value will overwrite the old value of the element. For example, wadm> set-jvm-prop --config=test class-path-suffix=/export/home/lib/classes12.jar