What ports does the AS/400 Toolbox JDBC driver ( com.ibm.as400.access.AS400JDBCDriver ) use? My application needs to use JDBC through a firewall.

Eric Kramer

Here's a wonderfully helpful document from IBM summarizing the ports used by the various Toolbox features (including JDBC):

Server Ports Used

From it, it appears that JDBC will require ports: 449, 8470, 8471, and 8476. If you're using SSL (which I'm going to guess you're not), there are different corresponding ports listed.

Also, we've had many headaches when there's a firewall between the two boxes. You'll want to configure your app server (if you're using one) for a minimum pool size of zero since if your connection(s) lay idle, the firewall may disconnect them ungracefully...