org.jboss.util.NestedSQLException: No ManagedConnections available within configured blocking timeout ( 30000 [ms]

http://www.techienuggets.com/Detail?tx=35569

 

 

--------------------------------------------------------------------------------

Here is my x-ds.xml file

<local-tx-datasource>
<jndi-name>jobDS</jndi-name>
<connection-url>jdbc:jtds:sqlserver://localhost:1433/Reg_DB;prepareSQL=2</connection-url>
<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
<user-name>sa</user-name>
sa
<new-connection-sql>select count(1) from job_templates</new-connection-sql>
<check-valid-connection-sql>select count(1) from job_templates</check-valid-connection-sql>
<min-pool-size>10</min-pool-size>
<max-pool-size>50</max-pool-size>
</local-tx-datasource>


The JTDS driver version is 1.2.2 (I got this exception on 0.9 version also). I will be thankful if any one can address the issue. Thanks in advance.

Questions or comments? Feel free to post them here. No login or id required