The first thing is to set Blocking=true. I think you also want BlockingTimeoutMillis=5000 or you might block forever. (I think this is the name of this parameter, it's from memory)
I don't remember seeing about the connection already closed error: what/when is it? david jencks On 2002.06.25 11:27:53 -0400 John Moore wrote: > > > We are seeing these "How Can You Manage A Null Connection?" exceptions > creep > up randomly when we go to get a connection from a DataSource. I see in > the > code where this is thrown but can't figure out how after having the pool > be > created (and accessed) successfully I can end up with this exception. > Unlike the connection already closed that we also get, this one doesn't > seem > to go away if you keep trying to grab new connections; it says around > until > the jboss is restarted. Stopping and starting the mbean doesn't seem to > cut it. The error occurs on different pools and at no particular > interval. > The database servers may be restarted without our knowledge, but in our > testing this hasn't been a problem. > > We are using JBoss 2.4.3 with embedded Tomcat 3.2.3 and have about 30 > datasources to sybase sqlanywhere 5.5 databases. JBoss is on a Sun Netra > X1, Solaris 8 (with patches), jdk 1.3.1_02, ulimit -s 2048, ulimit -n > 1024, > apache 1.3.24 w/ mod_jk & mod_ssl. Databases are all remote; accessed > over > internet connections not LAN or WAN connections. Some are through VPN > tunnels. All of the datasources initially startup cleanly and we can > connect > to each of them without a problem. There are no clues in the log file > either. Datasources all have the same configuration except the mbean > name, > factory name and connection URL in the property attribute. > > The application is a group of servlets and JSP's deployed as a war. > > <!-- TEST DATA SOURCE --> > <mbean code="org.jboss.resource.ConnectionFactoryLoader" > name="JCA:service=ConnectionFactoryLoader,name=test"> > <attribute name="FactoryName">test</attribute> > <attribute > name="RARDeployerName">JCA:service=RARDeployer</attribute> > <attribute name="ResourceAdapterName">Minerva JDBC > LocalTransaction ResourceAdapter</attribute> > <attribute name="Properties"> > UserName=xxxxxx > Password=yyyyyy > Driver=com.sybase.jdbc2.jdbc.SybDriver > > ConnectionURL=jdbc:sybase:Tds:192.168.0.15:1498/dbname > </attribute> > <attribute > name="ConnectionManagerFactoryName">MinervaSharedLocalCMFactory</attribute> > <attribute name="ConnectionManagerProperties"> > MinSize=1 > MaxSize=10 > Blocking=false > GCEnabled=true > IdleTimeoutEnabled=true > InvalidateOnError=false > TrackLastUsed=true > GCIntervalMillis=120000 > GCIntervazlMillis=120000 > GCMinIdleMillis=240000 > IdleTimeoutMillis=300000 > MaxIdleTimeoutPercent=0.0 > </attribute> > <attribute > name="PrincipalMappingClass">org.jboss.resource.security.ManyToOnePrincipalM > apping</attribute> > </mbean> > > Has anyone else seen this and is there a solution? I didn't catch > anything > in the forums. We're at 30 connections now and am looking to be around > 100 > soon, but am going to have a big problem if I can't solve this problem. > > > Thanks, > John Moore > > Principal Decision Systems International > 625 The City Drive > Suite 190 > Orange, CA 92868 > 800-850-7374 > > > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> > <HTML> > <HEAD> > <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> > <META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2653.12"> > <TITLE>How Can You Manage A Null Connection? Errors</TITLE> > </HEAD> > <BODY> > <BR> > <BR> > > <P><FONT SIZE=2>We are seeing these "How Can You Manage A Null > Connection?" exceptions creep up randomly when we go to get a > connection from a DataSource. I see in the code where this is thrown but > can't figure out how after having the pool be created (and accessed) > successfully I can end up with this exception. Unlike the > connection already closed that we also get, this one doesn't seem to go > away if you keep trying to grab new connections; it says around until the > jboss is restarted. Stopping and starting the mbean doesn't > seem to cut it. The error occurs on different pools and at no > particular interval. The database servers may be restarted > without our knowledge, but in our testing this hasn't been a > problem.</FONT></P> > > <P><FONT SIZE=2>We are using JBoss 2.4.3 with embedded Tomcat 3.2.3 and > have about 30 datasources to sybase sqlanywhere 5.5 databases. > JBoss is on a Sun Netra X1, Solaris 8 (with patches), jdk 1.3.1_02, > ulimit -s 2048, ulimit -n 1024, apache 1.3.24 w/ mod_jk & > mod_ssl. Databases are all remote; accessed over internet > connections not LAN or WAN connections. Some are through VPN > tunnels. All of the datasources initially startup cleanly and we can > connect to each of them without a problem. There are no clues > in the log file either. Datasources all have the same configuration > except the mbean name, factory name and connection URL in the property > attribute. </FONT></P> > > <P><FONT SIZE=2>The application is a group of servlets and JSP's deployed > as a war.</FONT> > </P> > > <P><FONT SIZE=2> <!-- TEST > DATA SOURCE --></FONT> > <BR><FONT SIZE=2> <mbean > code="org.jboss.resource.ConnectionFactoryLoader" > name="JCA:service=ConnectionFactoryLoader,name=test"></FONT> > <BR><FONT SIZE=2> > <attribute name="FactoryName">test</attribute></FONT> > <BR><FONT SIZE=2> > <attribute >name="RARDeployerName">JCA:service=RARDeployer</attribute></FONT> > <BR><FONT SIZE=2> > <attribute name="ResourceAdapterName">Minerva JDBC > LocalTransaction ResourceAdapter</attribute></FONT> > <BR><FONT SIZE=2> > <attribute name="Properties"></FONT> > <BR><FONT >SIZE=2> > UserName=xxxxxx</FONT> > <BR><FONT >SIZE=2> > Password=yyyyyy</FONT> > <BR><FONT >SIZE=2> > Driver=com.sybase.jdbc2.jdbc.SybDriver</FONT> > <BR><FONT >SIZE=2> > ConnectionURL=jdbc:sybase:Tds:192.168.0.15:1498/dbname</FONT> > <BR><FONT SIZE=2> > </attribute></FONT> > <BR><FONT SIZE=2> > <attribute >name="ConnectionManagerFactoryName">MinervaSharedLocalCMFactory</attribute></FONT> > <BR><FONT SIZE=2> > <attribute name="ConnectionManagerProperties"></FONT> > <BR><FONT >SIZE=2> > MinSize=1</FONT> > <BR><FONT >SIZE=2> > MaxSize=10</FONT> > <BR><FONT >SIZE=2> > Blocking=false</FONT> > <BR><FONT >SIZE=2> > GCEnabled=true</FONT> > <BR><FONT >SIZE=2> > IdleTimeoutEnabled=true</FONT> > <BR><FONT >SIZE=2> > InvalidateOnError=false</FONT> > <BR><FONT >SIZE=2> > TrackLastUsed=true</FONT> > <BR><FONT >SIZE=2> > GCIntervalMillis=120000</FONT> > <BR><FONT >SIZE=2> > GCIntervazlMillis=120000</FONT> > <BR><FONT >SIZE=2> > GCMinIdleMillis=240000</FONT> > <BR><FONT >SIZE=2> > IdleTimeoutMillis=300000</FONT> > <BR><FONT >SIZE=2> > MaxIdleTimeoutPercent=0.0</FONT> > <BR><FONT SIZE=2> > </attribute></FONT> > <BR><FONT SIZE=2> > <attribute >name="PrincipalMappingClass">org.jboss.resource.security.ManyToOnePrincipalMapping</attribute></FONT> > <BR><FONT SIZE=2> > </mbean></FONT> > </P> > > <P><FONT SIZE=2>Has anyone else seen this and is there a solution? I > didn't catch anything in the forums. We're at 30 connections now > and am looking to be around 100 soon, but am going to have a big problem > if I can't solve this problem. </FONT></P> > > <P><FONT SIZE=2>Thanks,</FONT> > <BR><FONT SIZE=2>John Moore</FONT> > </P> > > <P><FONT SIZE=2>Principal Decision Systems International</FONT> > <BR><FONT SIZE=2>625 The City Drive</FONT> > <BR><FONT SIZE=2>Suite 190</FONT> > <BR><FONT SIZE=2>Orange, CA 92868</FONT> > <BR><FONT SIZE=2>800-850-7374</FONT> > </P> > <BR> > > </BODY> > </HTML> > ------------------------------------------------------- This sf.net email is sponsored by: Jabber Inc. Don't miss the IM event of the season | Special offer for OSDN members! JabConf 2002, Aug. 20-22, Keystone, CO http://www.jabberconf.com/osdn _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
