4 Replies Latest reply on Jul 28, 2005 1:58 PM by Frank Grimes

    Problems with informix

    ed chav Newbie

      I don't know what's wrong,
      first when i configure informix driver in JBoss I had a problem that said something about it doesn't support read only mode :


      " 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) "

      Then I went to ibm site to download the lastest driver version(informix JDBC V 3.0). And the error was gone but a new error apears, it say something about a ClassCastException.

      "09:44:14,086 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.lang.ClassCastException) "

      My aplication is just an entity bean(CMP) and a session bean (State full), the error apears as soon as JBoss try to deploy these beans

        • 1. Re: Problems with informix
          ed chav Newbie

          Problem solved, Jboss 3.2.7 seems to work with Informix JDBC 2.21 JC4

          I wonder why informix JDBC 3.0 JC1 didn't work, maybe in JBoss 4.
          There should be a JDBC versions for JBoss, it would save a lot of time.

          • 2. Re: Problems with informix
            Frank Langelage Master

            With older version of Informix JDBC it was enough to put ifxjdbc.jar into $JBOSS_HOME/server/?/lib.
            With 3.0 driver I got same or similar problems and found out, that I also have to put ifxjdbcx.jar into the lib-dir.

            • 3. Re: Problems with informix
              Jim Brownfield Newbie

              I don't know if this is related, but I'm having a similar problem trying to use JDBC 3.0JC1 under Java Web Start where it throws a class cast exception.

              I believe they changed the Informix Driver to use the single-parameter version of Class.forName() instead of the three-parameter version that allows the ClassLoader to be passed in. Therefore, if ifxjdbc[x].jar was not loaded by the system ClassLoader, a ClassCastException is thrown.

              We don't have paid support at IBM (therefore, we can't even report a problem), although I'm pursuing other channels. If any of you guys has access, you might try reporting the problem to IBM.

              I'd love to get this issue resolved.

              • 4. Re: Problems with informix
                Frank Grimes Newbie

                FYI, 3.00JC2 seems to have resolved the ifxjdbc.jar dependency on ifxjdbcx.jar:

                From the release notes's list of fixed bugs:
                "171425 IFXJDBCX.JAR IS NOW REQUIRED. JAVA.LANG.NOCLASSDEFFOUNDERROR: COM/INFORMIX/JDBCX/IFXXAREUSABLECONNECTION"

                It's available here:

                http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc