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"120/attribute
attribute name="GCInterval"12/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"180/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