RE: JDBC Port issue AS400 toolbox JDBC driver URGENT

Sorry, I don't know if I can help.  The Toolbox JDBC driver uses "fixed"
ports.  That is, the driver always connects via port 8471 unless someone
edits the host port table on the AS/400 and restarts the host servers.  To
get the dynamic behavior you see someone would have to end the server, edit
the table, then restart the server between each connection.  I doubt if
that is happening.  The dynamic port you refer to must be for something
other than the connection between the Toolbox JDBC driver and the database
host server.

David Wall
AS/400 Toolbox for Java


"Annalur, Pavan" <Pavan.Annalur@aig.com>@midrange.com on 05/31/2001
01:54:24 PM

Please respond to JAVA400-L@midrange.com

Sent by:  owner-java400-l@midrange.com


To:   "'JAVA400-L@midrange.com'" <JAVA400-L@midrange.com>
cc:   "Horton, Al" <Al.Horton@aig.com>, "Gossett, Denise"
      <Denise.Gossett@aig.com>
Subject:  RE: JDBC Port issue AS400 toolbox JDBC driver URGENT





Thanks lot for your quick response, we went through the document before and
we had already opened port 8471 through firewall, however we had observed
that, it uses dynamic ports ( > 5010 ) for each SQL connection between our
Websphere server and database server

Is there any configuration / set up in JDBC driver files to use "static
port" instead of dynamic ports for SQL connections

Thanks for your quick response

Regards

Pavan/Atif

     -----Original Message-----
     From:   Dave Wall [mailto:dawall@us.ibm.com]
     Sent:   Thursday, May 31, 2001 1:36 PM
     To:     JAVA400-L@midrange.com
     Subject:        Re: JDBC Port issue AS400 toolbox JDBC driver URGENT

     A list of ports needed for each Toolbox service is listed at
     http://www-1.ibm.com/servers/eserver/iseries/toolbox/faqports.htm

     David Wall
     AS/400 Toolbox for Java

     "Annalur, Pavan" <Pavan.Annalur@aig.com>@midrange.com on 05/31/2001
     11:53:56 AM

     Please respond to JAVA400-L@midrange.com

     Sent by:  owner-java400-l@midrange.com

     To:   "'JAVA400-L@midrange.com'" <JAVA400-L@midrange.com>
     cc:
     Subject:  JDBC Port issue AS400 toolbox JDBC driver URGENT

     Hi,

             We are having some issue regarding the JBDC request from
     Websphere
     to As400 server. We have WebSphere App Server on one AS400 and DB2
     Datebase
     is on another AS400. WebSphere App server is in DMZ zone. There is
     Firewall
     between These two servers. We are successfully able to Signon to that
     Server through our application using AS400 Toolkit SignOn service. The
     Problem is we are not able to get the JDBC Connection and not able to
     Create the Connection pool for that database because of the Firewall.
     Can
     anybody tell WebSphere API uses which port to create the JDBC
     connection
     Pool. The Driver is AS400 Driver
     (com.ibm.as400.access.AS400JDBCDriver).

     Thanx in advance.

     I will be waiting for the Reply.

     Thanx,
     Pavan/Atif

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