# \[ANN\] JDBC river 1.0.0.1 released **URL:** \ **Category:** Elasticsearch\ **Created:** [February 13, 2014, 12:37am UTC](https://discuss.elastic.co/t/ann-jdbc-river-1-0-0-1-released/15768 "2014-02-13T00:37:13Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\ **Post date:** [February 13, 2014, 12:37am UTC](https://discuss.elastic.co/t/ann-jdbc-river-1-0-0-1-released/15768/1 "2014-02-13T00:37:13Z")
Hi, JDBC river plugin 1.0.0.1 for Elasticsearch 1.0.0 has been released. > **[jprante/elasticsearch-jdbc](https://github.com/jprante/elasticsearch-jdbc)** > > elasticsearch-jdbc - JDBC importer for Elasticsearch Changes: - compiled against Elasticsearch 1.0.0 - refactored some classes for preparing the move to a more robust data gathering plugin - improved JSON building when reading JSON out of a result column - possible to access river state (timestamp) as SQL parameter - reverted Collection to List in KeyValueStreamListener - some cleanups Best, Jörg -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFrCUx6xB%3D40UTu6BgL8fKaQDrQ57ANexr569tfKVgGSg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFrCUx6xB%3D40UTu6BgL8fKaQDrQ57ANexr569tfKVgGSg%40mail.gmail.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Tomislav\_Poljak](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tomislav_poljak/32/1177_2.png) [@Tomislav\_Poljak](https://discuss.elastic.co/u/Tomislav_Poljak)\ **Post date:** [February 16, 2014, 6:28pm UTC](https://discuss.elastic.co/t/ann-jdbc-river-1-0-0-1-released/15768/2 "2014-02-16T18:28:13Z")
Hi, I've tried new/latest jdbc river plugin for elasticsearch 1.0.0 (with the latest es v1.0.0) and simple river definition: curl -XPUT "[http://localhost:9200/\_river/table\_river/\_meta](http://localhost:9200/_river/table_river/_meta)" -d'{ "type" : "jdbc", "jdbc" : { "driver" : "com.mysql.jdbc.Driver", "url" : "jdbc:mysql://host/db", "user" : "x", "password" : "y", "sql" : "select \* from table" }, "index" : { "index" : "index\_name", "type" : "type\_name" } }' ended up importing data into index named 'jdbc' (instead 'index\_name') and type set in indexed docs was also 'jdbc' (instead of type\_name) Did something changed (completely) in how jdbc river is defined (I've checked the docs didn't find anything) or is this a bug? Tomislav 2014-02-13 1:37 GMT+01:00 [joergprante@gmail.com](mailto:joergprante@gmail.com) [joergprante@gmail.com](mailto:joergprante@gmail.com): > Hi, > > JDBC river plugin 1.0.0.1 for Elasticsearch 1.0.0 has been released. > > [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc) > > Changes: > > - compiled against Elasticsearch 1.0.0 > - refactored some classes for preparing the move to a more robust data > gathering plugin > - improved JSON building when reading JSON out of a result column > - possible to access river state (timestamp) as SQL parameter > - reverted Collection to List in KeyValueStreamListener > - some cleanups > > Best, > > Jörg > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFrCUx6xB%3D40UTu6BgL8fKaQDrQ57ANexr569tfKVgGSg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFrCUx6xB%3D40UTu6BgL8fKaQDrQ57ANexr569tfKVgGSg%40mail.gmail.com). > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CALuCJxgmZ%2BqWgNenAEuuo22R%2BhrXCHfXTzWyTL72Z4iwqZ962A%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CALuCJxgmZ%2BqWgNenAEuuo22R%2BhrXCHfXTzWyTL72Z4iwqZ962A%40mail.gmail.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\ **Post date:** [February 16, 2014, 6:41pm UTC](https://discuss.elastic.co/t/ann-jdbc-river-1-0-0-1-released/15768/3 "2014-02-16T18:41:22Z")
There is no index section any more. Try curl -XPUT "[http://localhost:9200/\_river/table\_river/\_meta](http://localhost:9200/_river/table_river/_meta)" -d'{ "type" : "jdbc", "jdbc" : { "url" : "jdbc:mysql://host/db", "user" : "x", "password" : "y", "sql" : "select \* from table", "index" : "index\_name", "type" : "type\_name" } }' Jörg On Sun, Feb 16, 2014 at 7:28 PM, Tomislav Poljak [tpoljak@gmail.com](mailto:tpoljak@gmail.com) wrote: > Hi, > I've tried new/latest jdbc river plugin for elasticsearch 1.0.0 (with > the latest es v1.0.0) and simple river definition: > > curl -XPUT "[http://localhost:9200/\_river/table\_river/\_meta](http://localhost:9200/_river/table_river/_meta)" -d'{ > "type" : "jdbc", > "jdbc" : { > "driver" : "com.mysql.jdbc.Driver", > "url" : "jdbc:mysql://host/db", > "user" : "x", > "password" : "y", > "sql" : "select \* from table" > }, > "index" : { > "index" : "index\_name", > "type" : "type\_name" > } > }' > > ended up importing data into index named 'jdbc' (instead 'index\_name') > and type set in indexed docs was also 'jdbc' (instead of type\_name) > > Did something changed (completely) in how jdbc river is defined (I've > checked the docs didn't find anything) or is this a bug? > > Tomislav > > 2014-02-13 1:37 GMT+01:00 [joergprante@gmail.com](mailto:joergprante@gmail.com) [joergprante@gmail.com](mailto:joergprante@gmail.com): > > > Hi, > > > > JDBC river plugin 1.0.0.1 for Elasticsearch 1.0.0 has been released. > > > > [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc) > > > > Changes: > > > > - compiled against Elasticsearch 1.0.0 > > - refactored some classes for preparing the move to a more robust data > > gathering plugin > > - improved JSON building when reading JSON out of a result column > > - possible to access river state (timestamp) as SQL parameter > > - reverted Collection to List in KeyValueStreamListener > > - some cleanups > > > > Best, > > > > Jörg > > > > -- > > You received this message because you are subscribed to the Google Groups > > "elasticsearch" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFrCUx6xB%3D40UTu6BgL8fKaQDrQ57ANexr569tfKVgGSg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFrCUx6xB%3D40UTu6BgL8fKaQDrQ57ANexr569tfKVgGSg%40mail.gmail.com) > . > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/CALuCJxgmZ%2BqWgNenAEuuo22R%2BhrXCHfXTzWyTL72Z4iwqZ962A%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CALuCJxgmZ%2BqWgNenAEuuo22R%2BhrXCHfXTzWyTL72Z4iwqZ962A%40mail.gmail.com) > . > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoHw%2Be5GLBR2sho0VJZva7w\_sTiY0Kvfe-w0UpqQ%2BMu6Qg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoHw%2Be5GLBR2sho0VJZva7w_sTiY0Kvfe-w0UpqQ%2BMu6Qg%40mail.gmail.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Tomislav\_Poljak](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tomislav_poljak/32/1177_2.png) [@Tomislav\_Poljak](https://discuss.elastic.co/u/Tomislav_Poljak)\ **Post date:** [February 17, 2014, 3:26pm UTC](https://discuss.elastic.co/t/ann-jdbc-river-1-0-0-1-released/15768/4 "2014-02-17T15:26:24Z")
Hi Jörg, seems I've missed docs update. Works correctly without the 'index' section, thanks! Tomislav 2014-02-16 19:41 GMT+01:00 [joergprante@gmail.com](mailto:joergprante@gmail.com) [joergprante@gmail.com](mailto:joergprante@gmail.com): > There is no index section any more. > > Try > > curl -XPUT "[http://localhost:9200/\_river/table\_river/\_meta](http://localhost:9200/_river/table_river/_meta)" -d'{ > "type" : "jdbc", > "jdbc" : { > "url" : "jdbc:mysql://host/db", > "user" : "x", > "password" : "y", > "sql" : "select \* from table", > "index" : "index\_name", > "type" : "type\_name" > } > }' > > Jörg > > On Sun, Feb 16, 2014 at 7:28 PM, Tomislav Poljak [tpoljak@gmail.com](mailto:tpoljak@gmail.com) wrote: > > > Hi, > > I've tried new/latest jdbc river plugin for elasticsearch 1.0.0 (with > > the latest es v1.0.0) and simple river definition: > > > > curl -XPUT "[http://localhost:9200/\_river/table\_river/\_meta](http://localhost:9200/_river/table_river/_meta)" -d'{ > > "type" : "jdbc", > > "jdbc" : { > > "driver" : "com.mysql.jdbc.Driver", > > "url" : "jdbc:mysql://host/db", > > "user" : "x", > > "password" : "y", > > "sql" : "select \* from table" > > }, > > "index" : { > > "index" : "index\_name", > > "type" : "type\_name" > > } > > }' > > > > ended up importing data into index named 'jdbc' (instead 'index\_name') > > and type set in indexed docs was also 'jdbc' (instead of type\_name) > > > > Did something changed (completely) in how jdbc river is defined (I've > > checked the docs didn't find anything) or is this a bug? > > > > Tomislav > > > > 2014-02-13 1:37 GMT+01:00 [joergprante@gmail.com](mailto:joergprante@gmail.com) [joergprante@gmail.com](mailto:joergprante@gmail.com): > > > > > Hi, > > > > > > JDBC river plugin 1.0.0.1 for Elasticsearch 1.0.0 has been released. > > > > > > [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc) > > > > > > Changes: > > > > > > - compiled against Elasticsearch 1.0.0 > > > - refactored some classes for preparing the move to a more robust data > > > gathering plugin > > > - improved JSON building when reading JSON out of a result column > > > - possible to access river state (timestamp) as SQL parameter > > > - reverted Collection to List in KeyValueStreamListener > > > - some cleanups > > > > > > Best, > > > > > > Jörg > > > > > > -- > > > You received this message because you are subscribed to the Google > > > Groups > > > "elasticsearch" group. > > > To unsubscribe from this group and stop receiving emails from it, send > > > an > > > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > > > To view this discussion on the web visit > > > > > > [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFrCUx6xB%3D40UTu6BgL8fKaQDrQ57ANexr569tfKVgGSg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFrCUx6xB%3D40UTu6BgL8fKaQDrQ57ANexr569tfKVgGSg%40mail.gmail.com). > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > > > -- > > You received this message because you are subscribed to the Google Groups > > "elasticsearch" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/CALuCJxgmZ%2BqWgNenAEuuo22R%2BhrXCHfXTzWyTL72Z4iwqZ962A%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CALuCJxgmZ%2BqWgNenAEuuo22R%2BhrXCHfXTzWyTL72Z4iwqZ962A%40mail.gmail.com). > > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). > To view this discussion on the web visit > [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoHw%2Be5GLBR2sho0VJZva7w\_sTiY0Kvfe-w0UpqQ%2BMu6Qg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoHw%2Be5GLBR2sho0VJZva7w_sTiY0Kvfe-w0UpqQ%2BMu6Qg%40mail.gmail.com). > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CALuCJxhe8M-Uym7m1%2BY\_a4i7dhD2tBJ%3D2cCcwsirTwcFUMv6SQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CALuCJxhe8M-Uym7m1%2BY_a4i7dhD2tBJ%3D2cCcwsirTwcFUMv6SQ%40mail.gmail.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![hari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hari/32/1582_2.png) [@hari](https://discuss.elastic.co/u/hari)\ **Post date:** [February 17, 2014, 4:16pm UTC](https://discuss.elastic.co/t/ann-jdbc-river-1-0-0-1-released/15768/5 "2014-02-17T16:16:49Z")
Jorg, how can I make this run hourly, I could not find an example in Quickstart. curl -XPUT "[http://localhost:9200/\_river/my\_jdbc\_river/\_meta](http://localhost:9200/_river/my_jdbc_river/_meta)" -d'{ "type" : "jdbc", "jdbc" : { "url" : "jdbc:oracle:thin:@192.168.0.108:1521:PROD", "user" : "wcs7dev", "password" : "wcs7dev", "sql" : "select \* from catentry", "index" : "catalog", "type" : "products" } }' On Sunday, February 16, 2014 12:41:22 PM UTC-6, Jörg Prante wrote: > There is no index section any more. > > Try > > curl -XPUT "[http://localhost:9200/\_river/table\_river/\_meta](http://localhost:9200/_river/table_river/_meta)" -d'{ > "type" : "jdbc", > "jdbc" : { > "url" : "jdbc:mysql://host/db", > "user" : "x", > "password" : "y", > "sql" : "select \* from table", > "index" : "index\_name", > "type" : "type\_name" > } > }' > > Jörg > > On Sun, Feb 16, 2014 at 7:28 PM, Tomislav Poljak \<[tpo...@gmail.com](mailto:tpo...@gmail.com)\ > > > wrote: > > > Hi, > > I've tried new/latest jdbc river plugin for elasticsearch 1.0.0 (with > > the latest es v1.0.0) and simple river definition: > > > > curl -XPUT "[http://localhost:9200/\_river/table\_river/\_meta](http://localhost:9200/_river/table_river/_meta)" -d'{ > > "type" : "jdbc", > > "jdbc" : { > > "driver" : "com.mysql.jdbc.Driver", > > "url" : "jdbc:mysql://host/db", > > "user" : "x", > > "password" : "y", > > "sql" : "select \* from table" > > }, > > "index" : { > > "index" : "index\_name", > > "type" : "type\_name" > > } > > }' > > > > ended up importing data into index named 'jdbc' (instead 'index\_name') > > and type set in indexed docs was also 'jdbc' (instead of type\_name) > > > > Did something changed (completely) in how jdbc river is defined (I've > > checked the docs didn't find anything) or is this a bug? > > > > Tomislav > > > > 2014-02-13 1:37 GMT+01:00 [joerg...@gmail.com](mailto:joerg...@gmail.com) \ \< > > [joerg...@gmail.com](mailto:joerg...@gmail.com) \\>: > > > > > Hi, > > > > > > JDBC river plugin 1.0.0.1 for Elasticsearch 1.0.0 has been released. > > > > > > [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc) > > > > > > Changes: > > > > > > - compiled against Elasticsearch 1.0.0 > > > - refactored some classes for preparing the move to a more robust data > > > gathering plugin > > > - improved JSON building when reading JSON out of a result column > > > - possible to access river state (timestamp) as SQL parameter > > > - reverted Collection to List in KeyValueStreamListener > > > - some cleanups > > > > > > Best, > > > > > > Jörg > > > > > > -- > > > You received this message because you are subscribed to the Google > > > Groups > > > "elasticsearch" group. > > > To unsubscribe from this group and stop receiving emails from it, send > > > an > > > email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > > To view this discussion on the web visit > > > > [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFrCUx6xB%3D40UTu6BgL8fKaQDrQ57ANexr569tfKVgGSg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFrCUx6xB%3D40UTu6BgL8fKaQDrQ57ANexr569tfKVgGSg%40mail.gmail.com) > > . > > > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > > > -- > > You received this message because you are subscribed to the Google Groups > > "elasticsearch" group. > > To unsubscribe from this group and stop receiving emails from it, send an > > email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com) \. > > To view this discussion on the web visit > > [https://groups.google.com/d/msgid/elasticsearch/CALuCJxgmZ%2BqWgNenAEuuo22R%2BhrXCHfXTzWyTL72Z4iwqZ962A%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CALuCJxgmZ%2BqWgNenAEuuo22R%2BhrXCHfXTzWyTL72Z4iwqZ962A%40mail.gmail.com) > > . > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/8f09e872-ba5e-464c-9dc2-24c57880f2e9%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/8f09e872-ba5e-464c-9dc2-24c57880f2e9%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![hari](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hari/32/1582_2.png) [@hari](https://discuss.elastic.co/u/hari)\ **Post date:** [February 17, 2014, 5:06pm UTC](https://discuss.elastic.co/t/ann-jdbc-river-1-0-0-1-released/15768/6 "2014-02-17T17:06:04Z")
Alright I figured it out. Adding something like this triggers it every 5 mins. "schedule":"0 0/5 \* \* \* ?" On Monday, February 17, 2014 10:16:49 AM UTC-6, Hariharan Vadivelu wrote: > Jorg, how can I make this run hourly, I could not find an example in > Quickstart. > > curl -XPUT "[http://localhost:9200/\_river/my\_jdbc\_river/\_meta](http://localhost:9200/_river/my_jdbc_river/_meta)" -d'{ > "type" : "jdbc", > "jdbc" : { > "url" : "jdbc:oracle:thin:@192.168.0.108:1521:PROD", > "user" : "wcs7dev", > "password" : "wcs7dev", > "sql" : "select \* from catentry", > "index" : "catalog", > "type" : "products" > } > }' > > On Sunday, February 16, 2014 12:41:22 PM UTC-6, Jörg Prante wrote: > > > There is no index section any more. > > > > Try > > > > curl -XPUT "[http://localhost:9200/\_river/table\_river/\_meta](http://localhost:9200/_river/table_river/_meta)" -d'{ > > "type" : "jdbc", > > "jdbc" : { > > "url" : "jdbc:mysql://host/db", > > "user" : "x", > > "password" : "y", > > "sql" : "select \* from table", > > "index" : "index\_name", > > "type" : "type\_name" > > } > > }' > > > > Jörg > > > > On Sun, Feb 16, 2014 at 7:28 PM, Tomislav Poljak [tpo...@gmail.com](mailto:tpo...@gmail.com)wrote: > > > > > Hi, > > > I've tried new/latest jdbc river plugin for elasticsearch 1.0.0 (with > > > the latest es v1.0.0) and simple river definition: > > > > > > curl -XPUT "[http://localhost:9200/\_river/table\_river/\_meta](http://localhost:9200/_river/table_river/_meta)" -d'{ > > > "type" : "jdbc", > > > "jdbc" : { > > > "driver" : "com.mysql.jdbc.Driver", > > > "url" : "jdbc:mysql://host/db", > > > "user" : "x", > > > "password" : "y", > > > "sql" : "select \* from table" > > > }, > > > "index" : { > > > "index" : "index\_name", > > > "type" : "type\_name" > > > } > > > }' > > > > > > ended up importing data into index named 'jdbc' (instead 'index\_name') > > > and type set in indexed docs was also 'jdbc' (instead of type\_name) > > > > > > Did something changed (completely) in how jdbc river is defined (I've > > > checked the docs didn't find anything) or is this a bug? > > > > > > Tomislav > > > > > > 2014-02-13 1:37 GMT+01:00 [joerg...@gmail.com](mailto:joerg...@gmail.com) [joerg...@gmail.com](mailto:joerg...@gmail.com): > > > > > > > Hi, > > > > > > > > JDBC river plugin 1.0.0.1 for Elasticsearch 1.0.0 has been released. > > > > > > > > [GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch](https://github.com/jprante/elasticsearch-river-jdbc) > > > > > > > > Changes: > > > > > > > > - compiled against Elasticsearch 1.0.0 > > > > - refactored some classes for preparing the move to a more robust data > > > > gathering plugin > > > > - improved JSON building when reading JSON out of a result column > > > > - possible to access river state (timestamp) as SQL parameter > > > > - reverted Collection to List in KeyValueStreamListener > > > > - some cleanups > > > > > > > > Best, > > > > > > > > Jörg > > > > > > > > -- > > > > You received this message because you are subscribed to the Google > > > > Groups > > > > "elasticsearch" group. > > > > To unsubscribe from this group and stop receiving emails from it, send > > > > an > > > > email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > > > To view this discussion on the web visit > > > > > > [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFrCUx6xB%3D40UTu6BgL8fKaQDrQ57ANexr569tfKVgGSg%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFrCUx6xB%3D40UTu6BgL8fKaQDrQ57ANexr569tfKVgGSg%40mail.gmail.com) > > > . > > > > > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). > > > > > > -- > > > You received this message because you are subscribed to the Google > > > Groups "elasticsearch" group. > > > To unsubscribe from this group and stop receiving emails from it, send > > > an email to [elasticsearc...@googlegroups.com](mailto:elasticsearc...@googlegroups.com). > > > To view this discussion on the web visit > > > [https://groups.google.com/d/msgid/elasticsearch/CALuCJxgmZ%2BqWgNenAEuuo22R%2BhrXCHfXTzWyTL72Z4iwqZ962A%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CALuCJxgmZ%2BqWgNenAEuuo22R%2BhrXCHfXTzWyTL72Z4iwqZ962A%40mail.gmail.com) > > > . > > > For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/1e7d525e-4c67-408d-af0d-6a0db127403d%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/1e7d525e-4c67-408d-af0d-6a0db127403d%40googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 1:49am UTC](https://discuss.elastic.co/t/ann-jdbc-river-1-0-0-1-released/15768/7 "2017-07-06T01:49:37Z")