Hi Ralf and all. Thanks for your reply.
After doing more research and extensive testing, it was discovered that the issue was not a Castor mapping type one, but rather a bug in WebLogic. Apparently, when using WebLogic6.1sp2's jDriver for Oracle with a multibyte (UTF8) Oracle database, the ORA-01461 error will occur when trying to do any type of insert into a table. The solution/workaround requires: 1) setting an environment variable in the script that starts up the particular WebLogic instance that will run your web application, and 2) adding a parameter to the Connection Pool that your application uses. The specifics of this workaround can be found at: http://edocs.bea.com/wlp/docs40/relnotes/relnotes.htm#150717 and scrolling down to "CR 60341". Thanks again. --- Ralf Joachim <[EMAIL PROTECTED]> wrote: > Hello Konrad, > > we use > > <class name="Consumer" identity="id" > key-generator="CNSMR_SEQ"> > <map-to table="CNSMR"/> > <field name="id" type="integer"> > <sql name="CNSMR_ID" type="numeric"/> > </field> > </class> > > regards > Ralf > > > ----- Original Message ----- > From: "Konrad" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, October 27, 2003 7:50 PM > Subject: [castor-dev] [JDO] Java type mapping for > NUMERIC(10) - ORA-01461: can bind a LONG value only > for insert into a LONG column > > > > Hello. > > > > Does anyone know what the correct Java type > mapping > > (i.e. Java field type) should be for a database > field > > of type NUMBER(10) in Oracle? I'm using Oracle > > sequences for obtaining the ID for the entities > and > > have tried: > > > > <class name="Consumer" identity="id" > > key-generator="CNSMR_SEQ"> > > <map-to table="CNSMR"/> > > <field name="id" type="big-decimal"> > > <sql name="CNSMR_ID" type="numeric"/> > > </field> > > </class> > > ------------------------------------------------ > > <class name="Consumer" identity="id" > > key-generator="CNSMR_SEQ"> > > <map-to table="CNSMR"/> > > <field name="id" type="long"> > > <sql name="CNSMR_ID" type="long"/> > > </field> > > </class> > > ------------------------------------------------ > > <class name="Consumer" identity="id" > > key-generator="CNSMR_SEQ"> > > <map-to table="CNSMR"/> > > <field name="id" type="integer"> > > <sql name="CNSMR_ID" type="integer"/> > > </field> > > </class> > > > > > > but I continue to receive the below error when > using > > WebLogic6.1sp2's proprietary Oracle driver: > > > > ORA-01461: can bind a LONG value only for > insert > > into a LONG column > > > > > > This problem is not happening with Oracle's > standard > > JDBC driver, which I unfortunately cannot use. > > > > Any suggestions would be greatly appreciated. > > > > Thank you. > > > > > > __________________________________ > > Do you Yahoo!? > > Exclusive Video Premiere - Britney Spears > > http://launch.yahoo.com/promos/britneyspears/ > > > > > ----------------------------------------------------------- > > > If you wish to unsubscribe from this mailing, send > mail to > > [EMAIL PROTECTED] with a subject of: > > unsubscribe castor-dev > > > > ----------------------------------------------------------- > > If you wish to unsubscribe from this mailing, send > mail to > [EMAIL PROTECTED] with a subject of: > unsubscribe castor-dev > __________________________________ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
