Dain I had spotted this mistake early and posted a retraction (under a different subject unfortunately) Yes indeed you are correct it was an old table design that hadn't been updated, mea maxima culpa. Best Regards, Anthony Geoghegan. J2EE Developer CPS Ireland Ltd. ----- Original Message ----- From: "Dain Sundstrom" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, September 04, 2002 3:59 PM Subject: Re: [JBoss-user] Foreignkey field issue when used with CHAR data type and CMP 2.0
> 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 > > > > ------------------------------------------------------- > This sf.net email is sponsored by: OSDN - Tired of that same old > cell phone? Get a new here for FREE! > https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > ------------------------------------------------------- This sf.net email is sponsored by: OSDN - Tired of that same old cell phone? Get a new here for FREE! https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
