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%