1 Reply Latest reply on Feb 19, 2004 6:55 AM by lybo

    Informix datasource not working following Jboss upgrade

    hengus Newbie

      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)