Hi everyone,

I have a problem with insertInto().returning().fetchOne() returning null. I have traced it back to a table.getIdentity() call returning null, and rightfully so, because in the automatically generated tables getIdentity() is not overridden and the default implementation does indeed return null.

Is there any way I can get the code generator to generate identity information for a table without relying on the database?

My situation is as follows:

- I keep track of database changes using Flyway.
- I use a Postgres database for dev and prod deployments.
- I use H2 for unit tests.
- Involved versions: H2 1.4.188, jOOQ 2.6.2, Postgres 9.3, Flyway 3.2.1.

This means that I want/need to use the same SQL scripts to generate and update the Postgres tables and the H2 tables for unit tests. I also use the H2 database to generate the jOOQ code from. As jOOQ uses different means to find out whether a column is an identity column with Postgres and H2 the code generated from the H2 database does not include identity information.


Greetings,

       Bombe
--
* David 'Bombe' Roden <[email protected]>


--
You received this message because you are subscribed to the Google Groups "jOOQ User 
Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
For more options, visit https://groups.google.com/d/optout.

Reply via email to