Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id D6A2D200B7C for ; Thu, 8 Sep 2016 12:15:21 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id D5439160ABD; Thu, 8 Sep 2016 10:15:21 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 05350160AA5 for ; Thu, 8 Sep 2016 12:15:20 +0200 (CEST) Received: (qmail 37465 invoked by uid 500); 8 Sep 2016 10:15:19 -0000 Mailing-List: contact user-help@storm.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@storm.apache.org Delivered-To: mailing list user@storm.apache.org Received: (qmail 37455 invoked by uid 99); 8 Sep 2016 10:15:19 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Sep 2016 10:15:19 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 6AB241A12C8 for ; Thu, 8 Sep 2016 10:15:19 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 1.586 X-Spam-Level: * X-Spam-Status: No, score=1.586 tagged_above=-999 required=6.31 tests=[HTML_FONT_LOW_CONTRAST=0.001, HTML_MESSAGE=2, KAM_LAZY_DOMAIN_SECURITY=1, MIME_BASE64_TEXT=0.001, RP_MATCHES_RCVD=-1.426, T_KAM_HTML_FONT_INVALID=0.01] autolearn=disabled Received: from mx2-lw-us.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id MoUCBowh64LU for ; Thu, 8 Sep 2016 10:15:17 +0000 (UTC) Received: from smtpav.travelsky.com (smtpav.travelsky.com [124.42.13.57]) by mx2-lw-us.apache.org (ASF Mail Server at mx2-lw-us.apache.org) with ESMTPS id 13EE35FC37 for ; Thu, 8 Sep 2016 10:15:15 +0000 (UTC) Received: from [172.27.52.195] by smtpav.travelsky.com with SURFRONT ESMTP id 17557693033922; Thu, 8 Sep 2016 18:10:47 +0800 (CST) Date: Thu, 8 Sep 2016 18:15:01 +0800 From: "fanxinpu@travelsky.com" To: user Subject: how to insert into EDB by storm-jdbc X-Priority: 3 X-Has-Attach: no X-Mailer: Foxmail 7, 2, 7, 164[cn] Mime-Version: 1.0 Message-ID: <2016090818150159840587@travelsky.com> Content-Type: multipart/alternative; boundary="----=_001_NextPart686462801561_=----" archived-at: Thu, 08 Sep 2016 10:15:22 -0000 This is a multi-part message in MIME format. ------=_001_NextPart686462801561_=---- Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: base64 SGkgIHVzZXIsDQoNClJlY2VudGx5IEkgYW0gZG9pbmcgYSBqb2IgdXNpbmcgdGhlIHN0b3JtLWpk YmMgdG8gaW5zZXJ0IGludG8gRURCLg0KDQpJIHVzZSB0aGUgZWRiLWpkYmMxNi5qYXIuDQoNCkkg Y29uZmlnIGZvciB0aGUgQ29ubmVjdGlvblByb3ZpZGVyIGxpa2UgYmVsb3c6DQogICAgICAgIG1h cC5wdXQoImRhdGFTb3VyY2VDbGFzc05hbWUiLCAiY29tLmVkYi5Ecml2ZXIiKTsNCiAgICAgICAg bWFwLnB1dCgiZGF0YVNvdXJjZS51cmwiLCAiamRiYzplZGI6Ly9sb2NhbGhvc3Q6NTQ0NC90ZXN0 Iik7DQogICAgICAgIG1hcC5wdXQoImRhdGFTb3VyY2UudXNlciIsICJ0ZXN0Iik7DQogICAgICAg IG1hcC5wdXQoImRhdGFTb3VyY2UucGFzc3dvcmQiLCAibGlrZVRoZSIpOw0KDQpidXQgd2hlbiBJ IHJ1biB0aGUgdG9wb2xvZ3ksIHRoZSBqZGJjLWJvbHQgdGhyb3dzIGFuIGV4Y2VwdGlvbiAiamF2 YS5sYW5nLlJ1bnRpbWVFeGNlcHRpb246IGphdmEubGFuZy5DbGFzc0Nhc3RFeGNlcHRpb246IENh bm5vdCBjYXN0IGNvbS5lZGIuRHJpdmVyIHRvIGphdmF4LnNxbC5EYXRhU291cmNlDQphdCBjb20u emF4eGVyLmhpa2FyaS51dGlsLlV0aWxpdHlFbGYuY3JlYXRlSW5zdGFuY2UoVXRpbGl0eUVsZi5q YXZhOjkwKSB+W0hpa2FyaUNQLTIuNC4zLmphcjo/XQ0KYXQgY29tLnpheHhlci5oaWthcmkucG9v bC5Qb29sQmFzZS5pbml0aWFsaXplRGF0YVNvdXJjZShQb29sQmFzZS5qYXZhOjI5MikgfltIaWth cmlDUC0yLjQuMy5qYXI6P10NCmF0IGNvbS56YXh4ZXIuaGlrYXJpLnBvb2wuUG9vbEJhc2UuPGlu aXQ+KFBvb2xCYXNlLmphdmE6ODQpIH5bSGlrYXJpQ1AtMi40LjMuamFyOj9dDQphdCBjb20uemF4 eGVyLmhpa2FyaS5wb29sLkhpa2FyaVBvb2wuPGluaXQ+KEhpa2FyaVBvb2wuamF2YToxMDIpIH5b SGlrYXJpQ1AtMi40LjMuamFyOj9dDQphdCBjb20uemF4eGVyLmhpa2FyaS5IaWthcmlEYXRhU291 cmNlLjxpbml0PihIaWthcmlEYXRhU291cmNlLmphdmE6NzEpIH5bSGlrYXJpQ1AtMi40LjMuamFy Oj9dIg0KDQpJIHJlYWxpemVkIHRoYXQgdGhlIGNvbS5lZGIuRHJpdmVyIHdoaWNoIGltcGxtZW50 cyBqYXZhLnNxbC5Ecml2ZXIgbWF5IGJlIGlzIG5vdCBhIHByb3BlciBkcml2ZXIgdG8gdXNlLg0K DQpJIGdvb2dsZWQsIG5vdGhpbmcgdXNlZnVsIGZvdW5kLg0KDQpDYW4gYW55b25lIGdpdmUgbWUg c29tZSBhZHZpY2Ugb24gaG93IHRvIGluc2VydCBpbnRvIEVEQiBieSBzdG9ybS1qZGJjPw0KDQpU aGFua3MgdmVyeSBtdWNoLg0KDQoNCkpvc2h1YQ0KMjAxNi0wOS0wOCAxODowNjo1Ng0KDQoNCg== ------=_001_NextPart686462801561_=---- Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable <= body>
Hi  user,
=

