MySQL JDBC

From Shrubbery

Jump to: navigation, search


Standard JDBC

Driver class com.mysql.jdbc.Driver
URL jdbc:mysql://hostname and port/database name

JDBC with XA

Driver class com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
URL jdbc:mysql://hostname and port/database name

Here is an example of an XA data source with MySQL in JBoss:

   <xa-datasource>
      <jndi-name>mydbDatasource</jndi-name>
      <use-java-context>false</use-java-context>
      <track-connection-by-tx>true</track-connection-by-tx>
      <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
      <xa-datasource-property name="URL">jdbc:mysql://localhost/mydb</xa-datasource-property>
      <user-name>user</user-name>
      <password>pass</password>
   </xa-datasource>

Courtesy of Dan Allen on the Seam Forum

Personal tools