2 Replies Latest reply on Apr 17, 2017 4:17 PM by Cristopher Torres

    Problems creating data sources for a virtual database in EAP 6.1

    Cristopher Torres Novice

      Hello I find myself deploying a virtual database in which I made a connection with informix.

      I tried to deploy it manually in the application server console and I do not recognize the jdbc.jar driver at the time of creating the data sources, it only happens to me with the informix drivers since with any other driver the console recognizes them.

        • 1. Re: Problems creating data sources for a virtual database in EAP 6.1
          Frank Langelage Master

          The informix driver is not a JDBC 4 driver. It is not recognized automatically.

           

          Create a file META-INF/services/java.sql.Driver with only this line inside:

          com.informix.jdbc.IfxDriver

           

          Then add this file to the existing ifxjdbc.jar:

          jar -uvf ../ifxjdbc.jar META-INF/services/java.sql.Driver

          adding: META-INF/services/java.sql.Driver(in = 28) (out= 30)(deflated -7%)

           

          Your server.log should show lines like these then:

          INFO  [org.jboss.as.server.deployment#start] WFLYSRV0027: Starting deployment of "ifxjdbc.jar" (runtime-name: "ifxjdbc.jar")

          INFO  [org.jboss.as.connector.deployers.jdbc#deploy] WFLYJCA0004: Deploying JDBC-compliant driver class com.informix.jdbc.IfxDriver (version 3.0)

          INFO  [org.jboss.as.connector.deployers.jdbc#start] WFLYJCA0018: Started Driver service with driver-name = ifxjdbc.jar

          INFO  [org.jboss.as.server#handleResult] WFLYSRV0010: Deployed "ifxjdbc.jar" (runtime-name : "ifxjdbc.jar")