PostgreSQL integration

Sanx_El_Santo · July 4, 2012, 3:32pm

Greetings to all

Is there a process for setting up ElasticSearch to automatically index
data in PostgreSQL and make it search-able?

I am begining a project and I'm not quite sure where I have to start

anyone have any suggestions

Thanks for your attention

jprante · July 4, 2012, 5:37pm

You can try the JDBC river plugin

Best regards,

Jörg

On Wednesday, July 4, 2012 5:32:31 PM UTC+2, Sanx El Santo wrote:

Greetings to all

Is there a process for setting up Elasticsearch to automatically index
data in PostgreSQL and make it search-able?

I am begining a project and I'm not quite sure where I have to start

anyone have any suggestions

Thanks for your attention

DavidLR_2 · August 23, 2012, 7:58pm

I cannot get this going with postgresql 9.1, I only get the error "no
suitable driver found for postgresql.
I know nothing about java...
I downloaded the postgresql jdbc4 driver from here:
http://jdbc.postgresql.org/
extracted it and put the postgresql-9.1-902.jdbc.jar file in
/usr/share/elasticsearch/plugins/river_jdbc which is where the
elasticsearch-river-jdbc-1.3.2.jar file is.
My curl is

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"driver" : "org.postgresql.Driver",
"url" : "jdbc.postgresql://localhost:5432/test",
"username" : "username",
"password" : "password",
"sql" : "select * from everything"
},
"index" : {
"index" : "jdbc",
"type" : "jdbc"
}
}'

and I always get back this error

[ERROR][river.jdbc ] No suitable driver found for
postgresql://localhost:5432/nibbel
java.sql.SQLException: No suitable driver found for
postgresql://localhost:5432/test
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at
org.elasticsearch.river.jdbc.SQLService.getConnection(SQLService.java:103)
at
org.elasticsearch.river.jdbc.JDBCRiver$JDBCConnector.run(JDBCRiver.java:194)

Any ideas? Again I know nothing about java but was hoping to index and
search postgresql databases with elasticsearch.
Thanks

--

dadoonet · August 23, 2012, 8:00pm

Try to put postgresql jar in es lib dir. And restart ES.

--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 23 août 2012 à 21:58, DavidLR davidlreiff@gmail.com a écrit :

I cannot get this going with postgresql 9.1, I only get the error "no suitable driver found for postgresql.
I know nothing about java...
I downloaded the postgresql jdbc4 driver from here: http://jdbc.postgresql.org/
extracted it and put the postgresql-9.1-902.jdbc.jar file in /usr/share/elasticsearch/plugins/river_jdbc which is where the elasticsearch-river-jdbc-1.3.2.jar file is.
My curl is

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"driver" : "org.postgresql.Driver",
"url" : "jdbc.postgresql://localhost:5432/test",
"username" : "username",
"password" : "password",
"sql" : "select * from everything"
},
"index" : {
"index" : "jdbc",
"type" : "jdbc"
}
}'

and I always get back this error

[ERROR][river.jdbc ] No suitable driver found for postgresql://localhost:5432/nibbel
java.sql.SQLException: No suitable driver found for postgresql://localhost:5432/test
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.elasticsearch.river.jdbc.SQLService.getConnection(SQLService.java:103)
at org.elasticsearch.river.jdbc.JDBCRiver$JDBCConnector.run(JDBCRiver.java:194)

Any ideas? Again I know nothing about java but was hoping to index and search postgresql databases with elasticsearch.
Thanks

--

dadoonet · August 23, 2012, 8:03pm

And try with jdbc:postgresql://localhost:5432/test (not jdbc.postgresql)

--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 23 août 2012 à 22:00, David Pilato david@pilato.fr a écrit :

Try to put postgresql jar in es lib dir. And restart ES.

--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 23 août 2012 à 21:58, DavidLR davidlreiff@gmail.com a écrit :

I cannot get this going with postgresql 9.1, I only get the error "no suitable driver found for postgresql.
I know nothing about java...
I downloaded the postgresql jdbc4 driver from here: http://jdbc.postgresql.org/
extracted it and put the postgresql-9.1-902.jdbc.jar file in /usr/share/elasticsearch/plugins/river_jdbc which is where the elasticsearch-river-jdbc-1.3.2.jar file is.
My curl is

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"driver" : "org.postgresql.Driver",
"url" : "jdbc.postgresql://localhost:5432/test",
"username" : "username",
"password" : "password",
"sql" : "select * from everything"
},
"index" : {
"index" : "jdbc",
"type" : "jdbc"
}
}'

