[jboss-user] [Performance Tuning] - No Managed Connections Available

[milind.uc]

I am getting the error   No Managed Connections  Available while using the application. I made the database connectivity using datasource .I am using the mysql as a datbase . There is no any particular time  of this error occurence. It will come  after using it more than 7 -8 ourse or might be after using application continusollsy more than one dayes. I try to close every connection . In my application some part uses the connection using driver manager with mysql  and I dont know whether they closed but I closed every connection opend by datasource also the resultsets and statements ...


My datasource file is like below:




  | 
  | 
  | 
  | <?xml version="1.0" encoding="UTF-8"?>
  | 
  | <!-- $Id: mysql-ds.xml,v 1.3 2004/09/15 14:37:40 loubyansky Exp $ -->
  | <!--  Datasource config for MySQL using 3.0.9 available from:
  | http://www.mysql.com/downloads/api-jdbc-stable.html
  | -->
  | 
  | <datasources>
  |   <local-tx-datasource>
  |     <jndi-name>DBConnection</jndi-name>
  | 	<use-java-context>false</use-java-context> 
  | 	<connection-url>jdbc:mysql://etp-05-02:3306/millind_demo?autoReconnect=true</connection-url>
  |     <driver-class>com.mysql.jdbc.Driver</driver-class>
  |     <user-name>root</user-name>
  |     <password>root</password>
  |      <max-pool-size>60</max-pool-size>
  | 	  <min-pool-size>10</min-pool-size>
  | 	  <blocking-timeout-millis>5000</blocking-timeout-millis>
  |       <idle-timeout-minutes>15</idle-timeout-minutes>
  |       <!-- correspondinasdg type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
  |       <metadata>
  |          <type-mapping>mySQL</type-mapping>
  |       </metadata>
  |   </local-tx-datasource>
  | 
  | </datasources>
  | 


and I got the error of ::

of No manged connection availbale within the configured blocking timeout of(5000ms)

In most of my progrma I used the simple query statemnet in some we used prepared statements......



I know this error may be because of some open connection so I am going to chechk it again. but I am felling there some other problem with mysql and jboss configuration files......

Also as I am using the connection pooling still we need to close evey coneecion watchfully ,, so is it means that connection polling not works that what we thought concpetually that is there is no. of connection available whihc we mwtnion in the dataconnection file.

And yes, I used the "java-conetxt  = false"  becasue my application is desktop allpication in java swing and we are using the java messaging service to transfer the data so thats why to used the3 datasource connection I used "false"....




View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4060259#4060259

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4060259