Configuring database pools

Import database pools from JBoss 4

You can create new pools by clicking on the Using the Geronimo database pool wizard link on the Database Pools portlet. This wizard will guide you through a four easy steps procedure.

Refer to Configuring DB2 Datasource for an additional working example on datasources with multiple jar (driver+license) files.

First you need to specify the name of the database pool and the database type.

Then you select the JDBC drivers which, by default, it has been pre-filled based on the database type you selected in the previous step. You also have to select the driver JAR from the pull-down menu and then specify the database name. For this example a test database was previously created, this is a single step procedure and it is explained in Create a database.

The following step lets you configure some connection parameters such as pool size (min and max) and timeouts. Once you are satisfied with the paramenters click on Test Connetion.

When you successfully tested the connection, click on Deploy. Alternatively you can click on Show Plan, this option shows you the deployment plan for this database pool and lets you edit it. Additional instructions on how to manually deploy a DB plan may be found in the Configuring DB2 Datasource section.

Once deployed, Derby_Test should be listed along with all the other database pools.

Alternatively you could create your own deployment plan and deploy the database connection pool directly from the commad line with the Deployer tool. The following example illustrates the deployment plan that can be used to deploy the same database pool you just deployed via the Administration Console.

<?xml version="1.0" encoding="UTF-8"?>
<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.1">
    <dep:environment xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.1">
        <dep:moduleId>
            <dep:groupId>console.dbpool</dep:groupId>
            <dep:artifactId>Derby_Test</dep:artifactId>
            <dep:version>1.0</dep:version>
            <dep:type>rar</dep:type>
        </dep:moduleId>
        <dep:dependencies>
            <dep:dependency>
                <dep:groupId>org.apache.derby</dep:groupId>
                <dep:artifactId>derby</dep:artifactId>
                <dep:version>10.1.1.0</dep:version>
                <dep:type>jar</dep:type>
            </dep:dependency>
        </dep:dependencies>
    </dep:environment>
    <resourceadapter>
        <outbound-resourceadapter>
            <connection-definition>
                <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
                <connectiondefinition-instance>
                    <name>Derby_Test</name>
                    <config-property-setting name="Driver">org.apache.derby.jdbc.EmbeddedDriver</config-property-setting>
                    <config-property-setting name="ConnectionURL">jdbc:derby:test</config-property-setting>
                    <connectionmanager>
                        <local-transaction/>
                        <single-pool>
                            <max-size>10</max-size>
                            <min-size>0</min-size>
                            <match-one/>
                        </single-pool>
                    </connectionmanager>
                </connectiondefinition-instance>
            </connection-definition>
        </outbound-resourceadapter>
    </resourceadapter>
</connector>

If you want to use this option copy this file to you local drive and run the following command from the <geronimo_home>\bin directory:

deploy --user system --password manager deploy <plan_home>\Derby_Test-plan.xml ..\repository\tranql\tranql-connector\1.2\tranql-connector-1.2.rar

You should see a confirmation message similar to the one shown in the following example.

D:\geronimo-1.1-Tomcat\bin>deploy --user system --password manager deploy \tmp\Derby_Test-plan.xml ..\repository\tranql\tranql-connector\1.2\tranql-connector-1.2.rar
Using GERONIMO_BASE:   D:\geronimo-1.1-Tomcat
Using GERONIMO_HOME:   D:\geronimo-1.1-Tomcat
Using GERONIMO_TMPDIR: D:\geronimo-1.1-Tomcat\var\temp
Using JRE_HOME:        C:\Java\jdk1.5.0_06\
    Deployed console.dbpool/Derby_Test/1.0/rar

For further details on this option refer to the Deployment plans section.