RE: [WDSCI-L] Data connection doesn't return any tables

[Anita Leung <leunga@xxxxxxxxxx>]

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




                                                                           
             <Rick.Chevalier@a                                             
             mericredit.com>                                               
             Sent by:                                                   To 
             wdsci-l-bounces@m         <wdsci-l@xxxxxxxxxxxx>              
             idrange.com                                                cc 
                                                                           
                                                                   Subject 
             09/27/2004 11:42          RE: [WDSCI-L] Data connection       
             AM                        doesn't return any tables           
                                                                           
                                                                           
             Please respond to                                             
                 Websphere                                                 
                Development                                                
             Studio Client for                                             
                  iSeries                                                  
                                                                           
                                                                           




Anita,

I think I am using the Toolbox JDBC driver you mention.  These are the
values from the Database Connection window:

Database vendor type:          DB2 Universal Database for iSeries, V5R1
JDBC driver:                         AS/400 Toolbox for Java JDBC Driver
JDBC driver class:             com.ibm.as400.access.AS400JDBCDriver
(grayed out)
Class location:
C:/WDSC/iseries/eclipse/plugins/com.ibm.etools.iseries.toolbox_
                                                       5.1.2
/runtime/jt400.jar
Connection URL:                      jdbc:as400:             (grayed out)

Is this correct?

Rick

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx
[mailto:wdsci-l-bounces@xxxxxxxxxxxx]On Behalf Of Anita Leung
Sent: Friday, September 24, 2004 4:02 PM
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

What JDBC driver are you using? Try with a Toolbox JDBC driver,
com.ibm.as400.access.AS400JDBCDriver, where you can get it from jt400.jar
in the com.ibm.etool.iseries.toolbox plugin.

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

_______________________________________________
This is the Websphere Development Studio Client for iSeries  (WDSCI-L)
mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.