Re: Loading JDBC Drivers onto the AS/400

["Chanh Le" <Chanh_Le@xxxxxxxxxxxxxxx>]

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)






"Luther Ananda Miller" <LAM_SoftTel@usa.net> on 03/26/99 02:19:16 AM

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




More on this subject..
There is an excellent book called "Java Network Security" from IBM
redbooks.
Since we also wanted to access AS/400 data from an Applet but we wanted to
avoid these issues, we decided to implement data access on a middle layer
--
servlets on the AS/400. The applet connects back to the HTTP server using
HTTPS (SSL) on standard ports and communicates directly with a servlet,
passing our own data structures back and forth. The servlet takes care of
the data access on the applets behalf. The browser and server provide the
SSL support, and the Applet's footprint is small since it does not require
the toolbox classes. Additionally, there is no useful information about the
database built into the Applet's code, in case someone decided to
dissassemble it.

Luther
-----Original Message-----
From: dawall@us.ibm.com <dawall@us.ibm.com>
To: JAVA400-L@midrange.com <JAVA400-L@midrange.com>
Date: Friday, 26 March 1999 0:40
Subject: Re: Loading JDBC Drivers onto the AS/400


>Yes, the Toolbox will work in this type of environment.  There are three
>major considerations:
>
>1. Security -- by default data flows in the clear (passwords are always
>encrypted).  In v4r4 we added SSL support so we do have the option to
>encrypt data, but that is only when using v4r4 Toolbox to a v4r4 AS/400.
>
>2. Security -- we use sockets to get to the server so you must allow the
>sockets we use through your firewall.  We do not use the http/ftp ports,
we
>use use our own ports.  You can see/change the ports we use with AS/400
>command wrksrvtble.
>3. Size -- If you are thinking of doing an applet and if you are going to
>download the applet from the AS/400, the size of the toolbox is an
>important consideration.  Okay, I am being kind.  Today the Toolbox is too
>big to download over normal internet connections.  We are doing some
things
>to fix this problem.  For one, we have a utility called JarMaker.  You
give
>it the functions you want to use and it throws every thing else out of the
>jar file.  Even this doesn't go far enough in many cases so we are still
>working on this problem.  A couple alternatives today are using servlets
>instead of applets, and, if you own the client, you can ship the Toolbox
>jar to the client is it doesn't have to be downloaded every time.


+---
| This is the Midrange System 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
+---