| 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
 
 
 |