java - 无法从 Java 为 DB2 for IDAA 启用查询加速器

Question

我正在尝试使用普通 JDBC 方法从 Java 以查询加速器模式执行 SQL 查询。也就是说，创建一个连接DriverManager并执行查询。但它的投掷失败了com.ibm.db2.jcc.am.SqlSyntaxErrorException

我在 IBM 文档中为此设置了连接 U​​RL 中的特殊参数。

表已移至 IBM DB2 Analytics Accelerator (IDAA) 服务器，我能够从 AQT 工具（My DB 客户端工具）以加速模式执行查询，并且运行速度超快。

我使用了db2jcc4驱动程序Type4，连接 URL 和连接类如下所示：

public class ConnectionManager {

    private static final Logger LOGGER = LoggerFactory.getLogger(ConnectionManager.class);

    private static String url = "jdbc:db2://myIP:myPort/myDBName:specialRegisters=CURRENT QUERY ACCELERATION=ELIGIBLE";
    private static String driverName = "com.ibm.db2.jcc.DB2Driver";
    private static String username = "user";
    private static String password = "pwd";
    private static Connection con;
    private static String urlstring;

    public static Connection getConnection() throws SQLException, ClassNotFoundException {
        try {
            Class.forName(driverName);
            try {
                con = DriverManager.getConnection(url, username, password);
            } catch (SQLException ex) {
                // log an exception. fro example:
                System.out.println("Failed to create the database connection.");
                throw ex;
            }
        } catch (ClassNotFoundException ex) {
            // log an exception. for example:
            System.out.println("Driver not found.");
            throw ex;
        }
        return con;
    }
}

有什么我错过或做错了吗？

com.ibm.db2.jcc.am.SqlSyntaxErrorException: [jcc][10165][10051][4.24.92] Invalid database URL syntax: jdbc:db2://IP:Port/DBName:specialRegisters=CURRENT QUERY ACCELERATION=ELIGIBLE. ERRORCODE=-4461, SQLSTATE=42815
    at com.ibm.db2.jcc.am.b6.a(b6.java:810)
    at com.ibm.db2.jcc.am.b6.a(b6.java:66)
    at com.ibm.db2.jcc.am.b6.a(b6.java:98)
    at com.ibm.db2.jcc.DB2Driver.tokenizeURLProperties(DB2Driver.java:950)
    at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:413)
    at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:113)
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:247)
    at colruyt.spcpocxpsejb.util.ConnectionManager.getConnection(ConnectionManager.java:38)
    at colruyt.spcpocxpsejb.util.TestUtility.testAOT(TestUtility.java:98)
    at colruyt.spcpocxpsejb.util.TestUtility.main(TestUtility.java:25)
Caused by: java.util.NoSuchElementException
    at java.util.StringTokenizer.nextToken(StringTokenizer.java:349)
    at java.util.StringTokenizer.nextToken(StringTokenizer.java:377)
    at com.ibm.db2.jcc.DB2Driver.tokenizeURLProperties(DB2Driver.java:938)
    ... 7 more

标签： javajdbcdb2