Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Use of sequences with EclipseLink (native) and Postgres(customized sequence under postgres and eclipseLink native)
Use of sequences with EclipseLink (native) and Postgres [message #868585] Wed, 02 May 2012 09:03 Go to next message
olive G is currently offline olive GFriend
Messages: 1
Registered: May 2012
Junior Member
i have some troubles on use of eclipseLink native (without JPA) on a postgre DB.

EclipseLink use by default a sequence name SEQUENCE. But with postgres, eclipseLink failed tu used it because this term is reserved and must be between quotes to be used correctly.

I try to specify in persistance.xml an another name :

<class-mapping-descriptor xsi:type="relational-class-mapping-descriptor">
				<field table="category" name="categoryid" xsi:type="column" />
			<events />
			<querying />
				<sequence-field table="category" name="categoryid" />

But eclipseLink continue to call the first!
I try to specify my sequence in serverSession or unitOfWork programatically. Without any success.

I would like to use my own sequence, how i could do that?

Re: Use of sequences with EclipseLink (native) and Postgres [message #868795 is a reply to message #868585] Wed, 02 May 2012 14:52 Go to previous message
Chris Delahunt is currently offline Chris DelahuntFriend
Messages: 1380
Registered: July 2009
Senior Member
Sequencing is documented here:
Sequencing defined in the session.xml will override the settings in individual descriptors, so check you do not have it define there or manually in the session (such as in a prelogin event).

The Eclipselink docs mostly show how to set it up with the workbench or java, but you can look at the documentation for TopLink if you are setting up the xml files by hand.

Best Regards,

Previous Topic:quoted name and constraint
Next Topic:Where Is The Documentation and Examples For Eclipselink Exceptions especially Persistence Exception
Goto Forum:

Current Time: Wed Mar 03 03:49:39 GMT 2021

Powered by FUDForum. Page generated in 0.01634 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top