RE: Data connection doesn't return any tables

Anita,

That defaults for me when I open the new connection window.

The connection url is "jdbc:as400://as400dev"

I really think the issue may be in the filtering.  If I don't change the 
filters some schemas and tables are returned.  If I change the filter nothing 
is returned.

Leaving the entry "schema not like qsys%" will return a few libraries and the 
tables in them.  Removing this entry and adding one that says "schema like 
rcheva1" which I believe should select all tables in my library doesn't return 
anything and I don't receive any errors.  At least, not any I am made aware of. 
 Above the status bar it displays a message about connecting to the host, 
followed by something about metadata then the window disappears.  The second 
message doesn't display long enough for me to read it all.  The status bar 
never reaches the right side of the window. 

Rick

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx
[mailto:wdsci-l-bounces@xxxxxxxxxxxx]On Behalf Of Anita Leung
Sent: Monday, September 27, 2004 11:01 AM
To: Websphere Development Studio Client for iSeries
Cc: wdsci-l@xxxxxxxxxxxx; wdsci-l-bounces@xxxxxxxxxxxx
Subject: RE: [WDSCI-L] Data connection doesn't return any tables

Rick,

You have to specify the Host, then your connection URL will be "jdbc:as400:
//yourhostname".

Regards,
Anita Leung
iSeries Web and Java Development Tools
IBM Toronto Laboratory
Phone: (905)413-4215, Tie-Line: 969-4215
leunga@xxxxxxxxxx