The correct spelling is zeroDateTimeBehavior
| <datasources> | <local-tx-datasource> | <jndi-name>MySqlDS</jndi-name> | <connection-url>jdbc:mysql://localhost:3306/myApp</connection-url> | <driver-class>com.mysql.jdbc.Driver</driver-class> | <user-name>user</user-name> | <password>password</password> | <config-property name="zeroDateTimeBehavior" type="java.lang.String">convertToNull</config-property> | <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) --> | <metadata> | <type-mapping>mySQL</type-mapping> | </metadata> | </local-tx-datasource> | | </datasources> | Anyway, there is still an error : SQLException : Value '0000-00-00' can not be represented as java.sql.Timestamp Anybody knows how to solve this problem? Thank you. View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3865640#3865640 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3865640 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
