private static Map<String,Object> hikariConfigMap = new HashMap<String, Object>(){{
put("dataSourceClassName", "com.ibm.db2.jdbc.app.DB2Driver");
put("dataSource.url", "jdbc:db2://10.10.83.81:50000/frms");
put("dataSource.user","umgra");
put("dataSource.password", "umgra");
}};
public static ConnectionProvider connectionProvider = new HikariCPConnectionProvider(hikariConfigMap);
这样报错，信息如下：
2017-05-22 16:56:29.833 o.a.s.d.executor [ERROR]
java.lang.RuntimeException: java.lang.ClassNotFoundException: com.ibm.db2.jdbc.app.DB2Driver
at com.zaxxer.hikari.util.UtilityElf.createInstance(UtilityElf.java:90) ~[HikariCP-2.4.3.jar:?]
at com.zaxxer.hikari.pool.PoolBase.initializeDataSource(PoolBase.java:292) ~[HikariCP-2.4.3.jar:?]
at com.zaxxer.hikari.pool.PoolBase.(PoolBase.java:84) ~[HikariCP-2.4.3.jar:?]
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:102) ~[HikariCP-2.4.3.jar:?]
at com.zaxxer.hikari.HikariDataSource.(HikariDataSource.java:71) ~[HikariCP-2.4.3.jar:?]
at org.apache.storm.jdbc.common.HikariCPConnectionProvider.prepare(HikariCPConnectionProvider.java:43) ~[storm-jdbc-1.0.2.jar:1.0.2]
at org.apache.storm.jdbc.bolt.AbstractJdbcBolt.prepare(AbstractJdbcBolt.java:46) ~[storm-jdbc-1.0.2.jar:1.0.2]
at org.apache.storm.daemon.executor$fn__8058$fn__8071.invoke(executor.clj:795) ~[storm-core-1.0.2.jar:1.0.2]
at org.apache.storm.util$async_loop$fn__624.invoke(util.clj:482) [storm-core-1.0.2.jar:1.0.2]
at clojure.lang.AFn.run(AFn.java:22) [clojure-1.7.0.jar:?]
at java.lang.Thread.run(Thread.java:745) [?:1.7.0_80]
java.lang.ClassNotFoundException: com.ibm.db2.jdbc.app.DB2Driver
驱动的jar包没找到
put("dataSourceClassName", "com.ibm.db2.jcc.DB2SimpleDataSource");
put("dataSource.serverName", "10.10.22.11");
put("dataSource.portNumber", "50000");
put("dataSource.databaseName", "test");
put("dataSource.currentSchema", "biz");
put("dataSource.user","uu");
put("dataSource.password", "mm");
put("dataSource.driverType", "4");
提示： Connection is not available, request timed out after 30002ms.
驱动用的：db2jcc.10.5
hikari用的：HikariCP-2.4.3.jar
难道Hikari不支持DB2吗