I'm using JBOSS3.2.2RC4 with MySQL.
When the container reads a Bean using CMP an exception occurs : java.sql.SQLException: Cannot convert value '2003-10-22' from column 2(2003-10-22 ) to TIMESTAMP.
The container is able to make a correct insert into MySQL, but always fails while reading.
The definition in jbosscmp-jdbc.xml is :
I tried to change the defaultmapping in standardjbosscmp-jdbc.xml for MySQL, but the error still remains.
I have no idea. When I use JBOSS3.2.2RC4 with my identical ear and DB2 - database anything is fine.
When I use JBOSS3.2.1 and MySQL with the identical ear, anything is fine, also.
Can anyone help me, pleas ?