Re: java........400 or java/400

[cujo@xxxxxxxxxx]

Sorry that no one responded to your question.  I was out last week or would
have before this.  The problem here is that you are using the "Native" JDBC
driver to attempt the connection.  The problem is that once you download
the applet into the browser, it is running on the PC (client, excuse me).
The native JDBC driver has no network layer built into it and therefore
can't connect from a non-AS/400 client to the AS/400 backend.  The native
JDBC driver is designed for optimized AS/400 direct database access
(although we might add further functionality in the future).  The following
lines are from your first note:

c = DriverManager.getConnection("jdbc:db2:*local");
to
c = DriverManager.getConnection("jdbc:db2:"SYSTEM_NAME");

What you want to use for your URL here is the "jdbc:as400:"SYSTEM_NAME".
The "jdbc:as400:..." URL will use the Toolbox JDBC driver to do the
connection.  The toolbox JDBC driver will use a socket connection to
connect directly to the AS/400 Host Servers (it is a type 4 - pure JDBC
driver).  This should fix your problem.


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"




Raghavendra Rao <raghavendra_rao@yahoo.com> on 03/16/2000 11:07:39 AM

Please respond to JAVA400-L@midrange.com

To:   JAVA400-L@midrange.com
cc:
Subject:  java........400 or java/400




Hello all,
oh, This is getting so irritating, we are on V4R4 and
all my pgms work like magic on the 400 qsh screen. why
cant it work on an applet, Are there any security
features in the browser itself which stop it from
connecting or is there something i've missed. Does
anyone have a sample java code for registering the
driver manager and connecting. Sorry for sounding so
irrtated, but its really driving me crazy.
Thanks in advance and thanks for the suggestions,
unfortunately didnt work,
Rao

__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.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: 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
+---