0 Replies Latest reply on Oct 22, 2003 1:50 AM by maigl

    Strange SQL - Exception with JBOSS3.2.2RC4 and MySQL

    maigl Newbie

      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 ?