How can I map a VARCHAR db column to a byte[] using CMP?

[lloyd]

Hi,

I have some code that looks like this:

/**
* @ejb.persistence
* column-name="card_number"
*/
public abstract byte[] getCardNumber();

It doesn't work. If I change the byte[] to a String it works fine, but as it is I get the following error:

Caused by: javax.ejb.TransactionRolledbackLocalException: Internal error getting results for field member cardNumber; CausedByException is:
Got a java.lang.String[cl=0, value=abcdefg] while looking for a [B[cl=4558657]; CausedByException is:
Internal error getting results for field member cardNumber; CausedByException is:
Got a java.lang.String[cl=0, value=abcdefg] while looking for a [B[cl=4558657]
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:204)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:315)
....

With Jrun, I could just switch between byte[] and String no problem, but I can't with JBoss.

Any suggestions?

Thanks.

[aloubyansky]

You could try to use http://www.jboss.org/wiki/Wiki.jsp?page=UserTypeMapping

[lloyd]

Hi,
I don't think this will work. The example is still basically mapping an Integer to a column in the database. I want to map a byte[] to a VARCHAR column in the database. I can do it using simple SQL by doing something like preparedStatement.setBytes(1,myBytes) but I can't find out how to do this using CMP in JBoss.

I can't convert to a String as the data is encrypted - it has to be a byte array.

Any other suggestions greatly appreciared.

Thanks,
Lloyd.

[lloyd]

Oops! I've just spotted the problem. I'd missed out the @jboss.sql-type Xdoclet tag, so my jdbc-type and sql-type tags weren't being created in the jbosscmp-jdbc.xml file.

It all works fine now.

Cheers.