AS400 DB2 access with unqualified names

Hi,

I unsuccessfull try to access AS400 tables throw JDBC.

In my code, I only use unqualified table names and I set the driver "libraries" property to "mylib1, mylib2...".

Nevertheless, only tables stored in the first library are accessibles.

I know that it was possible by using ODBC, so maybe someone know an issue to reach unqualified tables names stored in more than one library.

Thanks,

Vincent Garand

[463 byte] By [vs07] at [2007-9-26 5:22:19]

# 1

My documentation for the AS/400 Toolbox for Java says this for the "libraries" property:

The AS/400 libraries to add to the server's job library list. For Native, only one library is allowed and it will be used as the default library.

So you must be using the native JDBC driver and not the Toolbox driver. You could try switching to the Toolbox driver.

DrClap at 2007-6-29 19:28:36 >

Database Connectivity New Topic