Our legacy mysql database uses a table to store the next id for each table. We have been using spring JPA's TableGenerator strategy in the past, and would like to figure out how to use jooq with this. It looks like RecordListeners are the way to go, but how would I actually execute queries from within an insertStart method. There is no dsl context available, and also, I'm not sure how to ensure that it is thread safe. I was thinking using select for update would be a good way to go, but we are using myisaam (at least for the next few weeks until the upgrade *crossed fingers*) which doesn't support transactions. Makes me curious how hibernate does it without id collisions.
I guess, it would be really handy to see a code example of how to support table based id generation. Looking forward to getting on auto increment soon, but for now, and for the sake of having a reference on the internet... Thanks a ton. -- 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.
