I have had some struggles with Toplink (now Eclipselink) and sequence generators as well, so I might be able to help with that.
Few questions. 1. Does the table "sequence" actually exist in your database? 2. What is your default schema, if any? 3. What is your "eclipselink.ddl-generation" mode. If it is create-tables, try drop-and-create-tables. If this doesn't help, try setting "eclipselink.ddl-generation.output-mode=both" in your persistence unit properties and paste the output of the generated sql script. 4. Could you perhaps translate "Table ou vue inexistante". I figure it says something about or the table doesn't exist, but it might point out more as to what is going wrong. Quintin Beukes On Wed, Oct 21, 2009 at 7:40 PM, El Arbi Aboussoror <[email protected]> wrote: > Hello, > When I try to store one of my entities that uses the annotation > @GeneratedValue(strategy = GenerationType.AUTO) on the "id" field I get this > error: > > *[EL Info]: 2009-10-21 18:47:35.337--ServerSession(6451154)--EclipseLink, > version: Eclipse Persistence Services - 1.1.2.v20090612-r4475 > [EL Info]: 2009-10-21 > 18:47:35.976--ServerSession(6451154)--file:/G:/data/eclipse/workspace_0/Educa-EJB/build/classes/-educaPU > login successful > [EL Warning]: 2009-10-21 18:47:36.054--ClientSession(2003839)--Exception > [EclipseLink-4002] (Eclipse Persistence Services - 1.1.2.v20090612-r4475): > org.eclipse.persistence.exceptions.DatabaseException > Internal Exception: java.sql.SQLException: ORA-00942: Table ou vue > inexistante > > Error Code: 942 > Call: UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ? > bind => [50, SEQ_GEN] > Query: DataModifyQuery(sql="UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? > WHERE SEQ_NAME = ?")* > > Maybe I forgot to set something ? > Thanks for ur help. >
