Install Netezza JDBC driver in JBoss7.1.1
sivasaravanank1 Oct 1, 2016 5:04 PMHello,
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,