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 EJB 3 in Action this week in the EJB and other Java EE Technologies 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:
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Using c3p0 connection pool. Error SQLException: invalid argument in call
 
Similar Threads
Help Help release 2.1.8bug c3p0 error
c3po, hibernate, oracle database problem
Installation Error of JForum with Oracle DB on RAC
connectivity problem
Trouble in setting up JFORUM with Eclipse as a Tomcat Project