c3po, hibernate, oracle database problem

[Adrien Ruffie]

Hi all,

I have the following stacktrace:

11:42:37,540 WARN BasicResourcePool:1841 - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@117b450 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: Il n'y a plus de données à lire dans le socket
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1118)
at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1070)
at oracle.jdbc.driver.T4C8TTIpro.receive(T4C8TTIpro.java:131)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:867)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:268)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:135)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:32)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1810)
at com.mchange.v2.async.ThreadPerTaskAsynchronousRunner$TaskThread.run(ThreadPerTaskAsynchronousRunner.java:255)


I have this problem but all topics find a solution for me ...

anybody have an idea please ?

best regards,

Adrien

[Adrien Ruffie]

We have the good oracle's driver (good version) and a good hibernate configuration (we think ).

After that we don't understand why this problem continue ...

Oracle: 10.2.0.1.0g
Hibernate-core: 3.3.1.GA
Hibernate-annotations: 3.4.0.GA
Hibernate-c3po: 3.3.1.GA

We access to the same database with two different applications,
one is a web application deployed into Tomcat and the second
application is a Petals ESB component.

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-configuration PUBLIC
		"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
		"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
		
<hibernate-configuration>
	<session-factory>

 	<!--Oracle -->

        	<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
		<property name="connection.url">jdbc:oracle:thin:@localhost:1521:xe</property>	
		<property name="connection.username">user</property>
        	<property name="connection.password">userPass</property>
       		<property name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</property>

       
		<!-- Enable Hibernate's automatic session context management -->
		<property name="current_session_context_class">thread</property>

		<!-- Disable the second-level cache  -->
		<property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>

		<!-- Echo all executed SQL to stdout -->
		<property name="show_sql">true</property>
		
		<!-- Create the database schema automatically -->
		<property name="hibernate.hbm2ddl.auto">update</property>
		
		<!-- configuration pool via c3p0 -->
		<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
		<property name="c3p0.acquire_increment">1</property>
		<property name="c3p0.idle_test_period">100</property>
		<property name="c3p0.max_size">100</property>
		<property name="c3p0.max_statements">0</property>
		<property name="c3p0.min_size">10</property>
		<property name="c3p0.timeout">150</property>
		
 		<!-- DEPRECATED very expensive property name="c3p0.validate>-->

		<!-- Mapped Classes -->
		<mapping class="org.ow2.petals.flowwatch.flowmanager.bo.Flow"/>
		<mapping class="org.ow2.petals.flowwatch.flowmanager.bo.FlowStep"/>
		<mapping class="org.ow2.petals.flowwatch.flowmanager.bo.FlowRef"/>
		<mapping class="org.ow2.petals.flowwatch.flowmanager.bo.FlowStepRef"/>
		<mapping class="org.ow2.petals.flowwatch.flowmanager.bo.FlowStepErrorRef"/>
	</session-factory>
</hibernate-configuration>

[Paul Sturrock]

I can't speak French. What does:

Il n'y a plus de données à lire dans le socket

translate as?

[Adrien Ruffie]

Oups sorry ,


Il n'y a plus de données à lire dans le socket --> "There isn't more data to read from the socket"

[Paul Sturrock]

No worries.

You don't have binary data mapped in any of your entities do you? Oracle's JDBC driver used to have issues with this.

[Adrien Ruffie]

What you mean by binary data?

CLOB, BLOB, LOB ?

[Paul Sturrock]

Yes (or LONG RAWs if you are doing it old school).

[Adrien Ruffie]

No we just have VARCHAR2 and NUMBER ...