and I always get back this error

[ERROR][river.jdbc ] No suitable driver found for postgresql://localhost:5432/nibbel
java.sql.SQLException: No suitable driver found for postgresql://localhost:5432/test
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.elasticsearch.river.jdbc.SQLService.getConnection(SQLService.java:103)
at org.elasticsearch.river.jdbc.JDBCRiver$JDBCConnector.run(JDBCRiver.java:194)

Any ideas? Again I know nothing about java but was hoping to index and search postgresql databases with elasticsearch.
Thanks

--

DavidLR_2 · August 23, 2012, 10:44pm

Thanks but I already tried putting the postgresql jar in es/lib (in
addition to being in /plugins/river-jdbc) and I've tried several
combinations like
"jdbc: postgresql://localhost:5432/test"
"jdbc:postgresql:localhost/test"
"jdbc:postgresql:test"

for "driver" I tried
"com.postgresql.jdbc.Driver"
".postgresql.jdbc.Driver"
and realized, through error messages, that I need
"org.postgresql.jdbc.Driver"

Otherwise, I always get the same error.

Now I'm wondering if I'm starting es in a messed-up way. I've been using
'./bin/elasticsearch -f -Des.config=/etc/elasticsearch/elasticsearch.yml'
and maybe the file has paths wrong? I'll check more.

Thanks for the help

--

dadoonet · August 24, 2012, 1:49am

Here is what I can see from postgresql docs.

Driver class : org.postgresql.Driver
URL :
jdbc:postgresql:database
jdbc:postgresql://host/database
jdbc:postgresql://host:port/database

I hope this helps.

--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 24 août 2012 à 00:44, David Reiff davidlreiff@gmail.com a écrit :

Thanks but I already tried putting the postgresql jar in es/lib (in addition to being in /plugins/river-jdbc) and I've tried several combinations like
"jdbc: postgresql://localhost:5432/test"
"jdbc:postgresql:localhost/test"
"jdbc:postgresql:test"

for "driver" I tried
"com.postgresql.jdbc.Driver"
".postgresql.jdbc.Driver"
and realized, through error messages, that I need "org.postgresql.jdbc.Driver"

Otherwise, I always get the same error.

Now I'm wondering if I'm starting es in a messed-up way. I've been using
'./bin/elasticsearch -f -Des.config=/etc/elasticsearch/elasticsearch.yml'
and maybe the file has paths wrong? I'll check more.

Thanks for the help

--

Sourav_Gulati · August 24, 2012, 4:45am

Use ODBC driver instaed of JDBC. that will help
On Friday, August 24, 2012 1:28:13 AM UTC+5:30, DavidLR wrote:

I cannot get this going with postgresql 9.1, I only get the error "no
suitable driver found for postgresql.
I know nothing about java...
I downloaded the postgresql jdbc4 driver from here:
http://jdbc.postgresql.org/
extracted it and put the postgresql-9.1-902.jdbc.jar file in
/usr/share/elasticsearch/plugins/river_jdbc which is where the
elasticsearch-river-jdbc-1.3.2.jar file is.
My curl is

curl -XPUT 'localhost:9200/_river/my_jdbc_river/_meta' -d '{
"type" : "jdbc",
"jdbc" : {
"driver" : "org.postgresql.Driver",
"url" : "jdbc.postgresql://localhost:5432/test",
"username" : "username",
"password" : "password",
"sql" : "select * from everything"
},
"index" : {
"index" : "jdbc",
"type" : "jdbc"
}
}'

and I always get back this error

[ERROR][river.jdbc ] No suitable driver found for
postgresql://localhost:5432/nibbel
java.sql.SQLException: No suitable driver found for
postgresql://localhost:5432/test
at java.sql.DriverManager.getConnection(DriverManager.java:602)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at
org.elasticsearch.river.jdbc.SQLService.getConnection(SQLService.java:103)
at
org.elasticsearch.river.jdbc.JDBCRiver$JDBCConnector.run(JDBCRiver.java:194)

Any ideas? Again I know nothing about java but was hoping to index and
search postgresql databases with elasticsearch.
Thanks

