• The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
Menu
  • The Four Hundred
  • Subscribe
  • Media Kit
  • Contributors
  • About Us
  • Contact
  • Using Library Lists for JDBC File Access

    May 31, 2002 Timothy Prickett Morgan

    Hey, David:

    How do you set your library list with JDBC and JTOpen? The JDBC documentation says that I should use system naming along with a libraries property. When I do that, it appears that the search stops on the first library. The only way I can get a select statement that uses files from more than one library is to qualify the library name. That makes it difficult to test.

    BCD Int'l

    — James

    To be consistent with the way that the ODBC uses library names, the JTOpen 3.0 JDBC drivers take the first library that you specify and ignore the rest because the first library specified becomes the default library. To make the libraries property work the way you would expect, you have to specify a comma (,) at the beginning of the

    libraries

    property. The extra comma tells the JDBC driver that you do not want a default library and the libraries following the comma are searched in order.

    You can specify the connection properties like the libraries property as part of the URL on your JDBC URL. The IBM Information Center has a complete list of the available connection properties. For example, the following connection URL will cause JDBC to search three libraries:

    DriverManager.registerDriver
        (new com.ibm.as400.access.AS400JDBCDriver());
    conn = DriverManager.getConnection(
        "jdbc:as400://mySystem;naming=system;libraries=
        ,lib1,lib2,lib3")
    stmt = connection.createStatement();
    
    rs = stmt.executeQuery("select * from fileinlib1 
        join fileinlib2…");
    while (rs.next()) {
        String field1 = rs.getString(1);
     }
    

    After connecting with this connection URL, the SQL select statement will search libraries lib1, lib2, and lib3 in order looking for files.

    — David

    Sponsored By
    BCD INT’L

    BCD’s Web, and iSeries 400 Application Development Tools–won 10 industry
    Awards
    and have 1,000’s of developers.

    Need to extend your applications to the Web or create new ones—Fast ?

    Then try Award Winning WebSmart–Superior Technology that lets you create
    Web solutions fast, easy and affordably.

    –Get a FREE DOWNLOAD today–

    Run on iSeries 400 HTTP/Apache Server and / or Windows, Linux, Unix, AIX…Multi-platform / multi-server, one effort!

    Click & visit—www.BCDsoftware.com

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Tags: Tags: mgo_rc, Volume 2, Number 42 -- May 31, 2002

    Sponsored by
    Rocket Software

    Software built on TRUST. Delivered with LOVE.

    For over 35 years, Rocket Software’s solutions have empowered businesses to modernize their infrastructure, unlock data value, and drive transformation – all while ensuring modernization without disruption.

    Learn More

    Share this:

    • Reddit
    • Facebook
    • LinkedIn
    • Twitter
    • Email

    Prevent Someone Else from Peeking at Your Window 2000/XP System Proper Use of QTEMP

    Leave a Reply Cancel reply

MGO Volume: 2 Issue: 42

This Issue Sponsored By

    Table of Contents

    • A Better Way to Get Query/400 Definitions?
    • Odds and Ends
    • Using Library Lists for JDBC File Access

    Content archive

    • The Four Hundred
    • Four Hundred Stuff
    • Four Hundred Guru

    Recent Posts

    • The Power11 Transistor Count Discrepancies Explained – Sort Of
    • Is Your IBM i HA/DR Actually Tested – Or Just Installed?
    • Big Blue Delivers IBM i Customer Requests In ACS Update
    • New DbToo SDK Hooks RPG And Db2 For i To External Services
    • IBM i PTF Guide, Volume 27, Number 33
    • Tool Aims To Streamline Git Integration For Old School IBM i Devs
    • IBM To Add Full System Replication And FlashCopy To PowerHA
    • Guru: Decoding Base64 ASCII
    • The Price Tweaking Continues For Power Systems
    • IBM i PTF Guide, Volume 27, Numbers 31 And 32

    Subscribe

    To get news from IT Jungle sent to your inbox every week, subscribe to our newsletter.

    Pages

    • About Us
    • Contact
    • Contributors
    • Four Hundred Monitor
    • IBM i PTF Guide
    • Media Kit
    • Subscribe

    Search

    Copyright © 2025 IT Jungle