× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. JAVA400-L
  3. June 2002

RE: AW: OF: what is websphere (locate Tomcat)

OK, I have tried a couple of other things and need to knwo where to go
next...

I tried the IP address as both the System name and the Domain name (listed
in the Host table) and now I am getting a different error, so I think
progress is being made (although I still don't understand why the IP address
does not work).

The error I receive now is "No suitable driver."  Are we back to a classpath
issue?  I put all the .jar files in the WEB-INF/lib directory as Dieter
indicated.

Here is the WRKRDBDIRE entry...

Relational          Remote
Database            Location                  Text

S105NTDM            *LOCAL                    Entry added by system


Here is the java code attempting to establish the Connection...

    private Connection con = null ;
    private final String userName = "QSECOFR" ;
    private final String userPassword = "QSEC0810" ;
//    private final String DBlocation = "jdbc:as400://192.168.1.7" ;
    private final String DBlocation = "S105NTDM" ;
    private final String userDB = "com.ibm.as400.access.AS400JDBCDriver" ;

    /**
     * Attempts to establish a database Connection based on the object's
current variables.
     */
    public void establishConnection() throws Exception
    {
        try
        {
            Class.forName( userDB );
            try
            {
                this.con = DriverManager.getConnection( DBlocation ,
                                userName , userPassword );
            }
            catch( Exception e )
            {
// ERROR OCCURS HERE...
                throw new Exception( "User Connection Error: " +
e.getMessage() );
            }
        }
        catch( ClassNotFoundException e )
        {
            throw new Exception( "Class \"" + userDB + "\" Not Found." );
        }
    }




You can go here to view the error.  (I did stop and restart the Server after
every change)
http://www.vamanet.com:1550/example/servlet/ClientList



Any ideas would be most appreciated.  I still need to look at the info David
passed along...


Joel R. Cochran
Director of Internet Services
VamaNet.com
(800)480-8810
mailto:webmaster@vamanet.com


