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;l*ibraries=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


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.