Re: Connecting to a remote database

Patrick,

I searched on the Web on the Exception and this is what I found.
http://www-4.ibm.com/software/webservers/appserv/doc/v35/ae/infocenter/was/0
40204020103.html

Now, I don't know the setup of the pool or the driver, so, can't figure out
if the problem was pool related or JDBC related.
Could you ping the AS/400 from the machine where you are doing the call?
Could you get a straight JDBC Connection (Driver.getConnection()) to the
AS/400 via the toolbox non-native JDBC driver you mentioned below?

Regards,
Bharath.

----- Original Message -----
From: "OSullivan, Patrick" <OSullivanP@bis.adp.com>
To: <java400-l@midrange.com>
Sent: Friday, November 09, 2001 6:01 PM
Subject: RE: Connecting to a remote database


> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
> --
> [ Picked text/plain from multipart/alternative ]
> Susan,
> Thanks for your reply.  We had already issued all of the steps below, but
> still nothing.
>
> Pat.
>
> -----Original Message-----
> From: Susan J Funk [mailto:funks@us.ibm.com]
> Sent: Friday, November 09, 2001 5:40 PM
> To: java400-l@midrange.com
> Subject: Re: Connecting to a remote database
>
>
>
> >From the Toolbox programmers' guide:
>
> "Running IBM Toolbox for Java in a client/server environment requires that
> you enable the QUSER user profile, start the host
> servers, and have TCP/IP running. Perform these actions from an iSeries
> command line by running the following commands:
>
>    1.Type DSPUSRPRF USRPRF(QUSER) and press ENTER to enable the QUSER user
> profile. The resulting display
>      shows the status for QUSER.
>    2.Type STRHOSTSVR and press ENTER to start the OS/400 host servers.
>    3.Type STRTCPSVR SERVER(*DDM) to start the TCP/IP server (with *DDM
> specified for the Server parameter)"
>
> Hope this helps,
>
> Susan Funk (funks@us.ibm.com)
>
>
>
>
>                     "Bharath V.S.
>                     Dhurjati"                To:
> <java400-l@midrange.com>
>                     <bharath@pswebwork       cc:
>                     s.com>                   Subject:     Re: Connecting
to
> a remote database
>                     Sent by:
>                     java400-l-admin@mi
>                     drange.com
>
>
>                     11/09/01 04:37 PM
>                     Please respond to
>                     java400-l
>
>
>
>
>
> We faced a similar problem with connecting from a Win2K m/c to AS/400
using
> the Toolbox JDBC.
>
> Our DB folks then "did something with RDBDIRE"  to fix it.
>
> Also they verified that "servers were running on the AS/400 to service
> incoming DB requests".
> (Something with QZDASRDSD?)
>
> Sorry to be so vague, but some one who knows what these mean on the AS/400
> can probably figure it out.
>
> HTH.
>
> Regards,
> Bharath.
>
> ----- Original Message -----
> From: "OSullivan, Patrick" <OSullivanP@bis.adp.com>
> To: <java400-l@midrange.com>
> Sent: Friday, November 09, 2001 4:43 PM
> Subject: RE: Connecting to a remote database
>
>
> > This message is in MIME format. Since your mail reader does not
> understand
> > this format, some or all of this message may not be legible.
> > --
> > [ Picked text/plain from multipart/alternative ]
> > Jim,
> > We are using java toolkit driver ....which is (
> > com.ibm.as400.access.AS400JDBCDriver)
> > the native driver is "com.ibm.db2.jdbc.app.DB2Driver"
> >
> > Thanks,
> > Pat.
> >
> > -----Original Message-----
> > From: Jim Mason [mailto:JEMason@compuserve.com]
> > Sent: Friday, November 09, 2001 4:13 PM
> > To: INTERNET:java400-l@midrange.com
> > Subject: Connecting to a remote database
> >
> >
> > Hi.
> >
> > Did you create a datasource definition using the iSeries Java toolbox
> > driver?  It supports remote access.  A datasource using the local DB2
> > driver on iSeries won't work....
> >
> > Jim Mason
> > _______________________________________________
> > This is the Java Programming on and around the iSeries / AS400
> (JAVA400-L)
> > mailing list
> > To post a message email: JAVA400-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > or email: JAVA400-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/java400-l.
> > _______________________________________________
> > This is the Java Programming on and around the iSeries / AS400
> (JAVA400-L)
> mailing list
> > To post a message email: JAVA400-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> > or email: JAVA400-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/java400-l.
> >
> >
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>
>
>
>
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
> _______________________________________________
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list
> To post a message email: JAVA400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/java400-l
> or email: JAVA400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
>