Re: [eclipselink-users] Exact DDL for sequence table?

["Michael O'Brien" <michael.obrien@xxxxxxxxxx>]

Laird,
    Hi, try logging on full, and use either "both" or "database" for the output-mode in persistence.xml - you should see the logs for both the drop and create of the sequence table - here on Oracle for instance.

            <property name="eclipselink.logging.level" value="ALL"/>           
            <property name="eclipselink.ddl-generation" value="drop-and-create-tables"/>
            <property name="eclipselink.ddl-generation.output-mode" value="database"/>

[EL Finest]: 2010-05-19 09:54:00.372--ServerSession(7486844)--Thread(Thread[main,5,main])--Execute query DataModifyQuery(sql="CREATE SEQUENCE EL_CELL_SEQ INCREMENT BY 25 START WITH 25")
[EL Fine]: 2010-05-19 09:54:00.372--ServerSession(7486844)--Connection(29056009)--Thread(Thread[main,5,main])--CREATE SEQUENCE EL_CELL_SEQ INCREMENT BY 25 START WITH 25

    in relation to
    @Id
    @SequenceGenerator(name="EL_SEQUENCE_CELL", sequenceName="EL_CELL_SEQ", allocationSize=25)
    @GeneratedValue(generator="EL_SEQUENCE_CELL")
    private BigInteger id;


    thank you
    /michael
    http://www.eclipselink.org


Laird Nelson wrote:

Hello; I have several entities that use the AUTO GenerationType.

I am moving away from letting EclipseLink generate the DDL and turning that task over to LiquiBase (http://liquibase.org).

EclipseLink appears--and I'm sure it's documented somewhere--to prefer the use of its own sequence table in many cases.

That's fine, but since EclipseLink is no longer generating the DDL, I need to know the exact DDL I should be providing to create this table ahead of time.

Could someone please provide the DDL that creates EclipseLink's internal sequence table?

If it matters (I hope not), I'm currently testing on the H2 database, version 1.134.

Thanks,
Laird

_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users