I am using hibernate (3.0.5) with MSSQL Server 2005. I get the following exception :
46,299 WARN BasicResourcePool:1224 - com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1eeba19 -- 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).
19:17:46,330 WARN SettingsFactory:103 - Could not obtain connection metadata
java.sql.SQLException: Connections could not be acquired from the underlying database!
The database is up and can be accessed using MSSQL tools.
I am not sure where to look for debugging.
Here is the configuration file. This configuration file works fine from other machines. it is one particular setup which fails.
#Database Configuration
#Sat Jun 10 08:29:11 PDT 2006
hibernate.c3p0.timeout=5000
DBPassword=<password>
DBConnectionUrl=jdbc\:inetdae7\:<hostname>\:1433?database\=<database instance name>&prepare\=false
MaxConnections=150
hibernate.c3p0.max_statements=100
MaxBatchRecords=100
hibernate.c3p0.max_size=100
hibernate.c3p0.idle_test_period=3000
hibernate.c3p0.min_size=10
TranPropMaxCache=100000
DBHibernateDialect=org.hibernate.dialect.SQLServerDialect
DBUser=<user>
hibernate.c3p0.acquire_increment=2
DBDriverClass=com.inet.pool.PoolDriver
MaxBatchSeconds=15
ExpirationIntervalMins=60
DBType=mssql
Please help.
regards
-Sarab
|