Since blocking is true, most likely your connection parameters are wrong and it can't get a connection.
check: driver is listed in JdbcProvider mbean you can connect from standalone program using exactly the driver, url, username, password in your conf. Note that use of the jdbc-odbc bridge is strongly discouraged. david jencks On 2001.10.10 13:03:02 -0400 David Treves wrote: > Hi, > > I am running JBoss 2.4.0 and I wish to integrate it with MS Sql Server. I > went through the documentation, but it seems like I am missing > something... > > I added the relevant <MBean>" to jboss.jcml and the definition of the > Minerva connection pool, but when I test it and run the server it is > stucked on the line where it is trying to run that service/thread. > > The MBean I added is: > > <mbean code="org.jboss.jdbc.XADataSourceLoader" > name="DefaultDomain:service=XADataSource,name=SQLServerPool"> > <attribute >name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute> > <attribute name="PoolName">SQLServerPool</attribute> > <attribute name="URL">jdbc:odbc:ejb</attribute> > <attribute name="JDBCUser">sa</attribute> > <attribute name="Password">mamamia</attribute> > <attribute name="Properties"></attribute> > <attribute name="GCMinIdleTime">1200000</attribute> > <attribute name="MaxSize">10</attribute> > <attribute name="GCEnabled">false</attribute> > <attribute name="InvalidateOnError">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">false</attribute> > <attribute name="LoggingEnabled">false</attribute> > <attribute name="MaxIdleTimeoutPercent">1.0</attribute> > <attribute name="MinSize">0</attribute> > </mbean> > > and the line where the initializing process is stucked at is: > > [XADataSourceLoader] Started > [XADataSourceLoader] Starting > [SQLServerPool] XA Connection pool SQLServerPool bound to > java:/SQLServerPool > > > Any idea why that happens? > > Thanks in advance, > David. > > <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> > <HTML><HEAD> > <META http-equiv=Content-Type content="text/html; charset=windows-1255"> > <META content="MSHTML 5.50.4807.2300" name=GENERATOR> > <STYLE></STYLE> > </HEAD> > <BODY bgColor=#ffffff> > <DIV><FONT face=Arial size=2>Hi,</FONT></DIV> > <DIV><FONT face=Arial size=2></FONT> </DIV> > <DIV><FONT face=Arial size=2>I am running JBoss 2.4.0 and I wish to > integrate it > with MS Sql Server. I went through the documentation, but it seems like I > am > missing something...</FONT></DIV> > <DIV><FONT face=Arial size=2></FONT> </DIV> > <DIV><FONT face=Arial size=2>I added the relevant <MBean>" to > jboss.jcml</FONT><FONT face=Arial size=2> and the definition of the > Minerva > connection pool, but when I test it and run the server it is stucked on > the line > where it is trying to run that service/thread.</FONT></DIV> > <DIV> </DIV> > <DIV><FONT face=Arial size=2>The MBean I added is:</FONT></DIV> > <DIV> </DIV> > <DIV><FONT face=Arial size=2><mbean > code="org.jboss.jdbc.XADataSourceLoader" > >name="DefaultDomain:service=XADataSource,name=SQLServerPool"><BR> > > <attribute > >name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute><BR> > > <attribute > >name="PoolName"><STRONG>SQLServerPool</STRONG></attribute><BR> > > <attribute > name="URL">jdbc:odbc:ejb</attribute><BR> > <attribute name="JDBCUser">sa</attribute><BR> > > <attribute name="Password">mamamia</attribute><BR> > > <attribute name="Properties"></attribute><BR> > > <attribute > name="GCMinIdleTime">1200000</attribute><BR> > <attribute name="MaxSize">10</attribute><BR> > > <attribute name="GCEnabled">false</attribute><BR> > > <attribute > name="InvalidateOnError">false</attribute><BR> > > <attribute > name="TimestampUsed">false</attribute><BR> > <attribute name="Blocking">true</attribute><BR> > > <attribute > name="GCInterval">120000</attribute><BR> > <attribute > name="IdleTimeout">1800000</attribute><BR> > <attribute > name="IdleTimeoutEnabled">false</attribute><BR> > > <attribute > name="LoggingEnabled">false</attribute><BR> > <attribute > name="MaxIdleTimeoutPercent">1.0</attribute><BR> > > <attribute name="MinSize">0</attribute><BR> > </mbean></FONT></DIV> > <DIV> </DIV> > <DIV><FONT face=Arial size=2>and the </FONT> <FONT face=Arial > size=2>line > where the initializing process is stucked at is:</FONT></DIV> > <DIV><FONT face=Arial size=2></FONT> </DIV> > <DIV><FONT face=Arial size=2>[XADataSourceLoader] > Started<BR>[XADataSourceLoader] Starting<BR>[SQLServerPool] XA Connection > pool > SQLServerPool bound to java:/SQLServerPool</FONT></DIV> > <DIV><FONT face=Arial size=2></FONT> </DIV> > <DIV><FONT face=Arial size=2></FONT> </DIV> > <DIV><FONT face=Arial size=2>Any idea why that happens?</FONT></DIV> > <DIV><FONT face=Arial size=2></FONT> </DIV> > <DIV><FONT face=Arial size=2>Thanks in advance,</FONT></DIV> > <DIV><FONT face=Arial size=2>David.</FONT></DIV></BODY></HTML> > _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
