hi,
i think i encountered a similar problem i'm using jooq 3.2 in a spring web
application with a lot of simultaneous connection
and i got a lot of differents exception for the same code (but noat all
the time) :
1) [Request processing failed; nested exception is
org.jooq.exception.DataAccessException: SQL .... You can't operate on a
closed Connection!!!
or
2) [Request processing failed; nested exception is
org.jooq.exception.DataAccessException: SQL .... GDS Exception. 335544569.
Dynamic SQL Error
SQL error code = -504
Invalid cursor reference
Cursor is not open] with root cause
org.firebirdsql.gds.GDSException: Dynamic SQL Error
SQL error code = -504
Invalid cursor reference
or
3)
Request processing failed; nested exception is
org.jooq.exception.DataAccessException: SQL...; GDS Exception. 335544332.
invalid transaction handle (expecting explicit transaction start)
and the code that produce this exception is :
public String getModule(String uuid) {
Record r = appEngine.getDsl().select()
.from(MODULE
.where(MODULE.IDMDOULE.eq(uuid))
.fetchOne();
return r.into(Module.class).getModuleName();
}
it look like a concurency thread problem no ?
this is my spring jdbc config file :
<!-- Declare a datasource that has pooling capabilities-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close"
p:driverClass="${app.jdbc.driverClassName}"
p:jdbcUrl="${app.jdbc.url}"
p:user="${app.jdbc.username}"
p:password="${app.jdbc.password}"
p:acquireIncrement="5"
p:idleConnectionTestPeriod="60"
p:maxPoolSize="100"
p:maxStatements="50"
p:minPoolSize="10" />
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource" />
</bean>
<bean id="transactionAwareDataSource"
class="org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy">
<constructor-arg ref="dataSource" />
</bean>
<!-- Bridging Spring JDBC data sources to jOOQ's ConnectionProvider -->
<bean class="org.jooq.impl.DataSourceConnectionProvider"
name="connectionProvider">
<constructor-arg ref="transactionAwareDataSource" />
</bean>
<!-- Invoking an internal, package-private constructor for the example
Implement your own Configuration for more reliable behaviour -->
<bean class="org.jooq.impl.DefaultConfiguration" name="config">
<constructor-arg name="connectionProvider" ref="connectionProvider"/>
<constructor-arg name="recordMapperProvider"><null/></constructor-arg>
<constructor-arg name="dialect">
<value type="org.jooq.SQLDialect">FIREBIRD</value>
</constructor-arg>
<constructor-arg name="listenerProviders">
<null/>
</constructor-arg>
<constructor-arg name="settings">
<null/>
</constructor-arg>
<constructor-arg name="data">
<null/>
</constructor-arg>
</bean>
<bean id="dsl" class="org.jooq.impl.DefaultDSLContext">
<constructor-arg ref="config" />
</bean>
--
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.
