No connection with Informix DataSource (read only mode not s

[levw]

We have defined an Informix DataSorce and try to use SessionBean to access data through JDBC.
But when the SessionBean calls getConnection(), the following exception is thrown:

16:21:56,359 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)

Can somebody help?

[lybo]

According to the Informix JDBC doc, the Connection.setReadOnly() is part of the Unsupported methods.

[levw]

But I don't use setReadOnly(). I just call ds.getConnection(), and it fails. I didn't ask it to be read-only...

[lybo]

please post more info
your JDBC & Jbos release, more detail on the error
how is the standardjbosscmp-jdbc.xml ?

[tomasz1]

Hi,
I have the same problem, I've checked it up with JBoss 3.2.1 and it has worked without a problem, so it has to do with JBoss 3.2.2.

My datasource:

<local-tx-datasource>
<jndi-name>my jndiname</jndi-name>
<connection-url>my url</connection-url>
<driver-class>com.informix.jdbc.IfxDriver</driver-class>
<user-name>my user</user-name>
my password
<connection-property name="DBDATE">DMY4.</connection-property>
<connection-property name="INFORMIXSERVER">my server</connection-property>
<connection-property name="database">my database</connection-property>
</local-tx-datasource>


Since I didn't specifiy readonly either, I guess JBossManagedConnectionPool does it somehow.

Now this is a real showstopper, Informix datasources are not usable now.

Tomasz

[lybo]

I'm working with Jboss 3.0.7 and JDBC 2.21 JC2
I do not face this problem.
I have also tried with Jboss 3.2.2 and JDBC 2.21 JC5, also it works fine..

[tomasz1]

That's interesting, we are using 2.20 JC1. The problems didn't exist before JBoss 3.2.2. I'll try to get the new version.

[tomasz1]

Hey that's cool! Have downloaded JDBC 2.21 JC5 and it works now with JBoss 3.2.2. Thanks!