hi, i upgrade to jooq 3.2.2 and now it works !
thanks Le mardi 24 décembre 2013 09:23:24 UTC+1, Lukas Eder a écrit : > > Hello, > > Do your issues occur with the latest version of jOOQ? i.e. with jOOQ 3.2.2? > Have you tried to work around this issue by using Alexey's example > ConnectionProvider? > https://gist.github.com/abashev/7937310 > > Cheers > Lukas > > 2013/12/23 <[email protected] <javascript:>> > >> 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.
