0 Replies Latest reply on May 11, 2002 3:56 PM by Andrzej Kierzek

    Character type problems for MySQL

    Andrzej Kierzek Newbie

      Hi,

      I use jboss-3.0.0RC1 and MySQL. One of the fields in the bean has the java type Character. It seems that this field cannot be loaded from the database:

      java.sql.SQLException: Unable to load a ResultSet column 5
      into a variable of type 'java.lang.Character'

      When I changed the field into String it worked. I don't
      have also any problems with Integer type. Does anybody know how to use Character type ? I have already tried to alter the type mapping into:

      <java-type>java.lang.Character</java-type>
      <jdbc-type>CHAR</jdbc-type>
      <sql-type>CHAR(1)</sql-type>

      but it did not help in spite that the column 5 in the
      database has a type CHAR(1).

      andrzejk