-
1. Re: No connection with Informix DataSource (read only mode n
lybo Nov 10, 2003 6:56 AM (in response to levw)According to the Informix JDBC doc, the Connection.setReadOnly() is part of the Unsupported methods.
-
2. Re: No connection with Informix DataSource (read only mode n
levw Nov 10, 2003 7:50 AM (in response to levw)But I don't use setReadOnly(). I just call ds.getConnection(), and it fails. I didn't ask it to be read-only...
-
3. Re: No connection with Informix DataSource (read only mode n
lybo Nov 13, 2003 7:04 AM (in response to levw)please post more info
your JDBC & Jbos release, more detail on the error
how is the standardjbosscmp-jdbc.xml ? -
4. Re: No connection with Informix DataSource (read only mode n
tomasz1 Nov 14, 2003 4:36 AM (in response to levw)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 -
5. Re: No connection with Informix DataSource (read only mode n
lybo Nov 18, 2003 2:53 AM (in response to levw)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.. -
6. Re: No connection with Informix DataSource (read only mode n
tomasz1 Nov 18, 2003 9:53 AM (in response to levw)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.
-
7. Re: No connection with Informix DataSource (read only mode n
tomasz1 Nov 19, 2003 10:27 AM (in response to levw)Hey that's cool! Have downloaded JDBC 2.21 JC5 and it works now with JBoss 3.2.2. Thanks!