0 Replies Latest reply on Oct 1, 2016 5:04 PM by Sivasaravanan Kandasamy

    Install Netezza JDBC driver in JBoss7.1.1

    Sivasaravanan Kandasamy Newbie

      Hello,

       

      I need to install a Netezza JDBC driver(nzjdbc3.jar) in JBoss7.1.1.Final for my applicaiton. Below are the list of steps I have followed to install the driver

       

      1. Copied the Netezza JDBC driver nzjdbc3.jar in modules folder(path : $JBOSS_HOME\modules\org\netezza\nzjdbc3\main)

      2. Added the module entry and dependencies in module.xml as below

      `

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

      <module xmlns="urn:jboss:module:1.0" name="org.netezza.nzjdbc3">

          <resources>

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

          </resources>

          <dependencies>

                <path name="javax/naming"/>

                <path name="javax/naming/directory"/>

                <path name="javax/naming/event"/>

                <path name="javax/naming/spi"/>

                <path name="javax/sql">

           </dependencies>

      </module>

      `

      3. Added Datasource and driver configurations in standalone-full.xml

      `

      <datasources>

             <datasource jndi-name="java:jboss/datasources/ExampleDS" pool-name="ExampleDS" enabled="true" use-java-context="true">

                  <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>

                  <driver>h2</driver>

                  <security>

                  <user-name>sa</user-name>

                  <password>sa</password>

                  </security>

             </datasource>

       

             <datasource jndi-name="java:/jdbc/DB1" pool-name="Db1" enabled="true" use-java-context="true">

                  <connection-url>jdbc:netezza://localhost:5480/DB1</connection-url>

                  <driver>netezza</driver>

                  <security>

                  <user-name>DB1</user-name>

                  <password>testuser</password>

                  </security>

             </datasource>               

         

             <drivers>

                  <driver name="h2" module="com.h2database.h2">

                  <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>

                  </driver>

       

                  <driver name="netezza" module="org.netezza.nzjdbc3">

                  <driver-class>org.netezza.Driver</driver-class>

                  <xa-datasource-class>org.netezza.datasource.NzDatasource</xa-datasource-class>

                  </driver>

             </drivers>

      </datasources>

      `

      here, the problem is, I am getting the below dependencies error when I am starting my application in the server and that will force to stopping the deployment.

      `

      .......

      .......

      6:36:17,040 INFO  [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found my-tools.war in deployment directory. To trigger deployment create a file called my-tools.war.dodeploy

      16:36:29,080 INFO  [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report

      JBAS014775:    New missing/unsatisfied dependencies:

            service jboss.jdbc-driver.netezza (missing) dependents: [service jboss.data-source.java:/jdbc/DB1]

       

      16:36:29,096 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015876: Starting deployment of "my-tools.war"

      16:36:33,797 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry xml-apis.jar in "/C:/server/Softwares/jboss-as-7.1.1.Final/standalone/deployments/my-tools.war/WEB-INF/lib/serializer-2.7.1.jar"  does not point to a valid jar for a Class-Path reference.

      16:36:33,801 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry xercesImpl.jar in "/C:/server/Softwares/jboss-as-7.1.1.Final/standalone/deployments/my-tools.war/WEB-INF/lib/xalan-2.7.1.jar"  does not point to a valid jar for a Class-Path reference.

      16:36:33,803 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry xml-apis.jar in "/C:/server/Softwares/jboss-as-7.1.1.Final/standalone/deployments/my-tools.war/WEB-INF/lib/xalan-2.7.1.jar"  does not point to a valid jar for a Class-Path reference.

      16:36:33,805 WARN  [org.jboss.as.server.deployment] (MSC service thread 1-1) Class Path entry serializer.jar in "/C:/server/Softwares/jboss-as-7.1.1.Final/standalone/deployments/my-tools.war/WEB-INF/lib/xalan-2.7.1.jar"  does not point to a valid jar for a Class-Path reference.

      16:36:34,808 INFO  [org.jboss.as] (MSC service thread 1-1) JBAS015951: Admin console listening on http://127.0.0.1:9990

      16:36:34,809 ERROR [org.jboss.as] (MSC service thread 1-1) JBAS015875: JBoss AS 7.1.1.Final "Brontes" started (with errors) in 24727ms - Started 349 of 570 services (129 services failed or missing dependencies, 79 services are passive or on-demand)

      16:36:35,009 INFO  [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS015870: Deploy of deployment "my-tools.war" was rolled back with failure message JBAS014750: Operation handler failed to complete

      16:36:35,536 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-2) JBAS015877: Stopped deployment my-tools.war in 525ms

      16:36:35,538 ERROR [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) {"JBAS014653: Composite operation failed and was rolled back. Steps that failed:" => {"Operation step-2" => "JBAS014750: Operation handler failed to complete"}}

      `

      What are the dependencies I need to add or I am missing here  ?

       

      Thanks in advance!!

      Regards,