Hi,
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 :
<cmp-field>
<field-name>birthDate</field-name>
<column-name>BIRTH_DATE</column-name>
<jdbc-type>DATE</jdbc-type>
<sql-type>DATE</sql-type>
</cmp-field>
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 ?