• Subject: Re: java........400 or java/400
  • From: dawall@xxxxxxxxxx
  • Date: Tue, 21 Mar 2000 08:07:41 -0600

Try
     c = DriverManager.getConnection("jdbc:as400://SYS_NAME");

where SYS_NAME is the real name of your AS/400.  If getConnection fails,
you will get an exception with the reason for the failure.  Hope this
helps,

David Wall
AS/400 Toolbox for Java


Raghavendra Rao <raghavendra_rao@yahoo.com> on 03/21/2000 04:59:04 AM

Please respond to JAVA400-L@midrange.com

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




Hello Richard,
Gracias, merci', thanks a lot !!!! just one more small
detail, when i do this
 Lst.addItem("Trying to  register now ....");

Class.forName("com.ibm.as400.access.AS400JDBCDriver");
 Lst.addItem("I'm trying to  connect now ....");
 c =
DriverManager.getConnection("jdbc:as400:SYS_NAME");

 lst.addItem(" connected ...."   );
 It doesnt connect, I'm using IE4, that got anything
to do with it !!
Thanks again,
Rao

--- cujo@us.ibm.com wrote:
> 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
> +---
>

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.