Re: [JBoss-user] Foreignkey field issue when used with CHAR data type and CMP 2.0

[Dain S. <da...@da...>]

Anthony Geoghegan wrote:
> I'm using JBOSS 3.01.RC1 and Oracle 8i Enterprise.
> I get the following Oracle error when using CMP and creating a EJB-QL
> relation on a foreign key called TRANSACTION_ID
> TRANSACTION_ID is a CHAR(20) as are all my keys as I use abase64 encoded
> UUID generation technique for keys.
> 
> Error:
> 2002-09-04 12:59:09,875 ERROR [org.jboss.ejb.GlobalTxEntityMap] Store failed
> on entity: 4dMAQiOEFMcxCv7FIMHc
> javax.ejb.EJBException: Store failed; CausedByException is:
>  ORA-01722: invalid number
> 
> Why is JBOSS assuming that foreign keys are NUMBER types?
> Can I change this?

JBoss makes no such assumption.  This is an oracle error message and 
number.  Here is some info on this error:

http://www.orafaq.com/error/ora-01722.htm

Now the question is why does oracle think that your TRANSACTION_ID field 
is a number.  Did you allow JBoss to create the table for you or did you 
create it your self?  Either way check the sql used to create the table. 
  Also turn the log level up to DEBUG for the org.jboss.ejb.plugins.cmp 
to DEBUG so you can see the insert/ update sql.

-dain