geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Forrest Xia <forres...@gmail.com>
Subject Re: deployment for MySQL XA.
Date Tue, 20 Jan 2009 03:12:51 GMT
Ok, give you a full instruction about how to setup datasource in geronimo.

There are two ways:
1. Create a datasource and deploy it as a standalone JEE connector module
2. Embed a datasource definition in an application deployment plan.

Method 1:
1. Refer to the attachment "sample-mysql-xa-ds-plan-standalone.xml" to
create a standalone JEE connector deployment plan
2. Install the mysql jdbc driver to geronimo repository via admin console,
and ensure its repository id is same as the defined one in the sample plan.
3. Use command line to deploy it, sample command for mysql xa datasource:
$GERONIMO_HOME/bin/deploy.sh -u system -p manager deploy
$GERONIMO_HOME/repository/org/tranql/tranql-connector-mysql-xa/1.2/tranql-connector-mysql-xa-1.2.rar
sample-mysql-xa-ds-plan-standalone.xml
4. Then you will able to use the datasource via its jndi name
"java:comp/env/jdbc/mysqlxads"

Method 2:
1. Refer to the attachment "sample-mysql-xa-ds-plan-embeded.xml" to create
an application deployment plan, replace web module and ejb module according
to your application
2. Install the mysql jdbc driver to geronimo repository via admin console,
and ensure its repository id is same as the defined one in the sample plan.
3. Use command line or admin console to deploy your application with the
plan. For example, the command line as follows:
$GERONIMO_HOME/bin/deploy.sh -u system -p manager deploy yourapp.ear
sample-mysql-xa-ds-plan-embeded.xml
4. Then you will able to use the datasource via its jndi name
"java:comp/env/jdbc/mysqlxads"


The transaction config element is something like:
For XA:
<connectionmanager>
  <xa-transaction>
     <transaction-caching/>
  </xa-transaction>
  ...
</connectionmanager>

For local transaction:
<connectionmanager>
   <local-transaction/>
   ...
</connectionmanager>

As to how to configure MS SQL datasource, it's similar.

Good luck!

Forrest

Mime
View raw message