--

DavidLR_2 · September 7, 2012, 2:20am

I'm really grateful for your help, David, but I still don't have it going.
I haven't had much time to work on it since my last post, but I'm beginning
to think that the postgres jdbc driver is not in the class path. Again, I
know nothing about java or class paths; I get this from google searches.
I'm open to any ideas about how to check my Elasticsearch class path and
how to add the postgresql jdbc driver to it, if that's needed. The examples
I've seen about setting class paths seem to apply if I were creating my own
java program.

Dave

On Thursday, August 23, 2012 8:49:12 PM UTC-5, David Pilato wrote:

Here is what I can see from postgresql docs.

Driver class : org.postgresql.Driver
URL :

jdbc:postgresql:database

jdbc:postgresql://host/database

jdbc:postgresql://host:port/database

I hope this helps.

--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 24 août 2012 à 00:44, David Reiff <david...@gmail.com <javascript:>> a
écrit :

Thanks but I already tried putting the postgresql jar in es/lib (in
addition to being in /plugins/river-jdbc) and I've tried several
combinations like
"jdbc: postgresql://localhost:5432/test"
"jdbc:postgresql:localhost/test"
"jdbc:postgresql:test"

for "driver" I tried
"com.postgresql.jdbc.Driver"
".postgresql.jdbc.Driver"
and realized, through error messages, that I need
"org.postgresql.jdbc.Driver"

Otherwise, I always get the same error.

Now I'm wondering if I'm starting es in a messed-up way. I've been using
'./bin/elasticsearch -f -Des.config=/etc/elasticsearch/elasticsearch.yml'
and maybe the file has paths wrong? I'll check more.

Thanks for the help

--

--

dadoonet · September 7, 2012, 5:42am

Could you "ls -l" your es lib dir ?

--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 7 sept. 2012 à 04:20, DavidLR davidlreiff@gmail.com a écrit :

I'm really grateful for your help, David, but I still don't have it going. I haven't had much time to work on it since my last post, but I'm beginning to think that the postgres jdbc driver is not in the class path. Again, I know nothing about java or class paths; I get this from google searches. I'm open to any ideas about how to check my Elasticsearch class path and how to add the postgresql jdbc driver to it, if that's needed. The examples I've seen about setting class paths seem to apply if I were creating my own java program.

Dave

On Thursday, August 23, 2012 8:49:12 PM UTC-5, David Pilato wrote:
Here is what I can see from postgresql docs.

Driver class : org.postgresql.Driver
URL :
jdbc:postgresql:database
jdbc:postgresql://host/database
jdbc:postgresql://host:port/database

I hope this helps.

--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 24 août 2012 à 00:44, David Reiff david...@gmail.com a écrit :

Thanks but I already tried putting the postgresql jar in es/lib (in addition to being in /plugins/river-jdbc) and I've tried several combinations like
"jdbc: postgresql://localhost:5432/test"
"jdbc:postgresql:localhost/test"
"jdbc:postgresql:test"

for "driver" I tried
"com.postgresql.jdbc.Driver"
".postgresql.jdbc.Driver"
and realized, through error messages, that I need "org.postgresql.jdbc.Driver"

Otherwise, I always get the same error.

Now I'm wondering if I'm starting es in a messed-up way. I've been using
'./bin/elasticsearch -f -Des.config=/etc/elasticsearch/elasticsearch.yml'
and maybe the file has paths wrong? I'll check more.

Thanks for the help

--

--

--

Ivan · September 7, 2012, 4:18pm

Are you using the service wrapper by any chance? Given your startup
command above, probably not.

--
Ivan

On Thu, Sep 6, 2012 at 7:20 PM, DavidLR davidlreiff@gmail.com wrote:

I'm really grateful for your help, David, but I still don't have it going. I
haven't had much time to work on it since my last post, but I'm beginning to
think that the postgres jdbc driver is not in the class path. Again, I know
nothing about java or class paths; I get this from google searches. I'm open
to any ideas about how to check my Elasticsearch class path and how to add
the postgresql jdbc driver to it, if that's needed. The examples I've seen
about setting class paths seem to apply if I were creating my own java
program.

Dave

On Thursday, August 23, 2012 8:49:12 PM UTC-5, David Pilato wrote:

Here is what I can see from postgresql docs.

