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??