Re: Controlling IP address used by JDBC

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.