Re: Loading JDBC Drivers onto the AS/400

1./ Yes, I ran the applet inside Netscape.
2/ The classes.zip declared in my autoexec.bat (window95) is being used by
browser.  The problem goes away when I remove the classes.zip from
autoexec.bat.



Thank you very much for your help.





dawall@us.ibm.com on 03/29/99 06:44:15 AM

To:   JAVA400-L@midrange.com
cc:    (bcc: Chanh Le/CLD/CF/CCI)
Subject:  Re: Loading JDBC Drivers onto the AS/400




The stack trace makes me think you are running an applet inside Netscape.
In this setup, the two common causes for this type of error are:

1.  Your default classpath includes "classes.zip" from a JDK (90% chance
this is the problem).  Do you have Java installed on this PC?  If yes, does
the PC's default classpath contain lib\classes.zip from the JDK?  This can
be a problem because the browser may be getting JDK classes from two
different places.  The browser comes with a JDK but if you have classes.zip
in your classpath, the browser sometimes gets classes from the PC's JVM,
not this one it ships with.  The two are rarely compatible so you will see
strange results.  Solution -- take classes.zip out of CLASSPATH.  As long
as the JDK is in your PATH (ie, ...\bin), you don't need classes.zip in
classpath.  The JDK automatically adds classes.zip to classpath so go ahead
and take it out.

2. No AS400 object available to AS400Text object (40% chance this is the
problem -- but, if number 1 is the problem, there is a 70% chance you will
hit this next).  The JVMs ship a set of ebcdic <--> unicode conversion
tables.  The Toolbox uses these tables for conversion where possible.  If a
table does not exist, the Toolbox gets the table off the AS/400, then does
the conversion.  The browsers do not ship any tables so the Toolbox always
has to get them from the AS/400.  To facilitate this, you must give the
AS400Text object an AS400 object.

I hope this helps.

David Wall
AS/400 Toolbox for Java

---------------------------------------------------------------------------
---------------

When I use following statement to connect to AS/400

     system.connectService(AS400.RECORDACCESS);

I got the following messages.  Is this the security violation ?  If it is
correct, can I get the information from "Java Network Security" red book?


java.lang.NoSuchFieldError: sun.io.ByteToCharSingleByte: field
byteToCharTable Ljava/lang/String; not found
  at sun.io.ByteToCharCp037.<init>(Compiled Code)
  at sun.io.ByteToCharConverter.getConverter(Compiled Code)
  at java.io.InputStreamReader.<init>(Compiled Code)
  at com.ibm.as400.access.ConvTable.<init>(Compiled Code)
  at com.ibm.as400.access.ConvTable.getTable(Compiled Code)
  at com.ibm.as400.access.Converter.<init>(Compiled Code)
  at com.ibm.as400.access.Converter.getConverter(Compiled Code)
  at com.ibm.as400.access.AS400.getSecurity400(Compiled Code)
  at com.ibm.as400.access.AS400.signOn(Compiled Code)
  at com.ibm.as400.access.AS400.connect(Compiled Code)
  at com.ibm.as400.access.AS400.connectService(Compiled Code)
  at Lfile$B1L.actionPerformed(Compiled Code)
  at java.awt.Button.processActionEvent(Compiled Code)
  at java.awt.Button.processEvent(Compiled Code)
  at java.awt.Component.dispatchEventImpl(Compiled Code)
* at java.awt.Component.dispatchEvent(Compiled Code)
  at java.awt.EventDispatchThread$EventPump.dispatchEvents(Compiled Code)
  at java.awt.EventDispatchThread.run(Compiled Code)
  at
netscape.applet.DerivedAppletFrame$AppletEventDispatchThread.run(Compiled
Code)








+---
| 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/operator:
david@midrange.com
+---




+---
| 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/operator: david@midrange.com
+---