Page History

...

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 pullscroll-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.

...

Alternatively you could create your own deployment plan and deploy the database connection pool directly from the commad line with the Deploy 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.

Code Block

	xml
	xml
borderStyle	solid
title	Derby_Test-plan.xml

<?xml version="1.0" encoding="UTF-8"?>
<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.12">
    <dep:environment xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.12">
        <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.13.0<1</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>

...

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

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

No Format

bgColor	#000000
borderStyle	solid

Dd:\geronimo-jetty-j2ee-1.1-Tomcat2\bin>deploy --user system --password manager deploy \tmp\Derby_Test-plan.xml ..\repository\org\tranql\tranql-connector-ra\1.23\tranql-connector-ra-1.23.rar
Using GERONIMO_BASE:   D:\geronimo-jetty-j2ee-1.1-Tomcat2
Using GERONIMO_HOME:   D:\geronimo-jetty-j2ee-1.1-Tomcat2
Using GERONIMO_TMPDIR: D:\geronimo-jetty-j2ee-1.1-Tomcat2\var\temp
Using JRE_HOME:        C:\Java\jdk1.5.0_06\\jre
    Deployed console.dbpool/Derby_Test/1.0/rar

...

Child pages

Versions Compared

Old Version 3

New Version Current

Key