Re: Controlling IP address used by JDBC

[Sarah Poger Gladstone <listmember@xxxxxxxxxxxxxx>]

Bill- The IP in the URL is the IP of the AS/400. That is not my issue.
My issue is the IP of the Unix client.

In theory I shouldn't care which IP address the Unix client uses to
connect to the AS/400. But the IT Security department has a firewall
between the 2 machines and therefore I need to ask them to create a
rule in the firewall to allow traffic between the 2 IP addresses. I
need to be able to tell them the correct source and destination IPs as
well as port number. I know the destination IP ( its the AS/400 IP)
and the port.  But the Unix machine has multiple IPs and I don't know
how to control which will be used.

Thanks,
Sarah


On Tue, Apr 7, 2009 at 6:16 PM, Blalock, Bill <Bill.Blalock@xxxxxxxx> wrote:
> Could the IP address be included the JDBC driver URL parameter?
>
> String connectURL = "jdbc:as400://" + ipAddress;
> Connection conn =
> DriverManager.getConnection(connectURL,userId,password);
>
> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of Sarah Poger
> Gladstone
> Sent: Tuesday, April 07, 2009 4:49 PM
> To: Java Programming on and around the iSeries / AS400
> Subject: Controlling IP address used by JDBC
>
> I have a small batch Java program that runs on a Unix server that
> connects to an AS/400 database using the jt400 JDBC driver.  The Unix
> server has multiple IP addresses configured.   How can I control which
> Unix IP address is used to connect to the AS/400?
>
> The Java code is using the Class.forName and
> DriverManager.getConnection methods to get a connection. JNDI data
> sources are not used.
>
> Thanks,
> Sarah
> --
> This is the Java Programming on and around the iSeries / AS400
> (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.
>
> _____________
>
> The information contained in this message is proprietary and/or confidential. If you are not the
> intended recipient, please: (i) delete the message and all copies; (ii) do not disclose,
> distribute or use the message in any manner; and (iii) notify the sender immediately. In addition,
> please be aware that any message addressed to our domain is subject to archiving and review by
> persons other than the intended recipient. Thank you.
> _____________
> --
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L) mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.