Informix datasource not working following Jboss upgrade
hengus Jan 15, 2004 3:51 PMWe 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)