What's below worked for me in 2.1. It's a cut and paste job. YMMV.
Darrin
Replace this section in jboss.jcml....
<mbean code="org.jboss.jdbc.JdbcProvider" name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">org.hsql.jdbcDriver,org.enhydra.instantdb.jdbc.idbDriver,com.internetcds.jdbc.tds.Driver</attribute>
</mbean>
Add this...
<mbean code="org.jboss.jdbc.XADataSourceLoader" name="DefaultDomain:service=XADataSource,name=MyCustomDB">
<attribute name="PoolName">MyCustomDB</attribute>
<attribute name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:freetds:sqlserver://host.MyCustom.net/MyCustom</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">dthompson</attribute>
<attribute name="Password">wonderful</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>
Original Message dated 4/10/01, 8:48:20 PM
Author: Matthew Setter <[EMAIL PROTECTED]>
Re: [JBoss-user] FreeTDS and JBoss connection pooling:
Has anyone successfully gotten a connection pool in jboss 2.1 running using the freetds driver to an ms sql database??
If so, could you email jboss.jcml snippets pls.
Having a very frustrating time trying to get it running.
thanks,
Matthew
