This content has been marked as final.
Show 4 replies
-
1. Re: MySQL Connector/J 3.1
elkner May 17, 2006 2:12 PM (in response to mduffy_lists)You already tried:
<connection-property name="zeroDateTimeBehavior" >convertToNull</connection-property>
or something like that ? -
2. Re: MySQL Connector/J 3.1
mduffy_lists May 17, 2006 3:28 PM (in response to mduffy_lists)I saw a reference to this late last night. I did not see the right syntax.
This goes in the [data_source].xml file for JBoss, is that correct? -
3. Re: MySQL Connector/J 3.1
elkner May 18, 2006 8:15 AM (in response to mduffy_lists)Here an example, which I usually place directly into the $jboss/server/$instance/deploy/ directory:
<datasources> <local-tx-datasource> <jndi-name>TestDS</jndi-name> <connection-url>jdbc:mysql://localhost:3306/test</connection-url> <driver-class>com.mysql.jdbc.Driver</driver-class> <user-name>test.dba</user-name> <password>test</password> <connection-property name="useCompression">false</connection-property> <connection-property name="logSlowQueries">true</connection-property> <connection-property name="zeroDateTimeBehavior" >convertToNull</connection-property> <!-- <connection-property name="characterEncoding" >utf8</connection-property> <connection-property name="useUnicode">true</connection-property> <connection-property name="connectionCollation">utf8_general_ci</connection-property> --> <exception-sorter-class-name >com.mysql.jdbc.integration.jboss.ExtendedMysqlExceptionSorter</exception-sorter-class-name> <valid-connection-checker-class-name >com.mysql.jdbc.integration.jboss.MysqlValidConnectionChecker</valid-connection-checker-class-name> <metadata> <type-mapping>mySQL</type-mapping> </metadata> </local-tx-datasource> </datasources>
-
4. Re: MySQL Connector/J 3.1
mduffy_lists May 19, 2006 4:00 PM (in response to mduffy_lists)Worked perfectly with the new MySQL driver.
Thx!