FreeTDS Development Group

[Matthew Setter <Matthew AT stimuluss.com.au>]

Title: RE: [freetds] RE: FreeTDS_jdbc.jar with Jboss 2.1

I appreciate that this may work with pre 2.1 - but there seems to still be a case of jboss hanging when attempting to initiate the connection pool in 2.1.

Any pointers?

-----Original Message-----
From: Jez Humble [mailto:jez AT whatsonwhen.com]
Sent: Tuesday, 10 April 2001 7:57 PM
To: TDS Development Group
Subject: [freetds] RE: FreeTDS_jdbc.jar with Jboss 2.1

Below is the jboss.jcml conf file I use with jboss + jetty.

You should also remember to tell jboss where freetds_jdbc.jar is located for
each of your data sources. You do this by inserting the following into
jboss.conf for each data source (with my sample jboss.jcml, you'll need the
entry below plus an extra entry for DefaultDS) , e.g.

<MLET CODE="org.jboss.jdbc.XADataSourceLoader"
ARCHIVE="jboss.jar,freetds_jdbc.jar" CODEBASE=""../../lib/ext/">
        <ARG TYPE="java.lang.String" VALUE="InstantDB">
        <ARG TYPE="java.lang.String"
VALUE="org.jboss.minerva.xa.XADataSourceImpl">
</MLET>

This assumes you've put freetds_jdbc.jar into the directory referenced by
CODEBASE.

Finally you need to put into jboss.properties the line:

jdbc.drivers=com.internetcds.jdbc.tds.Driver

jboss.jcml conf file follows:

<?xml version="1.0"?>

<server>
     <mbean name="Adaptor:name=html">
       <attribute name="MaxActiveClientCount">10</attribute>
       <attribute name="Parser" />
       <attribute name="Port">8082</attribute>
     </mbean>
     <mbean name="DefaultDomain:service=MLet">
       <attribute
name="LibraryDirectory">/home/alborini/jetdist/jboss_jetty/jboss-PRE-2.1/bin
</attribute>
     </mbean>
     <mbean name="DefaultDomain:service=TransactionManager">
       <attribute name="TransactionTimeout">300</attribute>
     </mbean>
     <mbean name="DefaultDomain:service=Logging,type=Console">
       <attribute name="Format">[{2}] {4}</attribute>
     </mbean>
     <mbean name="DefaultDomain:service=Webserver">
       <attribute name="Port">8083</attribute>
     </mbean>
     <mbean name="DefaultDomain:service=Logging,type=File">
       <attribute name="Format">[{2}] {4}</attribute>
       <attribute name="LogName">server</attribute>
     </mbean>
     <mbean name="DefaultDomain:service=XADataSource,name=InstantDB">
       <attribute name="TimestampUsed">false</attribute>
       <attribute name="Password">jdbc</attribute>
       <attribute name="MaxSize">0</attribute>
       <attribute name="InvalidateOnError">false</attribute>
       <attribute name="IdleTimeout">1800000</attribute>
       <attribute name="GCInterval">120000</attribute>
       <attribute name="Blocking">true</attribute>
       <attribute name="LoggingEnabled">false</attribute>
       <attribute name="IdleTimeoutEnabled">false</attribute>
       <attribute name="GCEnabled">false</attribute>
       <attribute name="URL">jdbc:freetds:sqlserver://<INSERT IP ADDRESS OF
SERVER/>:1433/<INSERT NAME OF DB TO CONNECT TO/>;TDS=7.0</attribute>
       <attribute name="Properties"></attribute>
       <attribute name="MinSize">0</attribute>
       <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
       <attribute name="JDBCUser">jboss</attribute>
       <attribute name="GCMinIdleTime">1200000</attribute>
     </mbean>
     <mbean name="DefaultDomain:service=Hypersonic">
       <attribute name="Silent">true</attribute>
       <attribute name="Database">default</attribute>
       <attribute name="Trace">false</attribute>
       <attribute name="Port">1476</attribute>
     </mbean>
     <mbean name="DefaultDomain:service=Jetty">
       <attribute name="UnpackWars">false</attribute>
     </mbean>
     <mbean name="DefaultDomain:service=Naming">
       <attribute name="Port">1099</attribute>
     </mbean>
     <mbean name="DefaultDomain:service=XADataSource,name=DefaultDS">
       <attribute name="TimestampUsed">false</attribute>
       <attribute name="Password">jdbc</attribute>
       <attribute name="MaxSize">0</attribute>
       <attribute name="InvalidateOnError">false</attribute>
       <attribute name="IdleTimeout">1800000</attribute>
       <attribute name="GCInterval">120000</attribute>
       <attribute name="Blocking">true</attribute>
       <attribute name="LoggingEnabled">false</attribute>
       <attribute name="IdleTimeoutEnabled">false</attribute>
       <attribute name="GCEnabled">false</attribute>
       <attribute name="URL">jdbc:freetds:sqlserver://<INSERT IP ADDRESS OF
SERVER/>:1433/<INSERT NAME OF DB TO CONNECT TO/>;TDS=7.0</attribute>
       <attribute name="Properties"></attribute>
       <attribute name="MinSize">0</attribute>
       <attribute name="MaxIdleTimeoutPercent">1.0</attribute>
       <attribute name="JDBCUser">jboss</attribute>
       <attribute name="GCMinIdleTime">1200000</attribute>

     </mbean>
     <mbean name="EJB:service=ContainerFactory">
       <attribute name="VerifierVerbose">true</attribute>
       <attribute name="MetricsEnabled">false</attribute>
       <attribute name="VerifyDeployments">true</attribute>
     </mbean>
   </server>

-----Original Message-----
From: Antonio Vazquez [mailto:vazquezf AT aucland.com]
Sent: 10 April 2001 09:25
To: TDS Development Group
Subject: [freetds] FreeTDS_jdbc.jar with Jboss 2.1
Importance: High

Hi all,
has anybody configure the MS-SQL Server with Jboss 2.1 using the FreeTDS
driver.I try to configure it, but Jboss Server freeze when try to configure
the pool.
If somebody has reached it,could send me the jboss.jcml file with the
configuration or tell about how I can configure it?

Thanks in advance and Regards.

Antonio

---
You are currently subscribed to freetds as: [jez AT whatsonwhen.com]
To unsubscribe, forward this message to
$subst('Email.Unsub')

---
You are currently subscribed to freetds as: [Matthew AT stimuluss.com.au]
To unsubscribe, forward this message to $subst('Email.Unsub')