Trying to setup a pool with a true XA compliant
driver.

<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=UDB">
    <attribute name="PoolName">UDB</attribute>
                <attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>

 <!--                   <attribute
name="DataSourceClass">COM.ibm.db2.jdbc.DB2XADataSource</attribute>
-->
    <attribute name="Properties"></attribute>
    <attribute
name="URL">jdbc:db2:ovrsghtd</attribute>
    <attribute
name="GCMinIdleTime">1200000</attribute>
    <attribute name="JDBCUser">ovrsghtd</attribute>
    <attribute name="MaxSize">1</attribute>
    <attribute name="Password">ovrsghtd</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">1</attribute>
                <attribute
name="TransactionIsolation">TRANSACTION_REPEATABLE_READ</attribute>
  </mbean>

        <mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=GCOND">
    <attribute name="PoolName">GCOND</attribute>
    <attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<!--    <attribute
name="DataSourceClass">com.sybase.jdbc2.jdbc.SybXADataSource</attribute>
-->
    <attribute name="Properties"></attribute>
    <attribute
name="URL">jdbc:sybase:Tds:sunliteuat.ny.jpmorgan.com:6100/positions</attribute>
    <attribute
name="GCMinIdleTime">1200000</attribute>
    <attribute name="JDBCUser">PTSServe</attribute>
    <attribute name="MaxSize">10</attribute>
    <attribute name="Password">password</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>



The Problem is that if I set the 'DataSourceClass'
attribute to anything other than
'org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl' The
pool does not get initialized. This seems to be
because in 'org.jboss.jdbc.XADataSourceLoader' we try
to call 'setURL()' & 'setProperties()' method on the
'DataSourceClass' registered in jboss.jcml - these are
not tandard XADataSource/DataSource methods. This
causes a NoSuchMethodException when the pool is
initializing.

 How can I setup a pool with a real XA compliant
DataSource for ex
'com.sybase.jdbc2.jdbc.SybXADataSource'

Regards
T


__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/

_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to