Versions Compared

Key

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

...

  1. Start the server and Launch the Administrative Console using the URL http://localhost:8080/console.
  2. Enter default username and password.
  3. Once in the welcome page. In console navigation, Under Applications, Select Deploy New.





  4. Create a new database pool named jdbc/userds using a xml plan file as followed.


    Code Block
    <?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>jdbc_userds</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:version>2.1.4</dep:version>
                    <dep:type>car</dep:type>
                </dep:dependency>
            </dep:dependencies>
        </dep:environment>
        <resourceadapter>
            <outbound-resourceadapter>
                <connection-definition>
                    <connectionfactory-interface>javax.sql.DataSource</connectionfactory-interface>
                    <connectiondefinition-instance>
                        <name>jdbc/userds</name>
                        <config-property-setting name="DatabaseName">userdbs</config-property-setting>
                        <config-property-setting name="UserName"/>
                        <config-property-setting name="LoginTimeout"/>
                        <config-property-setting name="Password"/>
                        <connectionmanager>
                            <xa-transaction>
                                <transaction-caching/>
                            </xa-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>
    
  5. Select the tranql-connector-derby-embed-xa-1.4.rar as the archive and above xml file as the plan, then click Deploy.





  6. Once done you can see the Database Pool jdbc/userds listed in the available database pools.





...