Driver class : org.postgresql.Driver
URL :

jdbc:postgresql:database

jdbc:postgresql://host/database

jdbc:postgresql://host:port/database

I hope this helps.

--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 24 août 2012 à 00:44, David Reiff david...@gmail.com a écrit :

Thanks but I already tried putting the postgresql jar in es/lib (in
addition to being in /plugins/river-jdbc) and I've tried several
combinations like
"jdbc: postgresql://localhost:5432/test"
"jdbc:postgresql:localhost/test"
"jdbc:postgresql:test"

for "driver" I tried
"com.postgresql.jdbc.Driver"
".postgresql.jdbc.Driver"
and realized, through error messages, that I need
"org.postgresql.jdbc.Driver"

Otherwise, I always get the same error.

Now I'm wondering if I'm starting es in a messed-up way. I've been using
'./bin/elasticsearch -f -Des.config=/etc/elasticsearch/elasticsearch.yml'
and maybe the file has paths wrong? I'll check more.

Thanks for the help

--

--

--

DavidLR_2 · September 7, 2012, 8:04pm

Sure -

dave@dave-desktop:~$ ls -l /usr/share/elasticsearch/lib
total 14952
-rw-r--r-- 1 root root 9998142 2012-07-02 15:04 elasticsearch-0.19.8.jar
-rw-r--r-- 1 root root 865400 2012-07-02 15:04 jna-3.3.0.jar
-rw-r--r-- 1 root root 481535 2012-07-02 15:04 log4j-1.2.16.jar
-rw-r--r-- 1 root root 1172498 2012-07-02 15:04 lucene-analyzers-3.6.0.jar
-rw-r--r-- 1 root root 1535258 2012-07-02 15:04 lucene-core-3.6.0.jar
-rw-r--r-- 1 root root 89201 2012-07-02 15:04 lucene-highlighter-3.6.0.jar
-rw-r--r-- 1 root root 29814 2012-07-02 15:04 lucene-memory-3.6.0.jar
-rw-r--r-- 1 root root 47407 2012-07-02 15:04 lucene-queries-3.6.0.jar
-rw-rw-r-- 1 dave dave 507454 2012-08-23 13:34 postgresql-9.1-902.jdbc3.jar
-rw-rw-r-- 1 dave dave 561969 2012-08-17 10:58 postgresql-9.1-902.jdbc4.jar
drwxr-xr-x 2 root root 4096 2012-08-22 09:14 sigar

I added the jdbc3.jar in case it might help, but, no help.

On Fri, Sep 7, 2012 at 12:42 AM, David Pilato david@pilato.fr wrote:

Could you "ls -l" your es lib dir ?

--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 7 sept. 2012 à 04:20, DavidLR davidlreiff@gmail.com a écrit :

--

DavidLR_2 · September 7, 2012, 8:08pm

No, I'm not. I was hoping to just get a simple database table indexed to
get started, then move on to learning more, but I can't get any indexing
going. For now I'm starting it with ./bin/elasticsearch -f
-Des.config=/etc/elasticsearch/elasticsearch.yml

Thanks Dave

On Fri, Sep 7, 2012 at 11:18 AM, Ivan Brusic ivan@brusic.com wrote:

Are you using the service wrapper by any chance? Given your startup
command above, probably not.

--
Ivan

On Thu, Sep 6, 2012 at 7:20 PM, DavidLR davidlreiff@gmail.com wrote:

I'm really grateful for your help, David, but I still don't have it
going. I
haven't had much time to work on it since my last post, but I'm
beginning to
think that the postgres jdbc driver is not in the class path. Again, I
know
nothing about java or class paths; I get this from google searches. I'm
open
to any ideas about how to check my Elasticsearch class path and how to
add
the postgresql jdbc driver to it, if that's needed. The examples I've
seen
about setting class paths seem to apply if I were creating my own java
program.

Dave

On Thursday, August 23, 2012 8:49:12 PM UTC-5, David Pilato wrote:

Here is what I can see from postgresql docs.

Driver class : org.postgresql.Driver
URL :

jdbc:postgresql:database

jdbc:postgresql://host/database

jdbc:postgresql://host:port/database

I hope this helps.

--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 24 août 2012 à 00:44, David Reiff david...@gmail.com a écrit :