Recently I am doing a job using the storm-jdbc to inser= t into EDB.

I use the edb-jdbc16.jar.

I config for= the ConnectionProvider like below:
       &nb= sp;map.put("dataSourceClassName", "com.edb.Driv= er");
   &nbs= p;    map.put("dataSource.url", "jdbc= :edb://localhost:5444/test");
        ma= p.put("dataSource.user", "test");
     &n= bsp;  map.put("dataSource.password", "likeThe");
=0A=

but when I run the topology, the jdbc-bolt throws an e= xception "java.lang.RuntimeException: java.lang.ClassC= astException: Cannot cast com.edb.Driver to javax= .sql.DataSource
at&nb= sp;com.zaxxer.hikari.util.UtilityElf.createInstance(UtilityElf.java:90)&nb= sp;~[HikariCP-2.4.3.jar:?]
at=  com.zaxxer.hikari.pool.PoolBase.initializeDataSource(PoolBase.java:2= 92) ~[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:10= 2) ~[HikariCP-2.4.3.jar:?]
at com.zaxxer.hikari.HikariDataSource.&l= t;init>(HikariDataSource.java:71) ~[HikariCP-2.4.3.jar:?]"<= /div>

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

I googled, nothing useful found.

Can anyon= e give me some advice on how to insert into EDB by storm-jdbc?
<= br>
Thanks very much.
=0A
=0A
Joshua
2016-09-08 18:06:56


=0A ------=_001_NextPart686462801561_=------