Set libraries property for jdbc connection in Spring on AS400

[brucejin]

I set up libraries property for jdbc connection in Spring config file:

<bean abstract="false" autowire="default" class="org.apache.commons.dbcp.BasicDataSource" dependency-check="default" id="as400_local1" lazy-init="true" singleton="true">
<property name="driverClassName"> <value>com.ibm.db2.jdbc.app.DB2Driver</value> </property>
<property name="url"> <value>jdbc:db2://*LOCAL;libraries=FILELIB;translate binary=true</value> </property>
<property name="username"> <value> </value> </property>
<property name="password"> <value> </value> </property>
</bean>

But my application (a Java program calling a RPG that reads a file in FILELIB) can not see the file. (A MSGW in QSQSRVR job).

When I switch to use toolbox driver then the program works (The called RPG can see the file in FILELIB).

<property name="driverClassName"> <value>com.ibm.as400.access.AS400JDBCDriver</value> </property>
<property name="url"> <value>jdbc:as400://192.168.0.170;libraries=FILELIB;translate binary=true</value> </property>
<property name="username"> <value>user</value> </property>
<property name="password"> <value>password</value> </property>

Any idea?

Thanks
Bruce

[trisberg]

Bruce,

This doesn't look like a Spring issue. Looks more like an issue regarding the two different JDBC drivers you are using. Probably better off trying an IBM DB2 forum.