Thanks but I already tried putting the postgresql jar in es/lib (in
addition to being in /plugins/river-jdbc) and I've tried several
combinations like
"jdbc: postgresql://localhost:5432/test"
"jdbc:postgresql:localhost/test"
"jdbc:postgresql:test"

for "driver" I tried
"com.postgresql.jdbc.Driver"
".postgresql.jdbc.Driver"
and realized, through error messages, that I need
"org.postgresql.jdbc.Driver"

Otherwise, I always get the same error.

Now I'm wondering if I'm starting es in a messed-up way. I've been using
'./bin/elasticsearch -f
-Des.config=/etc/elasticsearch/elasticsearch.yml'
and maybe the file has paths wrong? I'll check more.

Thanks for the help

--

--

--

--

dadoonet · September 7, 2012, 8:32pm

Hmmm.

Adding jdbc3 won't help. Remove it.

I misread Jörg Prante readme. You have to put your jar in plugins/river-jdbc
directory.
Sorry.

See here: Quickstart · jprante/elasticsearch-jdbc Wiki · GitHub

HTH
David

Le 7 septembre 2012 à 22:04, David Reiff davidlreiff@gmail.com a écrit :

Sure -

dave@dave-desktop:~$ ls -l /usr/share/elasticsearch/lib
total 14952
-rw-r--r-- 1 root root 9998142 2012-07-02 15:04 elasticsearch-0.19.8.jar
-rw-r--r-- 1 root root 865400 2012-07-02 15:04 jna-3.3.0.jar
-rw-r--r-- 1 root root 481535 2012-07-02 15:04 log4j-1.2.16.jar
-rw-r--r-- 1 root root 1172498 2012-07-02 15:04 lucene-analyzers-3.6.0.jar
-rw-r--r-- 1 root root 1535258 2012-07-02 15:04 lucene-core-3.6.0.jar
-rw-r--r-- 1 root root 89201 2012-07-02 15:04 lucene-highlighter-3.6.0.jar
-rw-r--r-- 1 root root 29814 2012-07-02 15:04 lucene-memory-3.6.0.jar
-rw-r--r-- 1 root root 47407 2012-07-02 15:04 lucene-queries-3.6.0.jar
-rw-rw-r-- 1 dave dave 507454 2012-08-23 13:34 postgresql-9.1-902.jdbc3.jar
-rw-rw-r-- 1 dave dave 561969 2012-08-17 10:58 postgresql-9.1-902.jdbc4.jar
drwxr-xr-x 2 root root 4096 2012-08-22 09:14 sigar

I added the jdbc3.jar in case it might help, but, no help.

On Fri, Sep 7, 2012 at 12:42 AM, David Pilato <david@pilato.fr
mailto:david@pilato.fr > wrote:

Could you "ls -l" your es lib dir ?

--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 7 sept. 2012 à 04:20, DavidLR < davidlreiff@gmail.com
mailto:davidlreiff@gmail.com > a écrit :

--

--
David Pilato
http://www.scrutmydocs.org/
http://dev.david.pilato.fr/
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

--

DavidLR_2 · September 7, 2012, 9:55pm

Well, I hate to drive you crazy but I've tried with only the jdbc4 driver
in the /plugins/river-jdbc directory; with only the jdbc4 driver in both
the /lib and the /plugins/river-jdbc directories, with only the jdbc4
driver in the /lib directory, and with both the jdbc4 driver and the jdbc3
driver in the /lib directory (as shown in my previous post).

A reply to a similar question here

says that this error has two causes:

The JDBC driver is not loaded at all.
URL does not match any of the loaded JDBC drivers.

If this is the right path for me to follow, maybe somehow my jdbc driver is
not being loaded at all??

On Fri, Sep 7, 2012 at 3:32 PM, David Pilato david@pilato.fr wrote:

**

Hmmm.

Adding jdbc3 won't help. Remove it.

I misread Jörg Prante readme. You have to put your jar in plugins/river-jdbc
directory.

Sorry.

See here:
Quickstart · jprante/elasticsearch-jdbc Wiki · GitHub

HTH

David

Le 7 septembre 2012 à 22:04, David Reiff davidlreiff@gmail.com a
écrit :

Sure -

