0 Replies Latest reply on Nov 22, 2002 7:52 AM by Lorena

    java.sql.SQLException: Values can be retrieved only left to

    Lorena Newbie

      I'm using Caché 4 as a database for JBoss, but while trying to recover a Date type field from the database, I get the following error:

      =========================================
      2002-11-22 10:20:24,081 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackException, causedBy:
      java.sql.SQLException: Values can be retrieved only left to right
      at com.intersys.jdbc.CacheResultSet.getObject(CacheResultSet.java:740)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil.getObjectResult(JDBCUtil.java:262)
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCUtil.getResult(JDBCUtil.java:202)....

      =================================================
      The mapping for this field at jbosscmp-jdbc.xml is
      <cmp-field>
      <field-name>cltData</field-name>
      <column-name>cltData</column-name>
      <jdbc-type>DATE</jdbc-type>
      <sql-type>date</sql-type>
      </cmp-field>


      Any ideas about it??