[jboss-user] [Installation, Configuration & DEPLOYMENT] - Re: Persistence config with mysql.

[2lopez]

First of all, thanks for your interest and support.

/home/encore/jboss-4.0.4.GA/server/default/deploy/mysql-ds.xml :
<!-- $Id: mysql-ds.xml,v 1.1 2006/07/20 15:05:48 fran Exp $ -->
  | <!--  Datasource config for MySQL using 3.0.9 available from:
  | http://www.mysql.com/downloads/api-jdbc-stable.html
  | -->
  | 
  | <datasources>
  | 
  |   <local-tx-datasource>  
  |     <jndi-name>cacv2</jndi-name>
  |     <connection-url>jdbc:mysql://127.0.0.1:3306/jbossdb</connection-url>
  |     <driver-class>com.mysql.jdbc.Driver</driver-class>
  |     <user-name>roberto</user-name>
  |     <password></password>
  |     <max-pool-size>200</max-pool-size> 
  |     <blocking-timeout-millis>5000</blocking-timeout-millis>
  |     <idle-timeout-minutes>1</idle-timeout-minutes>
  |     <use-java-context>false</use-java-context>
  |     <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter </exception-sorter-class-name>
  |     <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
  |     <metadata>
  |        <type-mapping>mySQL</type-mapping>
  |     </metadata>
  |   </local-tx-datasource>
  | 
  | </datasources>

${JBOSS_HOME}/server/default/conf/standardjaws.xml :
<?xml version="1.0" encoding="UTF-8"?>
  | 
  | <!DOCTYPE jbosscmp-jdbc PUBLIC
  |     "-//JBoss//DTD JBOSSCMP-JDBC 3.0//EN"
  |     "http://www.jboss.org/j2ee/dtd/jbosscmp-jdbc_3_0.dtd">
  | 
  | <!-- ===================================================================== -->
  | <!--                                                                       -->
  | <!--  Standard Jaws Configuration                                          -->
  | <!--                                                                       -->
  | <!-- ===================================================================== -->
  | 
  | <!-- $Id: standardjaws.xml,v 1.30 2002/06/27 19:26:28 dsundstrom Exp $ -->
  | 
  | <jaws>
  |    <datasource>java:/DefaultDS</datasource>
  |    <type-mapping>mySQL</type-mapping>
  |    <debug>false</debug>
  |    [... standard config copied from the examples ...]
  | </jaws>
  | 

These are the only files modified, if I remember well.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4145725#4145725

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4145725