<commit_before>![JDBC](https://github.com/jprante/elasticsearch-river-jdbc/raw/master/src/site/resources/database-128.png)

Image by [icons8](http://www.iconsdb.com/icons8/?icon=database) Creative Commons Attribution-NoDerivs 3.0 Unported.

[Follow me on twitter](https://twitter.com/xbib)

# JDBC plugin for Elasticsearch
![Travis](https://travis-ci.org/jprante/elasticsearch-river-jdbc.png)

The Java Database Connection (JDBC) plugin allows to fetch data from JDBC sources for
indexing into [Elasticsearch](http://www.elasticsearch.org).

It is implemented as an [Elasticsearch plugin](http://www.elasticsearch.org/guide/reference/modules/plugins.html).

The JDBC plugin was designed for tabular data. If you have tables with many joins, the JDBC plugin
is limited in the way to reconstruct deeply nested objects to JSON and process object semantics like object identity.
Though it would be possible to extend the JDBC plugin with a maaping feature where all the object properties
could be specified, the current solution is focused on rather simple tabular data streams.

# This plugin is future-proof

Note, JDBC plugin is not only a river, but also a standalone module. Because Elasicsearch river API is deprecated,
this is an important feature. It means JDBC plugin is future-proof. All future versions of Elasticsearch
will be supported.

## Recent versions

| Release date | Plugin version | Elasticsearch version |
| -------------| ---------------| ----------------------|
| Apr 21, 2015 | 1.5.0.5        | 1.5.0                 |
| Apr 21, 2015 | 1.4.4.5        | 1.4.4                 |
| Mar 24, 2015 | 1.5.0.0        | 1.5.0                 |
| Mar 24, 2015 | 1.4.4.0        | 1.4.4                 |
| Feb 19, 2015 | 1.4.0.10       | 1.4.0                 |
| Jan 25, 2015 | 1.4.0.9        | 1.4.0                 |
| Jan  2, 2015 | 1.4.0.8        | 1.4.0                 |
| Dec 30, 2014 | 1.4.0.7        | 1.4.0                 |
| Dec 23, 2014 | 1.4.0.6        | 1.4.0                 |
| Dec 23, 2014 | 1.3.4.7        | 1.3.4                 |
| Dec 23, 2014 | 1.2.4.5        | 1.2.4                 |
| Dec 23, 2014 | 1.1.2.4        | 1.1.2                 |
| Dec 23, 2014 | 1.0.3.4        | 1.0.3                 |
| Dec 20, 2014 | 1.4.0.5        | 1.4.0                 |
| Dec 20, 2014 | 1.3.4.6        | 1.3.4                 |
| Dec 20, 2014 | 1.2.4.4        | 1.2.4                 |
| Dec 20, 2014 | 1.1.2.3        | 1.1.2                 |
| Dec 20, 2014 | 1.0.3.3        | 1.0.3                 |
| Oct 19, 2014 | 1.4.0.3.Beta1  | 1.4.0.Beta1           |
| Oct 19, 2014 | 1.3.4.4        | 1.3.4                 |
| Oct 19, 2014 | 1.2.4.2        | 1.2.4                 |
| Oct 19, 2014 | 1.1.2.1        | 1.1.2                 |
| Oct 19, 2014 | 1.0.3.1        | 1.0.3                 |

## Prerequisites

- a JDBC driver jar for your database. You should download a driver from the vendor site. Put the jar into JDBC plugin folder.

## Installation

    ./bin/plugin --install jdbc --url http://xbib.org/repository/org/xbib/elasticsearch/plugin/elasticsearch-river-jdbc/1.5.0.5/elasticsearch-river-jdbc-1.5.0.5.zip
<commit_msg>fix the url in installation<commit_after>![JDBC](https://github.com/jprante/elasticsearch-river-jdbc/raw/master/src/site/resources/database-128.png)

Image by [icons8](http://www.iconsdb.com/icons8/?icon=database) Creative Commons Attribution-NoDerivs 3.0 Unported.

[Follow me on twitter](https://twitter.com/xbib)

# JDBC plugin for Elasticsearch
![Travis](https://travis-ci.org/jprante/elasticsearch-river-jdbc.png)

The Java Database Connection (JDBC) plugin allows to fetch data from JDBC sources for
indexing into [Elasticsearch](http://www.elasticsearch.org).

It is implemented as an [Elasticsearch plugin](http://www.elasticsearch.org/guide/reference/modules/plugins.html).

The JDBC plugin was designed for tabular data. If you have tables with many joins, the JDBC plugin
is limited in the way to reconstruct deeply nested objects to JSON and process object semantics like object identity.
Though it would be possible to extend the JDBC plugin with a maaping feature where all the object properties
could be specified, the current solution is focused on rather simple tabular data streams.

# This plugin is future-proof

Note, JDBC plugin is not only a river, but also a standalone module. Because Elasicsearch river API is deprecated,
this is an important feature. It means JDBC plugin is future-proof. All future versions of Elasticsearch
will be supported.

## Recent versions

| Release date | Plugin version | Elasticsearch version |
| -------------| ---------------| ----------------------|
| Apr 21, 2015 | 1.5.0.5        | 1.5.0                 |
| Apr 21, 2015 | 1.4.4.5        | 1.4.4                 |
| Mar 24, 2015 | 1.5.0.0        | 1.5.0                 |
| Mar 24, 2015 | 1.4.4.0        | 1.4.4                 |
| Feb 19, 2015 | 1.4.0.10       | 1.4.0                 |
| Jan 25, 2015 | 1.4.0.9        | 1.4.0                 |
| Jan  2, 2015 | 1.4.0.8        | 1.4.0                 |
| Dec 30, 2014 | 1.4.0.7        | 1.4.0                 |
| Dec 23, 2014 | 1.4.0.6        | 1.4.0                 |
| Dec 23, 2014 | 1.3.4.7        | 1.3.4                 |
| Dec 23, 2014 | 1.2.4.5        | 1.2.4                 |
| Dec 23, 2014 | 1.1.2.4        | 1.1.2                 |
| Dec 23, 2014 | 1.0.3.4        | 1.0.3                 |
| Dec 20, 2014 | 1.4.0.5        | 1.4.0                 |
| Dec 20, 2014 | 1.3.4.6        | 1.3.4                 |
| Dec 20, 2014 | 1.2.4.4        | 1.2.4                 |
| Dec 20, 2014 | 1.1.2.3        | 1.1.2                 |
| Dec 20, 2014 | 1.0.3.3        | 1.0.3                 |
| Oct 19, 2014 | 1.4.0.3.Beta1  | 1.4.0.Beta1           |
| Oct 19, 2014 | 1.3.4.4        | 1.3.4                 |
| Oct 19, 2014 | 1.2.4.2        | 1.2.4                 |
| Oct 19, 2014 | 1.1.2.1        | 1.1.2                 |
| Oct 19, 2014 | 1.0.3.1        | 1.0.3                 |

## Prerequisites

- a JDBC driver jar for your database. You should download a driver from the vendor site. Put the jar into JDBC plugin folder.

## Installation

    ./bin/plugin --install jdbc --url http://xbib.org/repository/org/xbib/elasticsearch/plugin/elasticsearch-river-jdbc/1.5.0.5/elasticsearch-river-jdbc-1.5.0.5-plugin.zip

{'fraction_non_alphanumeric': 0.13839356162221872, 'fraction_numerical': 0.09973173425911315, 'mean_word_length': 1.6125309150865623, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 6, 'lorem ipsum': 0, 'www.': 6, 'xml': 0}, 'pii_count': 50, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 2, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '695824', 'n_tokens_mistral': 2477, 'n_tokens_neox': 2070, 'n_words': 618}