I'm using the C3P0PooledDataSource with my Hibernate in Jboss. <?xml version="1.0" encoding="UTF-8"?> | <!DOCTYPE server> | <server> | <mbean code="com.mchange.v2.c3p0.mbean.C3P0PooledDataSource" name="jboss:service=CamasC3P0PooledDataSource"> | <attribute name="JndiName">java:/****DS</attribute> | <attribute name="JdbcUrl">jdbc:oracle:thin:@********:1521:*****</attribute> | <attribute name="DriverClass">oracle.jdbc.driver.OracleDriver</attribute> | <attribute name="User">****</attribute> | <attribute name="Password">****</attribute> | | <!-- Uncomment and set any of the optional parameters below --> | <!-- See c3p0's docs for more info. --> | | <attribute name="AcquireIncrement">1</attribute> | <attribute name="AcquireRetryAttempts">10</attribute> | <attribute name="AcquireRetryDelay">5000</attribute> | <attribute name="AutoCommitOnClose">false</attribute> | <attribute name="AutomaticTestTable">C3P0TEST</attribute> | <attribute name="CheckoutTimeout">5000</attribute> | <attribute name="Description">C3P0 Pooled Datasource</attribute> | <attribute name="IdleConnectionTestPeriod">30</attribute> | <attribute name="InitialPoolSize">1</attribute> | <attribute name="MaxIdleTime">600</attribute> | <attribute name="MaxPoolSize">3</attribute> | <attribute name="MinPoolSize">1</attribute> | <attribute name="NumHelperThreads">3</attribute> | <attribute name="TestConnectionOnCheckin">true</attribute> | <depends>jboss:service=Naming</depends> | </mbean> | </server>
Now, when I try to lock an object using LockMode.UPGRADE_NOWAIT, I get an SQL error: 1002 - "fetch out of sequence". This message should appear when part of a session is already flushed before getting the lock: http://ora-01002.ora-code.com/ anonymous wrote : This may be caused by fetching from a SELECT FOR UPDATE cursor after a commit. When I use a normal datasource, I don't have the problem anymore, so it looks like it that c3p0 does some auto commit where we don't want it and not even specified it to do so. Has anyone ever came acros this problem yet? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3913927#3913927 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3913927 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user