0 Replies Latest reply on Jan 23, 2003 7:36 PM by vajiraa

    mysql - Unable to load a ResultSet column

    vajiraa

      Hi all,
      I am using mysql jdbc driver "org.gjt.mm.mysql.Driver" for cmp 1.1 entity beans on jboss-3.0.4_tomcat-4.1.12 version.

      There is a field in one of my tables of type CHAR(1),
      the java class field "char" type.
      AND
      the jaws mapping


      <java-type>char</java-type>
      <jdbc-type>CHAR</jdbc-type>
      <sql-type>CHAR</sql-type>


      If I insert data by running a insert query through the commandline tools of mysql, and try to access through CMP Beans, it gives the following error :

      please give me some clue as to what may have gone wrong.

      Thanks in advanced.

      java.sql.SQLException: Unable to load a ResultSet column 8 into a variable of type 'char': java.io.EOFException
      at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getResultObject(JDBCCommand.java:508)
      at org.jboss.ejb.plugins.jaws.jdbc.JDBCCommand.getResultObject(JDBCCommand.java:524)

      Vajira