[JBoss-user] Connection Pools in JBoss

2001-04-18 Thread Avi Kavas

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



RE: [JBoss-user] Connection Pools in JBoss

2001-04-18 Thread Ashesh Sheth

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