geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ying Tang <yingtang1...@gmail.com>
Subject Re: deployment for MySQL XA.
Date Wed, 21 Jan 2009 05:54:21 GMT
Thanks for the detailed instruction.  It has been documented here:
http://cwiki.apache.org/confluence/display/GMOxDOC22/Configuring+a+MySQL+datasource

Any comments?

2009/1/20 Forrest Xia <forrestxm@gmail.com>

> 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