0 Replies Latest reply on Oct 28, 2003 9:04 AM by Peter Hall

    jboss3.2.1 Sybase XA DataSource

    Peter Hall Newbie

      Hi all,

      anyone managed to get an Sybase (jconnect5.5) XA DataSource working on Jboss3.2.1? My Sybase-xa-ds.xml looks like:


      <xa-datasource>
      <jndi-name>RWSybase</jndi-name>
      <connection-url>jdbc:sybase:Tds:host:port</connection-url>
      <xa-datasource-class>com.sybase.jdbc2.jdbc.SybXADataSource</xa-datasource-class>
      <xa-datasource-property name="User">user</xa-datasource-property>
      <xa-datasource-property name="Password">password</xa-datasource-property>

      <user-name>user</user-name>
      password
      <min-pool-size>2</min-pool-size>
      </xa-datasource>



      When I come to use this (Bean managed Persistence) an exception is thrown:

      2003-10-28 15:31:32,173 ERROR [org.jboss.ejb.plugins.LogInterceptor - MrPercent] TransactionRolledbackException, causedBy:
      java.lang.IllegalArgumentException: port out of range:-1
      at java.net.InetSocketAddress.(InetSocketAddress.java:103)
      at java.net.Socket.(Socket.java:119)
      at com.sybase.jdbc2.timedio.RawDbio.doConnect(RawDbio.java:88)
      at com.sybase.jdbc2.timedio.InStreamMgr.(InStreamMgr.java:94)
      at com.sybase.jdbc2.tds.Tds.login(Tds.java:364)
      at com.sybase.jdbc2.jdbc.SybConnection.tryLogin(SybConnection.java:218)
      at com.sybase.jdbc2.jdbc.SybConnection.regularConnect(SybConnection.java:195)
      at com.sybase.jdbc2.jdbc.SybConnection.(SybConnection.java:174)
      at com.sybase.jdbc2.jdbc.SybPooledConnection.(SybPooledConnection.java:72)
      at com.sybase.jdbc2.jdbc.SybXAConnection.(SybXAConnection.java:77)
      at com.sybase.jdbc2.jdbc.SybXADataSource.createConnection(SybXADataSource.java:147)
      at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:473)
      at com.sybase.jdbc2.jdbc.SybDriver.connect(SybDriver.java:505)
      at com.sybase.jdbc2.jdbc.SybDataSource.getConnection(SybDataSource.java:270)
      at com.sybase.jdbc2.jdbc.SybXADataSource.getXAConnection(SybXADataSource.java:97)
      at org.jboss.resource.adapter.jdbc.xa.XAManagedConnectionFactory.createManagedConnection(XAManagedConnectionFactory.java:137)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnection(InternalManagedConnectionPool.java:352)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:151)
      at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool.getConnection(JBossManagedConnectionPool.java:643)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:413)
      at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:331)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:488)


      Looks like the port number for the connection is not being picked up correctly.

      regards,

      Mr%