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
[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
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
[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
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
[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
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 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.
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
[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
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.
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
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.
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
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.
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.
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
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.
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.
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
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.