java - Cannot load netezza JDBC driver -


i have configured netezza db in spring . have added dependent nzjdbc.jar in classpath

spring config:

<bean id="qa_cam_base_jdbctemplate" class="org.springframework.jdbc.core.jdbctemplate"> 

    <!-- initialization data source -->  <bean id="qa_cam_base_datasource" class="org.springframework.jdbc.datasource.drivermanagerdatasource">     <property name="driverclassname" value="${com.ec.database.driver}"/>     <property name="url" value="${com.ec.database.url}"/>     <property name="username" value="${com.ec.database.user}"/>     <property name="password" value="${com.ec.database.pass}"/> 

pom xml config   <dependency>     <groupid>org.netezza</groupid>     <artifactid>netezza</artifactid>     <version>1.0</version>     <scope>system</scope>     <systempath>${basedir}/src/main/resources/lib/nzjdbc.jar</systempath> </dependency>  <resource>      <directory>${basedir}/src/main/resources/lib</directory>      <targetpath>web-inf/lib</targetpath>  </resource>  </webresources> 

put nzjdbc.jar in local maven repository

mvn install:install-file -dfile=netezza.jar -dgroupid=org.netezza -dartifactid=netezza -dversion=1.0 -dpackaging=jar 

(execute in directory netezza.jar located

and use normal dependency:

<dependency>     <groupid>org.netezza</groupid>     <artifactid>netezza</artifactid>     <version>1.0</version> </dependency> 

@see guide installing 3rd party jars


Comments