geronimo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bongosdude <bongosd...@gmail.com>
Subject Re: deployment for MySQL XA.
Date Wed, 21 Jan 2009 01:54:34 GMT

Forrest,

Thanks millions. These steps should go to wiki. Many people should also
benefit to know how to integrate Geronimo with MySQL.

-B


Forrest_Xia wrote:
> 
> 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
> 
>  
> 


-----
B Amigo:super:
-- 
View this message in context: http://www.nabble.com/deployment-for-MySQL-XA.-tp21536125s134p21575677.html
Sent from the Apache Geronimo - Users mailing list archive at Nabble.com.


Mime
View raw message