Hello, > AddBatch > -------------- > Is addBatch supported? I searched in the code and > couldn't find any reference. > http://download.oracle.com/javase/1.4.2/docs/api/java/sql/PreparedStatement.html#addBatch()
Currently, this is not supported. I have an open ticket for this in Trac, but I'm not sure how this could be supported conveniently by the API: https://sourceforge.net/apps/trac/jooq/ticket/621 I'm open to suggestions > Mysql Auto Increment > ------------------------------ > I would like to insert a set of records on a table containing > autogenerated keys. Is there any way of getting multiple autogenerated > keys when using > insert into t values(..).values(..). > > lastID() method returns only one. > > The InsertQueryImpl does seem to use getGeneratedKeys in two > places.But in both , only one id seems to be fetched. Yes, this is a flaw of the initial implementation for the Postgres INSERT .. RETURNING clause. I realised only later, that most RDBMS actually support returning several records from an INSERT statement. This will be fixed in 1.6.6: https://sourceforge.net/apps/trac/jooq/ticket/826 With jOOQ 1.6.5, you can only insert one record at a time, if you want to fetch generated keys. Cheers Lukas
