problem with byte data type in jboss 4.0.3+Ingres 3.0.1

[grp_eee]

We are using jboss 4.0.3 with Ingres 3.0.1 as our datasource . We are using CMP 2.0 as our persistence layer.

When we try to update any field of byte datatype we get the following exception trace.It seems to be some problem with byte type-mapping in standardjbosscmp-jdbc.xml configuration file.Can you please let us know the correct type-mapping for byte data type for Ingres?or Any other possible reason for this error?

Caused by: javax.ejb.EJBException: Internal error setting parameters for field password; CausedByException is:
Invalid datatype conversion.
at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.setArgumentParameters(JDBCAbstractCMPFieldBridge.java:362)
at org.jboss.ejb.plugins.cmp.jdbc.bridge.JDBCAbstractCMPFieldBridge.setInstanceParameters(JDBCAbstractCMPFieldBridge.java:336)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.execute(JDBCStoreEntityCommand.java:117)
at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.storeEntity(JDBCStoreManager.java:651)
at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPersistenceManager.java:413)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.storeEntity(CachedConnectionInterceptor.java:279)
at org.jboss.ejb.EntityContainer.storeEntity(EntityContainer.java:743)
at org.jboss.ejb.GlobalTxEntityMap$2.synchronize(GlobalTxEntityMap.java:134)
at org.jboss.ejb.GlobalTxEntityMap$GlobalTxSynchronization.synchronize(GlobalTxEntityMap.java:253)
at org.jboss.ejb.GlobalTxEntityMap$GlobalTxSynchronization.beforeCompletion(GlobalTxEntityMap.java:302)
at org.jboss.tm.TransactionImpl.doBeforeCompletion(TransactionImpl.java:1473)
at org.jboss.tm.TransactionImpl.beforePrepare(TransactionImpl.java:1092)
at org.jboss.tm.TransactionImpl.commit(TransactionImpl.java:306)
... 55 more

[grp_eee]

We are really in urgent need of help to solve this issue.
Any help on this would be greatly appreciated.

[jonefun]

I presume that your field "Password" is more than a single byte but an array of bytes. The mapping in 4.0.3 maps a Byte to a TinyInt and fails to convert your Byte[] into a series of TinyInts.

If your password is an encrypted byte array then perhaps you could try mapping byte to a blob field or failing that Base64 encode the data and store as a standard Varchar field.