Hi Romain, 2016-01-21 0:56 GMT+01:00 Romain Pillot <[email protected]>:
> Anyways, i don't understand when i have to turn off/on auto commits, is it > automatly ? > Usually, you will never run your application with auto commit set to true, but you'll use a transaction layer instead (e.g. Java EE, Spring) or manage transactions manually (e.g. jOOQ, JDBC). The best option is to configure Hikari to provide Connections with auto commit set to false. > I usually make it by myself, making it thread safe with a synchronized > object. > There's no need to making transactions thread safe, normally. When you check out a Connection from a pool like Hikari, the assumption is that this Connection is used only in a single thread anyway. > And when .release() method is called ? After a fetch() ? > As soon as jOOQ doesn't need the Connection (and the PreparedStatement / ResultSet) anymore. This can be after a fetch(), or after a jOOQ transaction. -- 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/d/optout.
