>From your error message it's clear that your CMP entity bean is failing to get
>the next Oracle generated sequence number. Here are some things to check:
1) Check that the Oracle Sequence your using is setup and working as expected
(Use SQLPLUS)
2)Your jbosscmp-jdbc.xml file should have the following element against each
entity bean that uses a sequence for its PK.
<entity-command name="oraclel-sequnce"/>
3) Your database is local as the RETUNING clause (used to return the sequence
number) in the SQL INSERT statement is not supported for remote databases [as
far as I remember ;-) You'll have to check this out.
Hope this helps.
Roger
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3893438#3893438
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3893438
-------------------------------------------------------
SF.Net email is Sponsored by the Better Software Conference & EXPO
September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
