Daniel, Thanks for the info! -Roger
From: Danijel Schiavuzzi [mailto:[email protected]] Sent: Thursday, January 16, 2014 4:14 AM To: [email protected] Subject: Re: experiences w/ storm-rdbms I think it's a good starting point to modify or use as a template for writing a bolt for your RDBMS. However, if I remember correctly from when I was researching it, storm-rdbms had a bug -- it opened the JDBC connection in the bolt's constructor instead of the prepare() method, so in case the bolt gets reassigned to another Storm worker, things might not work correctly (because all Storm components, such as spouts or bolts, are distributed around the cluster in a serialized form). It's safer to setup the database connection in the prepare() method, which gets called by Storm whenever a new bolt instance is started on the cluster. If you need a way to access relational databases from the Trident API, take a look at storm-mysql or trident-mssql projects on Github. Best regards, Danijel Schiavuzzi www.schiavuzzi.com<http://www.schiavuzzi.com> On Wed, Jan 15, 2014 at 5:38 PM, Huang, Roger <[email protected]<mailto:[email protected]>> wrote: Anyone have any experiences (pro/con) or tips for using storm-rdbms? https://github.com/nathanmarz/storm-contrib/tree/master/storm-rdbms thanks, Roger -- Danijel Schiavuzzi
