RE: Autogenerated keys issues

2008-07-11 Thread bobsponge
Josep, Thank you for your help but I think I can't use that solution because "Custom Sequence" as PK generation strategy is supported in Oracle and Postgres but maybe not in H2 database. It would be useful to set the cached pk size value from outside the modeler but I don't know if it's possible :

RE: Autogenerated keys issues

2008-07-10 Thread Garcia Corral, Josep
I had some similar problem with Oracle. It had to do with cached sequence numbers. The solution was to specify, in the modeler, Cached PK Size as 1. Hope this helps. Josep -Mensaje original- De: bobsponge [mailto:[EMAIL PROTECTED] Enviado el: jueves, 10 de julio de 2008 15:37 Para: user@c