Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For the most part, deployment plans for database connection pool will be very similar from each other. However, depending on the database the pool will be connecting to, you may need to specify some additional parameters.

Embedded Derdy DB

...

Code Block

...

xml
xml

...

borderStyle

...

solid

...

title

...

Embedded Derdy DB connection pool

<?xml version="1.0" encoding="UTF-8"?>

...


<connector xmlns="http://geronimo.apache.org/xml/ns/j2ee/connector-1.2">

...


    <dep:environment xmlns:dep="http://geronimo.apache.org/xml/ns/deployment-1.2">

...


        <dep:moduleId>

...


            <dep:groupId>console.dbpool</dep:groupId>

...


            <dep:artifactId>TimeReportPool</dep:artifactId>

...


            <dep:version>1.0</dep:version>

...


            <dep:type>rar</dep:type>

...


        </dep:moduleId>

...


        <dep:dependencies>

...


            <dep:dependency>

...


                <dep:groupId>org.apache.geronimo.configs</dep:groupId>

...


                <dep:artifactId>system-database</dep:artifactId>

...


            </dep:dependency>

...


        </dep:dependencies>

...


    </dep:environment>

...


    <resourceadapter>
        <outbound-resourceadapter>
            <connection-definition>
                <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>

...


                <connectiondefinition-instance>
                    <name>TimeReportPool</name>
                    <config-property-setting name="Driver">org.apache.derby.jdbc.EmbeddedDriver</config-property-setting>

...


                    <config-property-setting name="ConnectionURL">jdbc:derby:TimeReportDB</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>

Security

Resources

Applications

...