[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[
List Home]
Re: [eclipselink-users] Silly issue with Oracle Sequencing
|
Odd, ensure you have your "eclipselink.target-database" set to Oracle in your
persistence.xml.
If you use to use TABLE sequencing, ensure you have recompiled and
redeployed your code.
rjmoraza wrote:
>
> Greetings
> I have a weird issue with Oracle sequencing...
> I'm using
> @GeneratedValue(strategy = GenerationType.SEQUENCE,
> generator="USUARIO_ID_USUARIO_SEQ")
> @SequenceGenerator(name="USUARIO_ID_USUARIO_SEQ",
> sequenceName="USUARIO_ID_USUARIO_SEQ", initialValue=1, allocationSize=1)
>
> but when I run my project I have this exception:
> java.sql.SQLException: ORA-00942: la tabla o vista no existe (the table or
> view does not exist)
>
> and I found out that EclipseLink is trying to execute the following:
> UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?
> bind => [50, USUARIO_ID_USUARIO_SEQ]
>
> where it should just do
> SELECT USUARIO_ID_USUARIO_SEQ.NEXTVAL FROM DUAL
>
> I understand EclipseLink uses TABLE as default sequence generator, but
> I've been reading everywhere that it supports Oracle sequencing as well...
> so, can anyone help me? Maybe I'm missing a parameter or something in my
> persistence.xml or my orm.xml
>
-----
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland
http://www.eclipse.org/eclipselink/
EclipseLink , http://www.oracle.com/technology/products/ias/toplink/
TopLink
Wiki: http://wiki.eclipse.org/EclipseLink EclipseLink ,
http://wiki.oracle.com/page/TopLink TopLink
Forums: http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink ,
http://www.nabble.com/EclipseLink-f26430.html EclipseLink
Book: http://en.wikibooks.org/wiki/Java_Persistence Java Persistence
--
View this message in context: http://old.nabble.com/Silly-issue-with-Oracle-Sequencing-tp29700242p29708703.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.