Announcement Announcement Module
Collapse
No announcement yet.
Set libraries property for jdbc connection in Spring on AS400 Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • Set libraries property for jdbc connection in Spring on AS400

    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

  • #2
    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.

    Comment

    Working...
    X