Hi Lukas,
Thanks for the update. We have integrated jooq as the lib
for adhoc queries in the framework.
We haven't really used the add batch support in jooq for now as we generated
the code that talks directly with the underlying connection lib.
As part of the integration process, we had to make some minor modifications
to the jooq code . We have those changes checked in a private github
repository for now. We would have a consolidated list of changes once we
have finished with our framework and also released our service. We would by
then also have a good understanding of jooq code.
We could then discuss on
- Changes that are acceptable by the jooq community to be added to the
core.
- Changes that were done due to our wrong understanding.
- And ones that we have to maintain separately.
Most of the changes were related to making some "impl" classes public to
allow for use/(and extension) outside the org.jooq.impl package . And other
notable ones are
- We have split the TableRecord interface into TableRecord and
LiveTableRecord (forget the naming). LiveTableRecord contains the db ops.
- Support for "JoinProvider" (again forget the naming) interface in
join methods in order to support adding of both table and the join
conditions.
- Extension to the configuration that allows for closing connections
after the query execution.
thanks and regards,
-kps-
On Wed, Oct 26, 2011 at 1:46 AM, Lukas Eder <[email protected]> wrote:
> Hello,
>
> Please note that I have added JDBC batch operation support on trunk.
> Find the full discussion here:
> https://groups.google.com/forum/#!topic/jooq-user/o52n5u3XDTk
>
> Cheers
> Lukas
>
> 2011/9/13 Saravanan KP <[email protected]>:
> > Hi lukas,
> > Thanks a lot for the feature.
> > As I am currently working on the framework I had mentioned earlier ,
> > I will not be able to test it immediately. Will let you know by this
> > week end.
> >
> > regards,
> > -kps-
> >
> >
> >
> > On Sep 12, 11:29 pm, Lukas Eder <[email protected]> wrote:
> >> Hello,
> >>
> >> > 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(..).
> >>
> >> Fetching several ID values from multi-record insert statements is now
> >> supported with jOOQ 1.6.6. The DSL syntax to achieve this behaviour is
> >> this:
> >>
> >> Result<?> result = create
> >> .insertInto(MY_TABLE, MyTable.COL1, MyTable.COL2)
> >> .values(1, "a")
> >> .values(2, "b")
> >> .values(3, "c")
> >> .returning(MyTable.ID)
> >> .fetch();
> >>
> >> This currently works for DB2, HSQLDB, MySQL, and Postgres. Other JDBC
> >> drivers don't seem to fully support selecting several generated keys.
> >> See the manual for more info about INSERT support in jOOQ:
> >>
> >> https://sourceforge.net/apps/trac/jooq/wiki/Manual/JOOQ/Query
> >
>
