Thread: [Springframework-developer] CannotCreateTransactionException

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hi,

I have created a bean like in the applicationcontext.xml file
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
destroy-method="close">
		<property name="driverClass" value="${jdbc.driverClassName}"/>
		<property name="jdbcUrl" value="${jdbc.url}"/>
		<property name="user" value="${jdbc.username}"/>
		<property name="password" value="${jdbc.password}"/>
	</bean>

and placed c3p0-0.9.1.1 jar file
and the bean for transaction handling is 
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSourceTransactionManager" >
	<property name="dataSource" ref="dataSource" />
</bean>

Now when ever i perform any database transaction,  i will get the following
error

2008-07-07 18:59:38,500 WARN 
[com.mchange.v2.resourcepool.BasicResourcePool] -
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@121e5a --
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: Unsupported feature
	at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
	at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
	at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
	at
oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException(DatabaseError.java:537)
	at
oracle.jdbc.driver.PhysicalConnection.getHoldability(PhysicalConnection.java:2684)
	at
com.mchange.v2.c3p0.impl.NewPooledConnection.<init>(NewPooledConnection.java:106)
	at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:198)
	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.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
2008-07-07 18:59:38,515 ERROR
[org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/SpringMVC].[springapp]]
- Servlet.service() for servlet springapp threw exception
com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool
could not acquire a resource from its primary factory or source.
	at
com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
	at
com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
	at
com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
	at
com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
	at
com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
	at
org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:200)
	at
org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:350)
	at
org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:262)
	at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:101)
	at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
	at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
	at $Proxy2.storeImage(Unknown Source)
	at web.FileUploadController.onSubmit(FileUploadController.java:67)
	at
org.springframework.web.servlet.mvc.SimpleFormController.processFormSubmission(SimpleFormController.java:267)
	at
org.springframework.web.servlet.mvc.AbstractFormController.handleRequestInternal(AbstractFormController.java:265)
	at
org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153)
	at
org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
	at
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:859)
	at
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:793)
	at
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476)
	at
org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:441)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
	at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
	at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
	at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
	at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
	at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
	at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
	at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
	at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
	at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
	at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
	at java.lang.Thread.run(Unknown Source)
2008-07-07 18:59:38,703 WARN 
[com.mchange.v2.resourcepool.BasicResourcePool] -
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@ea58e3 --
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: Unsupported feature
	at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
	at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
	at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
	at
oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException(DatabaseError.java:537)
	at
oracle.jdbc.driver.PhysicalConnection.getHoldability(PhysicalConnection.java:2684)
	at
com.mchange.v2.c3p0.impl.NewPooledConnection.<init>(NewPooledConnection.java:106)
	at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:198)
	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.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
2008-07-07 18:59:38,703 WARN 
[com.mchange.v2.resourcepool.BasicResourcePool] -
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@171ccb0 --
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: Unsupported feature
	at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
	at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
	at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
	at
oracle.jdbc.driver.DatabaseError.throwUnsupportedFeatureSqlException(DatabaseError.java:537)
	at
oracle.jdbc.driver.PhysicalConnection.getHoldability(PhysicalConnection.java:2684)
	at
com.mchange.v2.c3p0.impl.NewPooledConnection.<init>(NewPooledConnection.java:106)
	at
com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:198)
	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.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)

Can any one tell me how to solve this problem.
I am using spring-framework 2.0 version.

thanks

-- 
View this message in context: http://www.nabble.com/CannotCreateTransactionException-tp18317324p18317324.html
Sent from the springframework-developer mailing list archive at Nabble.com.