We have been successfully using Jboss version 3.2.1 and a datasource to Informix 9.3. Following upgrading Jboss to 3.2.3 we now get the following error:

SQLException: Read only mode not supported

Is there a change in the way that datasources are obtained between these 2 versions and if so how can I specify the connection type to be read and write.

Any help would be appreciated.

Regards

Martin Thomas

PS here is the DS XML and a more detailed stack trace:


<local-tx-datasource>
<jndi-name>InformixDS</jndi-name>
<connection-url>jdbc:informix-sqli://hestia:1703/paysol:informixserver=vfonedev</connection-url>
<driver-class>com.informix.jdbc.IfxDriver</driver-class>
<user-name>username</user-name>
password
</local-tx-datasource>


10:29:38,583 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection:
org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Read only mode not supported)
at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:160)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:477)
at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:213)
at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:496)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:425)
at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:318)
at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:477)
at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:814)
at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
at nz.co.vodafone.creditcard.persistence.ConnectionFactory.getDataSourceConnection(ConnectionFactory.java:80)