aspose file tools*
The moose likes Object Relational Mapping and the fly likes c3po, hibernate, oracle database problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "c3po, hibernate, oracle database problem" Watch "c3po, hibernate, oracle database problem" New topic
Author

c3po, hibernate, oracle database problem

Adrien Ruffie
Ranch Hand

Joined: Jan 14, 2009
Posts: 90
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


SCJP 5, SCDJWS 5
http://adrien-ruffie.blogspot.com
Adrien Ruffie
Ranch Hand

Joined: Jan 14, 2009
Posts: 90
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.

Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

I can't speak French. What does:

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

translate as?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Adrien Ruffie
Ranch Hand

Joined: Jan 14, 2009
Posts: 90
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
Bartender

Joined: Apr 14, 2004
Posts: 10336

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
Ranch Hand

Joined: Jan 14, 2009
Posts: 90
What you mean by binary data?

CLOB, BLOB, LOB ?
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Yes (or LONG RAWs if you are doing it old school).
Adrien Ruffie
Ranch Hand

Joined: Jan 14, 2009
Posts: 90
No we just have VARCHAR2 and NUMBER ...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: c3po, hibernate, oracle database problem