RE: Controlling IP address used by JDBC

As I look at the code in AS400ImplRemote.getConnection, it looks like the
socket is created with a call to the Socket constructor that does not allow
you to specify the local IP address. This may not be the method that JDBC
is going through but it seemed like it could be. If that is the case, it
seems like the only way to specify the Unix IP address to use would be to
modify the As400ImplRemote.getConnection method yourself.

If you could turn tracing on for your program, that could help pinpoint
exactly where the socket is getting created.

Gary

-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx

[mailto:java400-l-bounces@xxxxxxxxxxxx]

On Behalf Of Sarah Poger Gladstone
Sent: Tuesday, April 07, 2009 2: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