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.
