Hi Dario, Thanks for reporting. Before we analyse any further, can you check if you're encountering this issue here? https://groups.google.com/forum/#!topic/jooq-user/-emw8ljFebQ
There were issues with users using jOOQ's DataSourceConnectionProvider with Spring. These issues appear to have been resolved with jOOQ 3.2.2 Cheers Lukas 2013/12/27 Dario <[email protected]> > Hi all, > > We're experiencing the following exception while using JOOQ + Spring: > > org.jooq.exception.DataAccessException: SQL [select subscriber.id, > subscriber.access_type, subscriber.date_created, subscriber.username, > subscriber.password, subscriber.contact_gsm, subscriber.contact_email, > subscriber.package_id from subscriber]; Operation not allowed after > ResultSet closed > > > The exception is thrown in the following excerpt: > > @Repository > public class DefaultSubscriberRepository implements SubscriberRepository { > @Autowired > private DSLContext dslContext; > > // ... > > @Override > public List<Subscriber> findAllSubscribers() { > // ... > > List<Record> records = > dslContext.select().from(SUBSCRIBER).fetch(); > > // ... > > } > > // ... > } > > > As you can see, we do not use lazy fetching or manipulate ResultSets > directly, and I don't see why this exception is thrown. The > findAllSubscribers() method is called from a scheduler. > > What's interesting is that it usually happens when two parallel scheduler > tasks are being executed simultaneously, although I am not completely sure > that is the real cause here. > > If you have any hints on where to look, that would be great. > > -- > 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.
