Re: Derby support

• Previous message: Mike Kienenberger: "Re: Global exception"
• Next in thread: Andrus Adamchik: "Re: Derby support"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Neal <syph..cis.co.za> wrote:
> Hi,
>
> I am using the DB2 adapter and the driver
> "org.apache.derby.jdbc.EmbeddedDriver"
>
> This works fine, but there are problems when generating auto incremented
> keys:
>
> [SQL: CREATE SEQUENCE S_books START WITH 200 INCREMENT BY 20 NO MAXVALUE
NO
> CYCLE CACHE 20] - Syntax error: Encountered "SEQUENCE" at line 1, column
8.
>
> The table structure is created successfully.
>
> It seems that a specific derby adapter must be created.

Try going back to the JDBC Adaptor and table-based auto PK generation.

Or subclass DB2 and add pk support specific to Derby.

• Next message: Joćo Paulo Vasconcellos: "Cayenne and Caché"
• Previous message: Mike Kienenberger: "Re: Global exception"
• Next in thread: Andrus Adamchik: "Re: Derby support"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Mon Feb 21 2005 - 11:42:48 EST