> -----Original Message-----
> From: Dieter.Bender@t-online.de [mailto:Dieter.Bender@t-online.de]
> Sent: Wednesday, June 12, 2002 5:38 AM
> To: java400-l@midrange.com
> Subject: Re: AW: OF: what is websphere (locate Tomcat)
>
>
> Joel,
>
> - the machine with the database you want to access needs an
> entry with a name
> and under IP adress you will see *LOCAL
> - with the toolbox driver AS400JDBCDriver.class you use the
> IP adress or a
> name wich can be resolved to an IP adress by Domain Name
> Services or an entry
> to the Hosts table of the client; this driver works from all
> systems to
> access a DB2/400 database.
> - with the native driver (subprotocol db2) you can connect
> from an as400 to
> any other system with db2 connect, you need an entry with
> *local for the
> local machine and an entry with communication resolution for
> a remote system.
> You use the name from the RDBDIR for the connect, not the ip adress.
>
> If this doesn't solve your problem, it would be best to
> provide some code and
> the exact error messages you get and then we can fix it together.
>
> Dieter
>
> Am Dienstag, 11. Juni 2002 23:15 schrieben Sie:
> > I have an entry, but it lists the system name and not the
> IP address.  I
> > understand from other posts that if the driver is the
> native db2 driver
> > that I need to refer to the configured name instead of the
> IP, but I am not
> > using the db2 driver, i am using the
> > "com.ibm.as400.access.AS400JDBCDriver".  The problem is I
> don't know how to
> > proceed next.
> >
> > Thanks,
> >
> > Joel R. Cochran
> > Director of Internet Services
> > VamaNet.com
> > (800)480-8810
> > mailto:webmaster@vamanet.com
> >
> > > -----Original Message-----
> > > From: MEovino@estes-express.com [mailto:MEovino@estes-express.com]
> > > Sent: Tuesday, June 11, 2002 5:07 PM
> > > To: java400-l@midrange.com
> > > Subject: RE: AW: OF: what is websphere (locate Tomcat)
> > >
> > >
> > >
> > > What seems to be the problem with it?
> > >
> > > Mike E.
> > >
> > >
> > >
> > >
> > >
> > >                     "Joel R. Cochran"
> > >                     <jrc@masi-brac.com       To:
> > > "'java400-l@midrange.com'" <java400-l@midrange.com>
> > >
> > >                     >                        cc:
> > >
> > >                     Sent by:                 Subject:     RE:
> > > AW: OF: what is websphere (locate Tomcat)
> > >                     java400-l-admin@mi
> > >                     drange.com
> > >
> > >
> > >                     06/11/2002 03:50
> > >                     PM
> > >                     Please respond to
> > >                     java400-l
> > >
> > >
> > >
> > >
> > >
> > >
> > > It got me one step farther, but now I'm struggling with
> the RDBDIRE
> > >
> > >
> > > Joel R. Cochran
> > > Director of Internet Services
> > > VamaNet.com
> > > (800)480-8810
> > > mailto:webmaster@vamanet.com
> > >
> > > > -----Original Message-----
> > > > From: MEovino@estes-express.com
> [mailto:MEovino@estes-express.com]
> > > > Sent: Tuesday, June 11, 2002 3:36 PM
> > > > To: java400-l@midrange.com
> > > > Subject: RE: AW: OF: what is websphere (locate Tomcat)
> > > >
> > > >
> > > >
> > > > Joel,
> > > >
> > > > Did Dieter's suggestion work?
> > > >
> > > > Mike E.
> > > >
> > > >
> > > >
> > > >
> > > >                     "Joel R. Cochran"
> > > >                     <jrc@masi-brac.com       To:
> > > > "'java400-l@midrange.com'" <java400-l@midrange.com>
> > > >
> > > >                     >                        cc:
> > > >
> > > >                     Sent by:                 Subject:     RE:
> > > > AW: OF: what is websphere (locate Tomcat)
> > > >                     java400-l-admin@mi
> > > >                     drange.com
> > > >
> > > >
> > > >                     06/11/2002 03:14
> > > >                     PM
> > > >                     Please respond to
> > > >                     java400-l
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > It is there, but my Java code specifies the access by IP
> > > > address.  Do I
> > > > need
> > > > to change the Java code or WRKRDBDIRE?
> > > >
> > > > Joel R. Cochran
> > > > Director of Internet Services
> > > > VamaNet.com
> > > > (800)480-8810
> > > > mailto:webmaster@vamanet.com
> > > >
> > > > > -----Original Message-----
> > > > > From: MEovino@estes-express.com
> [mailto:MEovino@estes-express.com]
> > > > > Sent: Tuesday, June 11, 2002 2:56 PM
> > > > > To: java400-l@midrange.com
> > > > > Subject: RE: AW: OF: what is websphere (locate Tomcat)
> > > > >
> > > > >
> > > > >
> > > > > I'm jumping into this late and haven't read the whole thread,
> > > > > so forgive me
> > > > > if this doesn't have anything to do with your post.  But it
> > > > > looks like you
> > > > > need to check the Relational Database Directory entries.
> > > > >
> > > > > Enter WRKRDBDIRE from the command line.  You should at
> > > >
> > > > least see this:
> > > > >                Work with Relational Database Directory Entries
> > > > >
> > > > > Position to  . . . . . .
> > > > >
> > > > > Type options, press Enter.
> > > > >   1=Add   2=Change   4=Remove   5=Display details
> > >
> > > 6=Print details
> > >
> > > > >         Relational          Remote
> > > > > Option  Database            Location                  Text
> > > > >
> > > > >         YOURMACHINENAME     *LOCAL                    Entry
> > > > > added by system
> > > > >
> > > > > If you don't see that, add your local machine.  If you
> > >
> > > are trying to
> > >
> > > > > contact another 400, add an entry for that machine as well.
> > > > >
> > > > > Hope that helps.
> > > > >
> > > > > Mike E.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >                     "Joel R. Cochran"
> > > > >                     <jrc@masi-brac.com       To:
> > > > > "'java400-l@midrange.com'" <java400-l@midrange.com>
> > > > >
> > > > >                     >                        cc:
> > > > >
> > > > >                     Sent by:                 Subject:     RE:
> > > > > AW: OF: what is websphere (locate Tomcat)
> > > > >                     java400-l-admin@mi
> > > > >                     drange.com
> > > > >
> > > > >
> > > > >                     06/11/2002 02:39
> > > > >                     PM
> > > > >                     Please respond to
> > > > >                     java400-l
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > Thanks Dieter, I got that one fixed.  But now when I try to
> > > > > connect I get
> > > > > the message "Relational database xxx.xxx.xxx.xxx not in
> > > > > relational database
> > > > > directory."
> > > > >
> > > > > What the heck is the "relational database directory"?
> > > > >
> > > > > Joel R. Cochran
> > > > > Director of Internet Services
> > > > > VamaNet.com
> > > > > (800)480-8810
> > > > > mailto:webmaster@vamanet.com
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: Dieter.Bender@t-online.de
> > >
> > > [mailto:Dieter.Bender@t-online.de]
> > >
> > > > > > Sent: Tuesday, June 11, 2002 2:15 PM
> > > > > > To: java400-l@midrange.com
> > > > > > Subject: Re: AW: OF: what is websphere (locate Tomcat)
> > > > > >
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > > put the jt400.jar in the lib directory under tomcat
> directory
> > > > > > WEB-INF, as you
> > > > > > would do it in any other Tomcat installation
> > > > > >
> > > > > > Dieter
> > > > > >
> > > > > > Am Dienstag, 11. Juni 2002 18:14 schrieben Sie:
> > > > > > > I've gotten Tomcat installed and running as an Apache
> > > > > >
> > > > > > in-process server on
> > > > > >
> > > > > > > my 270.I have written my own servlet, compiled it, and
> > > > > >
> > > > > > moved it to my
> > > > > >
> > > > > > > WEB-INF directory.
> > > > > > >
> > > > > > > The page (which is found and does produce output) is
> > > > > >
> > > > > > supposed to connect to
> > > > > >
> > > > > > > the 400's database, but it cannot find the
> > > > > > > "com.ibm.as400.access.AS400JDBCDriver" class.  I'm sure
> > > > > >
> > > > > > this is a classpath
> > > > > >
> > > > > > > issue, but how do I set the classpath on the 400,
> > > > > >
> > > > > > preferably a one time
> > > > > >
> > > > > > > deal like setting environment variables in Win2000.  Also,
> > > > > >
> > > > > > does anyone know
> > > > > >
> > > > > > > where this little gem lives in the IFS?
> > > > > > >
> > > > > > > Thanks,
> > > > > > >
> > > > > > > Joel R. Cochran
> > > > > > > Director of Internet Services
> > > > > > > VamaNet.com
> > > > > > > (800)480-8810
> > > > > > > mailto:webmaster@vamanet.com
> > > > > > >
> > > > > > > _______________________________________________
> > > > > > > This is the Java Programming on and around the iSeries /
> > > > > >
> > > > > > AS400 (JAVA400-L)
> > > > > >
> > > > > > > mailing list To post a message email:
> JAVA400-L@midrange.com
> > > > > > > To subscribe, unsubscribe, or change list options,
> > > > > > > visit:
> http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > > > > > > or email: JAVA400-L-request@midrange.com
> > > > > > > Before posting, please take a moment to review
> the archives
> > > > > > > at http://archive.midrange.com/java400-l.
> > > > > >
> > > > > > --
> > > > > > mfG
> > > > > >
> > > > > > Dieter Bender
> > > > > >
> > > > > >
> > > > > > DV-Beratung Dieter Bender
> > > > > > Wetzlarerstr. 25
> > > > > > 35435 Wettenberg
> > > > > > Tel. +49 641 9805855
> > > > > > Fax +49 641 9805856
> > > > > > www.bender-dv.de
> > > > > >
> > > > > > _______________________________________________
> > > > > > This is the Java Programming on and around the iSeries /
> > > > > > AS400 (JAVA400-L) mailing list
> > > > > > To post a message email: JAVA400-L@midrange.com
> > > > > > To subscribe, unsubscribe, or change list options,
> > > > > > visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > > > > > or email: JAVA400-L-request@midrange.com
> > > > > > Before posting, please take a moment to review the archives
> > > > > > at http://archive.midrange.com/java400-l.
> > > > >
> > > > > _______________________________________________
> > > > > This is the Java Programming on and around the iSeries /
> > > > > AS400 (JAVA400-L)
> > > > > mailing list
> > > > > To post a message email: JAVA400-L@midrange.com
> > > > > To subscribe, unsubscribe, or change list options,
> > > > > visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > > > > or email: JAVA400-L-request@midrange.com
> > > > > Before posting, please take a moment to review the archives
> > > > > at http://archive.midrange.com/java400-l.
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > _______________________________________________
> > > > > This is the Java Programming on and around the iSeries /
> > > > > AS400 (JAVA400-L) mailing list
> > > > > To post a message email: JAVA400-L@midrange.com
> > > > > To subscribe, unsubscribe, or change list options,
> > > > > visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > > > > or email: JAVA400-L-request@midrange.com
> > > > > Before posting, please take a moment to review the archives
> > > > > at http://archive.midrange.com/java400-l.
> > > >
> > > > _______________________________________________
> > > > This is the Java Programming on and around the iSeries /
> > > > AS400 (JAVA400-L)
> > > > mailing list
> > > > To post a message email: JAVA400-L@midrange.com
> > > > To subscribe, unsubscribe, or change list options,
> > > > visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > > > or email: JAVA400-L-request@midrange.com
> > > > Before posting, please take a moment to review the archives
> > > > at http://archive.midrange.com/java400-l.
> > > >
> > > >
> > > >
> > > >
> > > > _______________________________________________
> > > > This is the Java Programming on and around the iSeries /
> > > > AS400 (JAVA400-L) mailing list
> > > > To post a message email: JAVA400-L@midrange.com
> > > > To subscribe, unsubscribe, or change list options,
> > > > visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > > > or email: JAVA400-L-request@midrange.com
> > > > Before posting, please take a moment to review the archives
> > > > at http://archive.midrange.com/java400-l.
> > >
> > > _______________________________________________
> > > This is the Java Programming on and around the iSeries /
> > > AS400 (JAVA400-L)
> > > mailing list
> > > To post a message email: JAVA400-L@midrange.com
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > > or email: JAVA400-L-request@midrange.com
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/java400-l.
> > >
> > >
> > >
> > >
> > > _______________________________________________
> > > This is the Java Programming on and around the iSeries /
> > > AS400 (JAVA400-L) mailing list
> > > To post a message email: JAVA400-L@midrange.com
> > > To subscribe, unsubscribe, or change list options,
> > > visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > > or email: JAVA400-L-request@midrange.com
> > > Before posting, please take a moment to review the archives
> > > at http://archive.midrange.com/java400-l.
> >
> > _______________________________________________
> > This is the Java Programming on and around the iSeries /
> AS400 (JAVA400-L)
> > mailing list To post a message email: JAVA400-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > or email: JAVA400-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/java400-l.
>
> --
> mfG
>
> Dieter Bender
>
>
> DV-Beratung Dieter Bender
> Wetzlarerstr. 25
> 35435 Wettenberg
> Tel. +49 641 9805855
> Fax +49 641 9805856
> www.bender-dv.de
>
> _______________________________________________
> This is the Java Programming on and around the iSeries /
> AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.