Versions Compared

Key

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

...

The Geronimo repository is located at <geronimo_home>/repository. Inside this directory, create a directory called mysql/jarsmysql-connector-java/3.1.14-bin and copy the mysql-connector-java-3.1.14-bin.jar file into it. Now, you need to create the data source deployment plan.

...

Code Block
xml
xml
borderStylesolid
titleData source deployment plan
<?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.1">
    <dep:moduleId>
	  <dep:groupId>user</dep:groupId>
	  <dep:artifactId>jdbcdatasource</dep:artifactId>
	  <dep:version>2.0</dep:version>
	  <dep:type>car</dep:type>
	</dep:moduleId>
	<dep:dependencies>
	  <dep:dependency>
	    <dep:groupId>mysql</dep:groupId>
		<dep:artifactId>mysql-connector-java</dep:artifactId>
		<dep:version>3.1.14-bin</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>TradeDS</name>

        <config-property-setting name="UserName">

          root

        </config-property-setting>

        <config-property-setting name="Password">

          password

        </config-property-setting>

        <config-property-setting name="Driver">

          com.mysql.jdbc.Driver

        </config-property-setting>

        <config-property-setting name="ConnectionURL">

          jdbc:mysql://localhost:3306/tradedb

        </config-property-setting>

        <config-property-setting name="CommitBeforeAutocommit">

           false

        </config-property-setting>

        <config-property-setting name="ExceptionSorterClass">

           org.tranql.connector.NoExceptionsAreFatalSorter

        </config-property-setting>



        <connectionmanager>

          <local-transaction/>

          <single-pool>

             <max-size>10</max-size>

             <min-size>0</min-size>

             <blocking-timeout-milliseconds>

                5000

              </blocking-timeout-milliseconds>

              <idle-timeout-minutes>

                30

              </idle-timeout-minutes>

              <match-one/>

          </single-pool>

        </connectionmanager>

      </connectiondefinition-instance>

    </connection-definition>

  </outbound-resourceadapter>

</resourceadapter>

</connector>

The listing above shows the plan for deploying a J2EE connector which will provide JDBC access to the database. The root element is the <connector> element. This element has the following four attributes:

...