| Re: [eclipselink-users] Sequence in Postgresql |
The documentation is out of date. Please log a doc bug. Sequences are supported on: - Oracle - PostgreSQL - H2 - DB2 - Firebird - HSQL - Informix - Timesten Tan-Vinh Nguyen wrote: > > Hello everybody, > > I'm a great fan of Postgresql. I started to evaluate the use of > EclipseLink with Postgresql. I read at following introduction > > http://wiki.eclipse.org/Introduction_to_EclipseLink_JPA_%28ELUG%29#.40GeneratedValue > > that > > "SEQUENCE – specify that EclipseLink persistence provider use a database > sequence (see @SequenceGenerator). > > Note:SEQUENCE strategy is only supported on Oracle Database." > > I was curious so I tried it with Postgresql Sequences and it works > perfectly. > > @Id > @GeneratedValue(strategy=GenerationType.SEQUENCE, generator="PARTNER_SEQ") > @SequenceGenerator(name="PARTNER_SEQ", sequenceName="partners_id_seq", > allocationSize=1) > private Long id; > > I'm wrong or is this introduction out of date and needs an update? Any > comments for clarification are appreciated. > > Thanks in advance. > > ----- 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/Sequence-in-Postgresql-tp27493118p27516317.html Sent from the EclipseLink - Users mailing list archive at Nabble.com.