how can i implement a hibernate persistence with two diferents db, mysql and sqlserver 2000, i'm using two diferents pools with c3po two diferents drivers of course, but i'm using hibernate persistence with mysql ,and jdbc with sqlserver2000, i have a problem, connection is invalid after using JDBC sql server, first time i can connect with sqlserver, i can retrieve data with this method but the connection is invalid because c3po pool say that...
BasicResourcePool: An idle resource is broken and will be purged
and then.
2008-07-21 15:27:47,257 WARN [com.mchange.v2.resourcepool.BasicResourcePool] - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1eeed68 -- 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 (2). Last acquisition attempt exception:
com.jnetdirect.jsql.x: Failed Logon:com.jnetdirect.jsql.x: TCP/IP connection failed to host:java.net.ConnectException: Connection timed out url:jdbc:JSQLConnect://bases/database=base
at com.jnetdirect.jsql.JSQLDriver.connect(Unknown Source)
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:129)
at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:862)
at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:33)
at com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1527)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
200
help me please...
_________________ Are you HABLANDO to me¡¡¡
|