The feedback I was getting for jOOQ 1.5.4 was mostly good. And there's more
feedback for the next round.
*
*A nice idea would be to allow for Oracle optimiser hints of the form

SELECT /*+FIRST_ROWS*/ a, b, c FROM ...
>

I'm running a question on stackoverflow to find out about other types of
hints in other dialects:
http://stackoverflow.com/questions/5263616/oracle-style-execution-hints

This may be included in a future version of jOOQ, soon. On the other hand,
it becomes clear that jOOQ's restrictions on type-safety as far as the
Field<T> parameter is concerned, are too restrictive. There already was a
ticket concerning comparison of different <T> types:
http://sourceforge.net/apps/trac/jooq/ticket/293

Now it also shows that Oracle stored procedures always bind <T> to
BigDecimal, if the parameter is a NUMBER. This makes it hard to use Oracle
stored functions embedded in SQL:
https://sourceforge.net/apps/trac/jooq/ticket/302

These are interesting use cases that will have to be considered in future
versions.

Cheers
Lukas

Reply via email to