Hi
I've set up spring to do the transaction handling in the standard way:
<bean id="transactionManager"
class="org.springframework.jdbc.datasource.DataSou rceTransactionManager">
<property name="dataSource" ref="dataSource"/>
</bean>
<tx:annotation-driven/>
Then in my service classes I have:
@Transactional(readOnly = true)
All my methods are readonly transactions only reading from the database at
this stage.
I then set up my datasource as so:
<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}"/>
<property name="idleConnectionTestPeriod" value="10800"/>
<property name="maxIdleTime" value="21600"/>
<property name="maxStatements" value="0"/>
</bean>
The url and username/password connect fine and the application runs for
roughly two days with no problem. Then all of a sudden I get the following
error:
[twl-play] WARN [Timer-0] ThreadPoolAsynchronousRunner.run(608) |
com.mchange.v2.async.ThreadPoolAsynchronousRunner$ [EMAIL PROTECTED]
-- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending
tasks!
[twl-play] WARN [Timer-0] ThreadPoolAsynchronousRunner.run(624) |
com.mchange.v2.async.ThreadPoolAsynchronousRunner$ [EMAIL PROTECTED]
-- APPARENT DEADLOCK!!! Complete Status:
And sql server kicks out my user I'm connecting with and application can no
longer hit the database.
I've tried using DBCP and ran into countless problems. Where suddenly I
can't connect to the database:
Caused by: java.sql.SQLException: Network error IOException: Connection
refused: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(C
onnectionJDBC2.java:385)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(C
onnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.ja va:182)
at org.apache.commons.dbcp.DriverConnectionFactory.cr
eateConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.
makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.pool.impl.GenericObjectPool.bor
rowObject(GenericObjectPool.java:840)
at org.apache.commons.dbcp.PoolingDataSource.getConne
ction(PoolingDataSource.java:96)
at org.apache.commons.dbcp.BasicDataSource.getConnect
ion(BasicDataSource.java:880)
at org.springframework.jdbc.datasource.DataSourceTran
sactionManager.doBegin(DataSourceTransactionManage r.java:200)
... 39 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl .java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSoc ketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.j ava:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.j ava:366)
at java.net.Socket.connect(Socket.java:519)
at sun.reflect.GeneratedMethodAccessor65.invoke(Unkno wn Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De
legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocke
tForJDBC3(SharedSocket.java:304)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(Shar edSocket.java:255)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(C
onnectionJDBC2.java:310)
I don't think I'm leaking connections as I thought spring closed up
connections for you as long as your running in a transaction. My Dao's all
extend HibernateDaoSupport.
I've used spring hibernate combination countless times with MySQL and oracle
and never had these sorts of issues. Not sure if its the way my application
is configured or something related to sqlserver database. I've read many
related problems in various forums and was wondering if there is a
recommended approach with sql server?
I'm using the following:
Hibernate - 3.2.5.ga
spring - 2.5.3
c3po - 0.9.1.2
--
View this message in context:
http://www.nabble.com/Issues-with-c3po-hibernate-and-spring-ThreadPoolAsynchronousRunner%24DeadlockDetector-tp17789627s2369p17789627.html
Sent from the AppFuse - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
