Data Sources do not display OS400 Logical Files

We are an IBM iSeries shop running V5R3M5. I am using the JTOpen toolkit to provide the database connectivity.

The issue I am having is this: When I expand the Data Source the "Tables" list shows the physical files, (OS400 object type *file, Attribute PF). The logical files, (OS400 object type *file, Attribute LF) do not show up in the list.

What needs to be done to have the logical files appear in either the "Tables" or the "Views" list.

Ed

[470 byte] By [eflittle] at [2007-11-26 11:47:24]
# 1

I don't have access to an OS/400 database, so I can't answer your specific case.

Does the JTOpen toolkit include a JDBC driver (specifically, one that's JDBC 3.0 compliant)?

The nodes under Data Sources generate their lists by calling DatabaseMetadata.getTables(), with the types set to either {"TABLES"} or {"VIEWS"}.

Could you write a small program to see what JTOpen returns for your particular database?

-JIm

JimDavidson at 2007-7-7 11:58:43 > top of Java-index,Development Tools,Java Tools...