JDBC Adapter error

[Former Member]

Hi All,

I am sending a File to DB2 iSeries database.

In the JDBC adapter configuration the MESSAGE PROTOCOL I am using is XML SQL FORMAT and

<b><i>UNDER EO the parameters i am using is

Database Table Name:MATTEST

Key Column Name :MATTEST</i></b>

So I am getting the Following error.

Error: Database error accessing key table 'MATTEST': SQLException: [SQL0204] MATTEST in SAPUSER type *FILE not found.

If the EO parameters I used is NONE then not getting any error but not understanding where the message is going.

Can anyone help me out with this scenario.

Thank you,

Joslyn.

[former_member431549]

Are you using the proper iSeries JDBC driver ? Other DB2 JDBC drivers will not work with an AS/400.

How are you controlling your library list used to find the table ? We put in on the connection string.

DRIVER: com.ibm.as400.access.AS400JDBCDriver

CONNECTION: jdbc:as400://iseries.company.com;naming=sql;errors=full;libraries=datalib

[Former Member]

Hi Tim,

The JDBC Driver and Connection parameters we are using is,

DRIVER:com.ibm.as400.access.AS400JDBCDriver

Connection:jdbc:as400://10.145.10.11/QKPR;user=sapuser;password=sapuser.

Can you explain me how to control the library list to find the table?

Thank you.

[former_member431549]

You have two choices for controlling the library list.

You can add 'libraries=xxxxxxlib' to your connection string. I am pretty sure you can specify more than one library here, but you should only need the library that contains your table.

Or you can control the library list of the user-id like you would for any user-id on the system. System value QUSRLIBL, or an initial program for the user that chages library list.

[Former Member]

Hi ,

<i>Database Table Name:MATTEST

Key Column Name :MATTEST</i>

Are the Database table name and key column name are same?

Just check the Names..

Sekhar