dave@dave-desktop:~$ ls -l /usr/share/elasticsearch/lib
total 14952
-rw-r--r-- 1 root root 9998142 2012-07-02 15:04 elasticsearch-0.19.8.jar
-rw-r--r-- 1 root root 865400 2012-07-02 15:04 jna-3.3.0.jar
-rw-r--r-- 1 root root 481535 2012-07-02 15:04 log4j-1.2.16.jar
-rw-r--r-- 1 root root 1172498 2012-07-02 15:04 lucene-analyzers-3.6.0.jar
-rw-r--r-- 1 root root 1535258 2012-07-02 15:04 lucene-core-3.6.0.jar
-rw-r--r-- 1 root root 89201 2012-07-02 15:04
lucene-highlighter-3.6.0.jar
-rw-r--r-- 1 root root 29814 2012-07-02 15:04 lucene-memory-3.6.0.jar
-rw-r--r-- 1 root root 47407 2012-07-02 15:04 lucene-queries-3.6.0.jar
-rw-rw-r-- 1 dave dave 507454 2012-08-23 13:34
postgresql-9.1-902.jdbc3.jar
-rw-rw-r-- 1 dave dave 561969 2012-08-17 10:58
postgresql-9.1-902.jdbc4.jar
drwxr-xr-x 2 root root 4096 2012-08-22 09:14 sigar

I added the jdbc3.jar in case it might help, but, no help.

On Fri, Sep 7, 2012 at 12:42 AM, David Pilato david@pilato.fr wrote:

Could you "ls -l" your es lib dir ?

--
David
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

Le 7 sept. 2012 à 04:20, DavidLR < davidlreiff@gmail.com> a écrit :

--

--
David Pilato
http://www.scrutmydocs.org/
http://dev.david.pilato.fr/

Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs

--

--

DavidLR_2 · September 8, 2012, 1:54am

Anyone who knows java, could this be related to my problem?

This person says there's a bug in Mule 3.1.2. Could this be an issue for me
also? If so, what do I do?
I'm lost with any java-related stuff.

--

jprante · September 8, 2012, 9:11pm

Hi,

I did a write-up here how to use JDBC river and PostgreSQL 9.1, in the hope
it helps.

Best regards,

Jörg

On Saturday, September 8, 2012 3:54:46 AM UTC+2, DavidLR wrote:

Anyone who knows java, could this be related to my problem?

No Suitable Driver found for JDBC-Postgresql - Stack Overflow

This person says there's a bug in Mule 3.1.2. Could this be an issue for
me also? If so, what do I do?
I'm lost with any java-related stuff.

--

DavidLR_2 · September 12, 2012, 2:35pm

I got it going! I had a space in my url, like this:

"url" : "jdbc: postgresql://localhost:5432/nibbel",

which should be

"url" : "jdbc:postgresql://localhost:5432/nibbel",

(no space after jdbc:) That little space caused the "no suitable driver
found" error to come up.

Also had to edit pg_hba.conf to allow access to the database.

I can't work on this every day so it took a while. Thanks, David, for quick
replies and thanks Jorge for working out the procedure for Postgresql.

On Saturday, September 8, 2012 4:11:10 PM UTC-5, Jörg Prante wrote:

Hi,

I did a write-up here how to use JDBC river and PostgreSQL 9.1, in the
hope it helps.

Create new page · jprante/elasticsearch-jdbc Wiki · GitHub

Best regards,

Jörg

On Saturday, September 8, 2012 3:54:46 AM UTC+2, DavidLR wrote:

Anyone who knows java, could this be related to my problem?

No Suitable Driver found for JDBC-Postgresql - Stack Overflow

This person says there's a bug in Mule 3.1.2. Could this be an issue for
me also? If so, what do I do?
I'm lost with any java-related stuff.

--

chaithanya · July 31, 2014, 5:42pm

HI can any one help me out how to generate reports using postgresql in ELK,in elastic search i configured jdbc jar files and its working fine later wat step i have to do in logslash and ui kebina..please help me out

Topic		Replies	Views
[Ann] JDBC River Plugin for ElasticSearch Elasticsearch	20	2693	July 6, 2017
How to connect PostgreSQL Database using elastic Search? Elasticsearch	6	3233	July 5, 2017
Plz help me! very urgent Elasticsearch	42	825	July 6, 2017
How to index postgresql database Elasticsearch	3	1546	July 5, 2017
Elasticsearch river for postgres Elasticsearch	10	600	July 6, 2017

PostgreSQL integration

Related topics