i use mysqldatabase ,datasoure is c3p0 database pool spring configure as that
<bean id="jooqfactory" class="org.jooq.impl.Factory"> <constructor-arg> <ref bean="dataSource" /> </constructor-arg> <constructor-arg type="org.jooq.SQLDialect" value="MYSQL"></constructor-arg> </bean> jooqfactory.setAutoCommit(false);//this isn't vaild jooqfactory.getAutoCommit();//this result is true; but i try type Connection conn=datasoure.getConnection(); jooqfactory.setConnection(conn); jooqfactory.setAutoCommit(false); jooqfactory.getAutoCommit()// this result is false;