users@glassfish.java.net

Re: RE: Re: TLE vs Hibernate

From: <glassfish_at_javadesktop.org>
Date: Fri, 16 Mar 2007 12:03:53 PST

Jason,
    There is already an ehancement request to track this issue : https://glassfish.dev.java.net/issues/show_bug.cgi?id=2021 . The initial native sequencing support added to the PostgreSQL platform was for the SERIAL data type which is effectively Identity type sequencing and SEQUENCE type sequencing is not supported. You could update PostgreSQL platform to support a SEQUENCE (compare it to the Oracle platforms) and provide your platform within the persistence.xml properties which would provide you with a much more simple workaround.
   You could also switch to a SERIAL datatype for your PKs or Table based sequencing.
--Gordon
[Message sent by forum member 'gyorke' (gyorke)]

http://forums.java.net/jive/thread.jspa?messageID=208497