You should give datasource class name like ` org.postgresql.ds.PGSimpleDataSource` instead of Driver class.
Thanks, Satish. On Thu, Sep 8, 2016 at 3:45 PM, [email protected] < [email protected]> wrote: > 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 > > >
