2 Replies Latest reply on Nov 7, 2014 12:12 AM by arunadl

    JBoss 7 - Informix JDBC Driver Issue

    stiel

      Hello. 

       

      I am having trouble setting up an Informix JDBC Driver XA Datasource.  I followed the instructions on http://www.javalinux.it/wordpress/2011/07/14/how-to-create-an-manage-datasources-in-as7/ , but I still can't get JBoss to pickup the datasource.  I can get the mysql setup to work by following the directions, but nothing shows up for Informix. 

       

      Module.xml

      --------------------

      <?xml version="1.0" encoding="UTF-8"?>

      <module xmlns="urn:jboss:module:1.1" name="com.informix.jdbc">

        <resources>

          <resource-root path="ifxjdbc.jar"/> 

          <resource-root path="ifxjdbcx.jar"/>

        </resources>

        <dependencies>

          <module name="javax.api"/>

        </dependencies>

      </module>

       

      standalone.xml

      --------------------------

      <driver name="informix" module="com.informix.jdbc">

          <driver-class>

              com.informix.jdbc.IfxDriver

          </driver-class>

          <xa-datasource-class>

              com.informix.jdbcx.IfxXADataSource

          </xa-datasource-class>

      </driver>

       

      The server starts up without errors, but when I check the datasources ([standalone@localhost:9999 /] /subsystem=datasources:installed-drivers-list), the Informix datasources doesn't show up.  Any help would be greatly appreciated.

       

      Thanks,
      Sam

        • 1. Re: JBoss 7 - Informix JDBC Driver Issue
          wdfink

          If you install the module (without changeing the standalone.xml) do you see that the module is started within the logfile?

          What logmessages do you see if you add teh DS to standalone.xml?

          • 2. Re: JBoss 7 - Informix JDBC Driver Issue
            arunadl

            Hi,

            I just experienced the same issue and while searching i got this forum thread.Yesterday i just fixed the above issue its because the jar files

            • ifxjdbc.jar
            • ifxjdbcx.jar

            Jar files path :  D:\jboss-as-7.1.1.Final\modules\com\informix\main\

            Extract the jar  ifxjdbc.jar (using winrar) you will get below folders

            • com
            • META-INF
            • org

            Please open META-INF folder and add "services" folder inside that you just add a file named "java.sql.Driver" inside this just specify the driver class path like this "com.informix.jdbc.IfxDriver" and insert the same it to the jar file just drag the service folder to the jar file opened in the winrar

             

            In the same way just add same file with class name "com.informix.jdbcx.IfxXADataSource"

             

            After inserting the files in the both jars and deploy it once more then the driver will list.

             

            Thanks

            Arun