Ya, Sprinta2000 doesnt support the XADataSource... I had the same problem
and following changes in .jcml file can help u to rock-n-roll...
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=MSSQL_Sprinta2000">
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImp
l</attribute>
<attribute name="PoolName">MSSQL_Sprinta2000</attribute>
<attribute
name="URL">jdbc:inetdae7:IPADDRESS:1433?database=DATABASENAME</attribute>
<attribute name="Properties">sql7=true</attribute>
<attribute name="JDBCUser">sa</attribute>
<attribute name="Password">sa</attribute>
<attribute name="MinSize">0</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="GCEnabled">true</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="IdleTimeoutEnabled">false</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
</mbean>
HTH
-Ashesh.
-----Original Message-----
From: Avi Kavas [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 1:07 AM
To: '[EMAIL PROTECTED]'
Cc: Shachar Weis
Subject: [JBoss-user] Connection Pools in JBoss
Hi,
1. How can I add a connection pool to a new database at runtime ?
2. I saw in the "Howto - Using MS SQL Server with JBoss"
(http://www.jboss.org/documentation/HTML/ch10s17.html) that one of the
vendors they author recommended was "i-net OPTA 2000", supports connection
pool. Does JBoss rely on this driver feature ? Can I use "i-net Sprinta
2000" which does not support connection pools instead ?
Thanks,
Avi.
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
