Re: SQLException 9999:9999 getConnection - stack trace & complete program

To summarize what you said, (1) the app works inside the Borland
environment, and (2) the app works if you remove the JDBC stuff so all that
is left is the swing GUI.  The problem is when you try to connect outside
the Borland environment.  If  true then I agree that the AS/400 side is in
good shape.  The IBM JDK may be enough to get you going.

You can get IBM's 1.3 JVM at http://www.ibm.com/java.  Take the "developer
kits" link at the top of the page, then pick the JVM you want.

David Wall
AS/400 Toolbox for Java


"Steve Swett" <swett@bcswebsite.com>@midrange.com on 03/09/2001 09:13:33 AM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   <JAVA400-L@midrange.com>
cc:
Subject:  Re: SQLException 9999:9999 getConnection - stack trace & complete
      program



I've been able to run the application with JDBC from within the JBuilder
IDE
on more than one PC (just not able to run it from outside the IDE).  That
leads me to believe the AS/400 side is fine.  I've also been able to run it
successfully by taking out the JDBC stuff -- even outside the IDE.  And I
verified your other suggestions, except have questions:

How do I turn off the JIT?

Where can I get a copy of the IBM JDK 1.3?

Thanks.

Steve Swett
BCS, Inc.

-----Original Message-----
From: Dave Wall <dawall@us.ibm.com>
To: JAVA400-L@midrange.com <JAVA400-L@midrange.com>
Date: Friday, March 09, 2001 9:23 AM
Subject: Re: SQLException 9999:9999 getConnection - stack trace & complete
program


>
>The exception is thrown by Toolbox code trying to connect to the AS/400.
>Check the following to help figure out why the connection is failing:
>   Are the host servers started?
>   Is profile QUser enabled?
>   Is the connection between your client and the AS/400 good?  A good way
>   to test this is to run cwbping from a PC with CA/400, or get JPing from
>   JTOpen 2.02
>   Does turning the JIT off help?
>   If you cut out just the JDBC stuff and run it as a command line program
>   using either the SUN or IBM JDK, does it work?
>
>You are right that this is simple JDBC and it should work.  I did the last
>item.  I cut your JDBC logic and ran it as a stand alone program using
>IBM's JDK 1.3 and it worked for me.
>
>David Wall
>AS/400 Toolbox for Java
>


+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---