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

    Strange SQL - Exception with JBOSS3.2.2RC4 and MySQL

    maigl Newbie

      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 ?