aspose file tools*
The moose likes Object Relational Mapping and the fly likes Using c3p0 connection pool. Error SQLException: invalid argument in call Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Using c3p0 connection pool. Error SQLException: invalid argument in call" Watch "Using c3p0 connection pool. Error SQLException: invalid argument in call" New topic
Author

Using c3p0 connection pool. Error SQLException: invalid argument in call

S Branch
Greenhorn

Joined: Jan 07, 2013
Posts: 8
Any ideas of why getting the error? Thanks.

Here is my hibernate.cfg.xml,

<hibernate-configuration>
<session-factory name="HibernateCDSARSessionFactory">
<property name="hibernate.format_sql">true</property>
<property name="hibernate.connection.provider_class">org.hibernate.connection.C3P0ConnectionProvider</property>
<property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="hibernate.connection.url">jdbcracle:thin:@132.60.128.39:1521:cdsartst</property>
<property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property name="connection.datasource">jdbc/cdsardb</property>
<property name="show_sql">true</property>

<property name="hibernate.c3p0.min_size">15</property>
<property name="hibernate.c3p0.max_size">30</property>
<property name="hibernate.c3p0.timeout">1800</property>
<property name="hibernate.c3p0.idle_test_period">3000</property>
<property name="connection.autoReconnect">true</property>
<property name="connection.is-connection-validation-required">true</property>

Getting?
java.sql.SQLException: invalid arguments in call
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:175)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:240)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:206)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:430)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:151)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32
)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:608)
at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSou
rce.java:119)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(Wrappe
rConnectionPoolDataSource.java:143)
at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(Wrappe
rConnectionPoolDataSource.java:132)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoo
lManager.acquireResource(C3P0PooledConnectionPool.java:152)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java
:1074)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcqu
iresWithinLockOnSuccess(BasicResourcePool.java:1061)
at com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.jav
a:32)
at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicRe
sourcePool.java:1796)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsy
nchronousRunner.java:635)
Jun 20, 2013 9:22:03 PM com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTas
k run
WARNING: com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@137ddc0 -- Ac
quisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed n
ew resource, we failed to succeed more than the maximum number of allowed acquisition att
empts (30). Last acquisition attempt exception:
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Using c3p0 connection pool. Error SQLException: invalid argument in call