RE: Servlets -- JAVA400-L


There is a little confusion here....

db2_classes.zip or db2_classes.jar are the locations of the code for the
Native JDBC driver.  Sorry about that name... I didn't get a choice.  The
.zip and .jar extension is for different releases - sorry again about it
moving around a little release to release...

However, having that in your classpath will not help with finding Toolbox
classses.  You need to have the Toolbox jar file in your classpath to use
the Toolbox JDBC driver (which you are trying to do as noted by the
com/ibm/as400/access/AS400JDBCDriver class load attempt - the native driver
would be trying to load the com/ibm/db2/jdbc/app/DB2Driver class).  I am
not able to suggest where that Toolbox jar file should be found as I do not
know release to release where it is placed.

If you were to use the native JDBC driver, you would need the
db2_classes.zip/.jar.  For Toolbox use, you need jt400.jar (perhaps it used
to be .zip)

Hope this clears up a little confusion.

Regards,

Richard D. Dettinger
AS/400 Java Data Access Team

"TRUE! nervous, very, very dreadfully nervous I had been and am; but why
WILL you say that I am mad?
The disease had sharpened my senses, not destroyed, not dulled them. "

- Edgar Allan Poe
"The Tell-Tale Heart"




Tom Heiber-Cobb <heibercobb@berbee.com> on 01/03/2000 09:32:51 AM

Please respond to JAVA400-L@midrange.com

To:   JAVA400-L@midrange.com
cc:
Subject:  RE: Servlets




Richard,
     Of course, I left out the most important one for database access. You
must
include the path to either the db2_classes.zip or db2_classes.jar which
might be found in:
/QIBM/ProdData/Java400/com/ibm/db2/jdbc/app/
or somewhere 'round there. I know it gets tiresome trying to satisfy all of
these classpath issues. Keep trying. I hope this one furthers the process
for you. Anyone else wanna comment?
Thanks,
     Tom H-C

At 09:34 AM 01/03/2000 -0500, you wrote:
>Thanks for the input Tom, I think you are right with the class path but I
>still can not figure out the problem.  Here is how I have my 'classpath'
>setup
>
> Value . . . . . . . . . :
>'.:/QIBM/ProdData/IBMWebAS/lib/ibmwebas.jar:/QIBM/P
>rodData/IBMWebAS/lib/jst.jar:/QIBM/ProdData/IBMWebAS/lib/jsdk.jar:/QIBM/Prod

>Data
>/IBMWebAS/lib/x509v1.jar:/QIBM/ProdData/IBMWebAS/lib:/QIBM/ProdData/IBMWebAS

>/lib
>/databeans.jar:/QIBM/ProdData/HTTP/Public/jt400/lib/jt400.jar'
>
>I am still getting this error when I run my program in STRQSH......
>
>java.lang.NoClassDefFoundError: com/ibm/as400/access/AS400JDBCDriver
>      JDBCQuery.query(Ljava/lang/String;)V+12 (JDBCQuery.java:22)
>      JDBCQuery.main([Ljava/lang/String;)V+1 (JDBCQuery.java:8)
>
>Any time I run any program in STRQSH that uses the AS/400 Toolbox for
Java,
>I get this error. If anyone has any suggestions on what I might be doing
>wrong.  Also my eventual goal is to get access to the toolbox for the
>servlets, so if anyone has any suggestion for setting up the classpath
>correctly for them I would appreciate that also.  I think I remember
seeing
>something at the http://myas400:9090 site that allowed me to change the
>classpath for the servlets???
>
>Again any help will be appreciated,
>Thanks,
>Richard Dean
>
>
>-----Original Message-----
>From: owner-java400-l@midrange.com
>[mailto:owner-java400-l@midrange.com]On Behalf Of Tom Heiber-Cobb
>Sent: Friday, December 31, 1999 12:16 PM
>To: JAVA400-L@midrange.com
>Subject: Re: Servlets
>
>
>Richard,
>    CLASSPATH, CLASSPATH, CLASSPATH. It's seems it's always classpath
"voodoo"
>when programs can't find import classes. Make sure the jsdk.jar is in your
>classpath when you compile servlets. jskd.jar is usually in the:
>/QIBM/ProdData/IBMWebAS/... etc. etc. directory somewhere. Also keep an
eye
>out for jst.jar and include this one too.
>    At least I think that's it. I'm sure some other readers will have some
>insight on this one. I hope this helps at all.
>HAPPY NEW YEAR TO ALL ON THE LIST!!
>    Tom H-C
>
>At 12:31 AM 12/31/1999 -0500, you wrote:
>>Well I seem to have WebSphere up and I can pull up the servlet examples
and
>>they run, including the servlets that access the database.  My next
>question
>>is how can I compile the my own "HeloWorld" servlet.  There is an example
>in
>>the setup instructions for "WebSphere 1.1" (which is what we have).  So,
I
>>created the sample HelloWorld servlet and set up my "classpath" using the
>>"ADDENVVAR" command like it said and then I tried to compile the servlet.
>>Of course it did not like the import of "javax.servlet.*" or
>>"javax.servlet.http.*", which I expected.  I was trying to compile this
on
>>the AS/400 in the Qshell.  I was able to compile a simple
>>"System.out.println" program and run it in Qshell and it worked.  So I
>guess
>>the question is do I need to install the "servlet" API on my AS/400
>somehow,
>>or do I need to import from some place other than "javax" (I tried to
>import
>>from "com.sun.java", but it did not work), or do I need to install the
>>"servlet" api on my PC somehow and compile the program there first and
then
>>copy the class to the as/400?
>>
>>I also noticed that all the example servlet sources that I could find on
>the
>>AS/400 had the "import jaxax......." in them, so I am real confused.
>>
>>Any help would be appreciated.  I am running V4R4M0 of the O/S, and
>>WebSphere 1.1.
>>
>>Thanks,
>>Richard Dean
>>
>>+---

+---
| 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
+---