Hi  user,

Recently I am doing a job using the storm-jdbc to insert into EDB.

I use the edb-jdbc16.jar.

I config for the ConnectionProvider like below:
        map.put("dataSourceClassName", "com.edb.Driver");
        map.put("dataSource.url", "jdbc:edb://localhost:5444/test");
        map.put("dataSource.user", "test");
        map.put("dataSource.password", "likeThe");

but when I run the topology, the jdbc-bolt throws an exception "java.lang.RuntimeException: java.lang.ClassCastException: Cannot cast com.edb.Driver to javax.sql.DataSource
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.<init>(PoolBase.java:84) ~[HikariCP-2.4.3.jar:?]
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:102) ~[HikariCP-2.4.3.jar:?]
at com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:71) ~[HikariCP-2.4.3.jar:?]"

I realized that the com.edb.Driver which implments java.sql.Driver may be is not a proper driver to use.

I googled, nothing useful found.

Can anyone give me some advice on how to insert into EDB by storm-jdbc?

Thanks very much.

Joshua
2016-09-08 18:06:56