Are you calling 'close' on your Statement and Connection objects after use? This should be done in a 'finally' clause to ensure that it will happen regardless of any errors. Note that this doesn't actually close the connection; it just notifies the pool that you're through with it.
-danch Martin Cabrera wrote: > Hi; > > I have a DB2 pool defined in my jboss.jcml file. Every time I use the pool > from my ejbs jboss opens a new connection and don�t reuse the actual > connections. When jboss reachs the max size of the pool it hangs. > > Any ideas? > > I append the pool definition at the end of this mail. > > Thanks in advance. > > Mart�n Cabrera > IT Manager > Proyecto Abitab OnLine > Abitab S.A. > Montevideo - Uruguay > [EMAIL PROTECTED] > > <mbean code="org.jboss.jdbc.JdbcProvider" > name="DefaultDomain:service=DB2JdbcProvider"> > <attribute name="Drivers">COM.ibm.db2.jdbc.app.DB2Driver</attribute> > </mbean> > > <mbean code="org.jboss.jdbc.XADataSourceLoader" > name="DefaultDomain:service=XADataSource,name=DB2"> > <attribute > name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attr > ibute> > <attribute name="PoolName">ONLINE</attribute> > <attribute name="URL">jdbc:db2:OLDESA</attribute> > <attribute name="JDBCUser">wldesa</attribute> > <attribute name="Password">wldesa</attribute> > <attribute name="MaxSize">10</attribute> > <attribute name="GCEnabled">false</attribute> > <attribute name="TimestampUsed">false</attribute> > <attribute name="Blocking">true</attribute> > <attribute name="GCInterval">120000</attribute> > <attribute name="IdleTimeout">1800000</attribute> > <attribute name="IdleTimeoutEnabled">true</attribute> > <attribute name="LoggingEnabled">false</attribute> > <attribute name="MaxIdleTimeoutPercent">1.0</attribute> > <attribute name="MinSize">0</attribute> > </mbean> > > > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
