寻求DB2 iSeries/AS 400正确连接字符串，附数据库连接详情

Hey Dennis, glad to help you sort out this DB2 connection setup. Let's break down the correct configuration based on the details you provided:

First, fix up the JDBC URL #

The URL you shared is almost there—just a tiny adjustment needed. The trailing slash after your library name isn't required, and the host field shouldn't include the library path. Here's the corrected standard format for your connection:

jdbc:as400://eagle1.eaglegl.com/EAFEDPRDDF

Key Connection Details Clarified #

• Driver Class: The official JDBC driver class for DB2 iSeries is com.ibm.as400.access.AS400JDBCDriver
• Host: Only eagle1.eaglegl.com (the library EAFEDPRDDF is already specified in the URL, so it doesn't belong in the host field)
• Credentials: Use your provided username and password when initializing the connection

Sample Java Connection Code #

Here's a quick, runnable example to test your connection:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class AS400ConnectionTest {
    public static void main(String[] args) {
        String url = "jdbc:as400://eagle1.eaglegl.com/EAFEDPRDDF";
        String user = "your-username"; // Replace with your actual username
        String password = "your-password"; // Replace with your actual password
        
        try {
            // Load driver (optional in JDBC 4.0+)
            Class.forName("com.ibm.as400.access.AS400JDBCDriver");
            
            // Establish connection
            Connection conn = DriverManager.getConnection(url, user, password);
            System.out.println("Connection successful! 🎉");
            
            // Clean up
            conn.close();
        } catch (ClassNotFoundException e) {
            System.err.println("Driver missing: " + e.getMessage());
        } catch (SQLException e) {
            System.err.println("Connection failed: " + e.getMessage());
        }
    }
}

Quick Tips for Success #

• Ensure you have the IBM i Access JDBC Driver in your project's classpath—this is the official, supported driver for AS400/DB2 iSeries connections
• If you need extra configuration (like character encoding or transaction settings), append parameters to the URL, e.g.:

  jdbc:as400://eagle1.eaglegl.com/EAFEDPRDDF;translate binary=true;naming=system
  

• Verify your network allows access to the server on port 8471 (the default JDBC port for AS400)

内容的提问来源于stack exchange，提问作者Dennis