Hello,

ResultSet.CONCUR_READ_ONLY is the default behaviour of
Connection.prepareStatement(String). Setting
ResultSet.TYPE_SCROLL_INSENSITIVE, however, is currently not available
through the jOOQ API. It should be, of course. So I have registered feature
request #2299 for this:
https://github.com/jOOQ/jOOQ/issues/2299

You may be able to work around this limitation by using ExecuteListeners,
intercepting relevant query executions:
http://www.jooq.org/doc/3.0/manual/sql-execution/execute-listeners/

You'll probably have to wrap your JDBC Connection and force
Connection.prepareStatement(String) to actually call
Connection.prepareStatement(String, int, int), with your desired arguments.
This wrapper could be implemented using jOOQ's DefaultConnection:
http://www.jooq.org/javadoc/latest/org/jooq/tools/jdbc/DefaultConnection.html

... or using a java.lang.reflect.Proxy

Cheers
Lukas


2013/3/2 Kent Smotherman <[email protected]>

> I'm using jOOQ 3, and I couldn't find a way of setting these parms. I
> ended up just modifying AbstractResultQuery.java in the jOOQ source for now
> to set these as the defaults so I could keep making progress in my project.
> But did I just miss how to set these parms the right way?
>
> Thanks!
>
> Kent
>
> --
> 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/groups/opt_out.
>
>
>

-- 
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/groups/opt_out.


Reply via email to