This one time, at band camp, [EMAIL PROTECTED] said:
>can anyone help me with this?
>
>
>I'm using:
><key-generator name="SEQUENCE">
><param name="returning" value="true"/>
></key-generator>
>
>
>in:
><!-- class -->
> <class name="GdmsDataBaseSchema.FILES" identity="id" key-generator="
>SEQUENCE">
> <!-- table -->
> <map-to table="GDMS.FILES"/>
></class>
>
>
>
>I get:
>Nested error: java.sql.SQLException: ORA-06550: line 1, column 184:
>PLS-00201: identifier 'GDMS"".""FILES_SEQ.NEXTVAL' must be declared
>ORA-06550: line 1, column 7:
>PL/SQL: SQL Statement ignored
>
>
>
>Do I have to define the variable 'FILES_SEQ.NEXTVAL' in my
>java classes??
Youssef,
There's no need to define the FILES_SEQ.NEXTVAL in your Java classes.
Have you created a sequence on the GDMS.FILES table? Is the sequence
named GDMS.FILES_SEQ? Execute the following SQL:
select gdms.files_seq.nextval from dual
Does this yield a sequence number according to the FILES_SEQ
definition?
Bruce
--
perl -e 'print unpack("u30","<0G)[EMAIL PROTECTED]&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");'
The Castor Project
http://www.castor.org/
Apache Geronimo
http://incubator.apache.org/projects/geronimo.html
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
