Re: JDBC configuration on iSeries

[rob@xxxxxxxxx]

This is fun.

I looked in QSYS2 at the SYS* files.  SYSINDEXES only lists files created 
with CREATE INDEX.  SYSVIEWS only lists files created with CREATE VIEW. 
However SYSTABLES lists all physical and logical files.  These SYS* files 
in QSYS2 are designed to be the standard lookup files for tools like 
SeeBeyond and others.  The theory is that these files should exist on all 
systems, including Oracle, and others.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"Steve Landess" <sjl_123@xxxxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/20/2004 11:32 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
<midrange-l@xxxxxxxxxxxx>
cc

Subject
JDBC configuration on iSeries






All,

My client is using SeeBeyond EAI, and one of the developers 
was having trouble when trying to configure a JDBC connection 
to the iSeries box (830, V5R1) using the JDBC driver supplied by
SeeBeyond. 

SeeBeyond doesn't have a clue about how this should be 
configured - apparently they don't have any customers that are using 
their JDBC driver to connect to the iSeries database.

We finally got connected to the iSeries machine, but this JDBC 
driver cannot see DDS-created files - only tables created by the 
CREATE TABLE command or views (CREATE VIEW).

Is this the norm for JDBC drivers, or is it just a SeeBeyond limitation?

Regards,
Steve
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.