River-jdbc Error java.lang.NullPointerException

Hi All,

I have set up ElasticSearch 1.4.2 and river-jdbc from jprante. I was able
to add a river using sense

put _river/users/_meta
{
"type":"jdbc",
"jdbc": {

"url":"jdbc:sqlserver://My.SQLSever.mydomain.com:1433;databaseName=webrepos;integratedSecurity=true;","sql":"SELECT

  • FROM [Webrepos].[dbo].[User]"
    }
    }

This takes but then in the logs I'm getting this:

2015-01-02 11:17:04,829][INFO ][river.jdbc.RiverMetrics ] pipeline
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline@730a6f3 complete: river
jdbc/users metrics: 0 rows, 0.0 mean, (0.0 0.0 0.0), ingest metrics:
elapsed 0 seconds, 0.0 bytes bytes, 0.0 bytes avg, 0 MB/s
[2015-01-02 11:17:04,808][ERROR][river.jdbc.RiverPipeline ]
java.lang.NullPointerException
java.io.IOException: java.lang.NullPointerException
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.fetch(SimpleRiverSource.java:341)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.fetch(SimpleRiverFlow.java:220)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.execute(SimpleRiverFlow.java:149)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.request(RiverPipeline.java:88)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.java:66)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.java:30)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:514)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.getConnectionForReading(SimpleRiverSource.java:212)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.execute(SimpleRiverSource.java:376)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.fetch(SimpleRiverSource.java:320)
... 9 more

I am using integrated security and the Service is running as an account
that has access to the DB as well as the elasticsearch folders. We have
other services on the same machine that use the same account and am not
getting Connection refused errors.

Any ideas?

It doesn't appear that it is getting any actual data from the database.
Not sure how to check that other than a search query which is returning no
results.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/b217c635-915f-4030-9d2d-3fa50419d266%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Thanks for report, I have opened an issue for that

Do you connect without a user name to JDBC? The error is caused because you
did not pass a user name as parameter.

Jörg

On Fri, Jan 2, 2015 at 7:05 PM, Garrett Johnson garrettcjohnson@gmail.com
wrote:

Hi All,

I have set up ElasticSearch 1.4.2 and river-jdbc from jprante. I was able
to add a river using sense

put _river/users/_meta
{
"type":"jdbc",
"jdbc": {
"url":"jdbc:sqlserver://My.SQLSever.mydomain.com:1433;databaseName=webrepos;integratedSecurity=true;","sql":"SELECT

  • FROM [Webrepos].[dbo].[User]"
    }
    }

This takes but then in the logs I'm getting this:

2015-01-02 11:17:04,829][INFO ][river.jdbc.RiverMetrics ] pipeline
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline@730a6f3 complete: river
jdbc/users metrics: 0 rows, 0.0 mean, (0.0 0.0 0.0), ingest metrics:
elapsed 0 seconds, 0.0 bytes bytes, 0.0 bytes avg, 0 MB/s
[2015-01-02 11:17:04,808][ERROR][river.jdbc.RiverPipeline ]
java.lang.NullPointerException
java.io.IOException: java.lang.NullPointerException
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.fetch(SimpleRiverSource.java:341)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.fetch(SimpleRiverFlow.java:220)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.execute(SimpleRiverFlow.java:149)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.request(RiverPipeline.java:88)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.java:66)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.java:30)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:514)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.getConnectionForReading(SimpleRiverSource.java:212)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.execute(SimpleRiverSource.java:376)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.fetch(SimpleRiverSource.java:320)
... 9 more

I am using integrated security and the Service is running as an account
that has access to the DB as well as the elasticsearch folders. We have
other services on the same machine that use the same account and am not
getting Connection refused errors.

Any ideas?

It doesn't appear that it is getting any actual data from the database.
Not sure how to check that other than a search query which is returning no
results.

--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/b217c635-915f-4030-9d2d-3fa50419d266%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/b217c635-915f-4030-9d2d-3fa50419d266%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoG2093T%2B1UrtgnrUYjwX89TLS0M05uvMrWzvQ3_UY%2BMpw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Yes because a user name is not required for Integrated security.

I have to get security exceptions to use SQL Auth instead of integrated.

On Friday, January 2, 2015 12:19:24 PM UTC-6, Jörg Prante wrote:

Thanks for report, I have opened an issue for that

https://github.com/jprante/elasticsearch-river-jdbc/issues/430

Do you connect without a user name to JDBC? The error is caused because
you did not pass a user name as parameter.

Jörg

On Fri, Jan 2, 2015 at 7:05 PM, Garrett Johnson <garrett...@gmail.com
<javascript:>> wrote:

Hi All,

I have set up ElasticSearch 1.4.2 and river-jdbc from jprante. I was
able to add a river using sense

put _river/users/_meta
{
"type":"jdbc",
"jdbc": {

"url":"jdbc:sqlserver://My.SQLSever.mydomain.com:1433;databaseName=webrepos;integratedSecurity=true;","sql":"SELECT

  • FROM [Webrepos].[dbo].[User]"
    }
    }

This takes but then in the logs I'm getting this:

2015-01-02 11:17:04,829][INFO ][river.jdbc.RiverMetrics ] pipeline
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline@730a6f3 complete: river
jdbc/users metrics: 0 rows, 0.0 mean, (0.0 0.0 0.0), ingest metrics:
elapsed 0 seconds, 0.0 bytes bytes, 0.0 bytes avg, 0 MB/s
[2015-01-02 11:17:04,808][ERROR][river.jdbc.RiverPipeline ]
java.lang.NullPointerException
java.io.IOException: java.lang.NullPointerException
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.fetch(SimpleRiverSource.java:341)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.fetch(SimpleRiverFlow.java:220)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.execute(SimpleRiverFlow.java:149)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.request(RiverPipeline.java:88)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.java:66)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.java:30)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:514)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.getConnectionForReading(SimpleRiverSource.java:212)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.execute(SimpleRiverSource.java:376)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.fetch(SimpleRiverSource.java:320)
... 9 more

I am using integrated security and the Service is running as an account
that has access to the DB as well as the elasticsearch folders. We have
other services on the same machine that use the same account and am not
getting Connection refused errors.

Any ideas?

It doesn't appear that it is getting any actual data from the database.
Not sure how to check that other than a search query which is returning no
results.

--
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 <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/b217c635-915f-4030-9d2d-3fa50419d266%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/b217c635-915f-4030-9d2d-3fa50419d266%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/f810256d-00de-4d91-98f3-cf3fa9a89636%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

I used this type of string here:

jdbc:sqlserver://localhost;databaseName=AdventureWorks;integratedSecurity=true;

like here:

http://msdn.microsoft.com/en-us/library/ms378428(v=sql.110).aspx

Will try to connect with username and password blank.

On Friday, January 2, 2015 1:52:58 PM UTC-6, Garrett Johnson wrote:

Yes because a user name is not required for Integrated security.

I have to get security exceptions to use SQL Auth instead of integrated.

On Friday, January 2, 2015 12:19:24 PM UTC-6, Jörg Prante wrote:

Thanks for report, I have opened an issue for that

https://github.com/jprante/elasticsearch-river-jdbc/issues/430

Do you connect without a user name to JDBC? The error is caused because
you did not pass a user name as parameter.

Jörg

On Fri, Jan 2, 2015 at 7:05 PM, Garrett Johnson garrett...@gmail.com
wrote:

Hi All,

I have set up ElasticSearch 1.4.2 and river-jdbc from jprante. I was
able to add a river using sense

put _river/users/_meta
{
"type":"jdbc",
"jdbc": {

"url":"jdbc:sqlserver://My.SQLSever.mydomain.com:1433;databaseName=webrepos;integratedSecurity=true;","sql":"SELECT

  • FROM [Webrepos].[dbo].[User]"
    }
    }

This takes but then in the logs I'm getting this:

2015-01-02 11:17:04,829][INFO ][river.jdbc.RiverMetrics ] pipeline
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline@730a6f3 complete: river
jdbc/users metrics: 0 rows, 0.0 mean, (0.0 0.0 0.0), ingest metrics:
elapsed 0 seconds, 0.0 bytes bytes, 0.0 bytes avg, 0 MB/s
[2015-01-02 11:17:04,808][ERROR][river.jdbc.RiverPipeline ]
java.lang.NullPointerException
java.io.IOException: java.lang.NullPointerException
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.fetch(SimpleRiverSource.java:341)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.fetch(SimpleRiverFlow.java:220)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.execute(SimpleRiverFlow.java:149)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.request(RiverPipeline.java:88)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.java:66)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.java:30)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:514)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.getConnectionForReading(SimpleRiverSource.java:212)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.execute(SimpleRiverSource.java:376)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.fetch(SimpleRiverSource.java:320)
... 9 more

I am using integrated security and the Service is running as an account
that has access to the DB as well as the elasticsearch folders. We have
other services on the same machine that use the same account and am not
getting Connection refused errors.

Any ideas?

It doesn't appear that it is getting any actual data from the database.
Not sure how to check that other than a search query which is returning no
results.

--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/b217c635-915f-4030-9d2d-3fa50419d266%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/b217c635-915f-4030-9d2d-3fa50419d266%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/c32b51d9-c1f1-43a4-83c4-a3bed0d022fa%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

I pushed out JDBC plugin version 1.4.0.8 with a fix. Thanks for the report.

Jörg

On Fri, Jan 2, 2015 at 9:10 PM, Garrett Johnson garrettcjohnson@gmail.com
wrote:

I used this type of string here:

jdbc:sqlserver://localhost;databaseName=AdventureWorks;integratedSecurity=true;

like here:

http://msdn.microsoft.com/en-us/library/ms378428(v=sql.110).aspx

Will try to connect with username and password blank.

On Friday, January 2, 2015 1:52:58 PM UTC-6, Garrett Johnson wrote:

Yes because a user name is not required for Integrated security.

I have to get security exceptions to use SQL Auth instead of integrated.

On Friday, January 2, 2015 12:19:24 PM UTC-6, Jörg Prante wrote:

Thanks for report, I have opened an issue for that

https://github.com/jprante/elasticsearch-river-jdbc/issues/430

Do you connect without a user name to JDBC? The error is caused because
you did not pass a user name as parameter.

Jörg

On Fri, Jan 2, 2015 at 7:05 PM, Garrett Johnson garrett...@gmail.com
wrote:

Hi All,

I have set up ElasticSearch 1.4.2 and river-jdbc from jprante. I was
able to add a river using sense

put _river/users/_meta
{
"type":"jdbc",
"jdbc": {
"url":"jdbc:sqlserver://My.SQLSever.mydomain.com:1433;
databaseName=webrepos;integratedSecurity=true;","sql":"SELECT * FROM
[Webrepos].[dbo].[User]"
}
}

This takes but then in the logs I'm getting this:

2015-01-02 11:17:04,829][INFO ][river.jdbc.RiverMetrics ] pipeline
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline@730a6f3 complete:
river jdbc/users metrics: 0 rows, 0.0 mean, (0.0 0.0 0.0), ingest metrics:
elapsed 0 seconds, 0.0 bytes bytes, 0.0 bytes avg, 0 MB/s
[2015-01-02 11:17:04,808][ERROR][river.jdbc.RiverPipeline ]
java.lang.NullPointerException
java.io.IOException: java.lang.NullPointerException
at org.xbib.elasticsearch.river.jdbc.strategy.simple.
SimpleRiverSource.fetch(SimpleRiverSource.java:341)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.
SimpleRiverFlow.fetch(SimpleRiverFlow.java:220)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.
SimpleRiverFlow.execute(SimpleRiverFlow.java:149)
at org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.request(
RiverPipeline.java:88)
at org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(
RiverPipeline.java:66)
at org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(
RiverPipeline.java:30)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(
ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(
ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:514)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.
getConnectionForReading(SimpleRiverSource.java:212)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.
SimpleRiverSource.execute(SimpleRiverSource.java:376)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.
SimpleRiverSource.fetch(SimpleRiverSource.java:320)
... 9 more

I am using integrated security and the Service is running as an account
that has access to the DB as well as the elasticsearch folders. We have
other services on the same machine that use the same account and am not
getting Connection refused errors.

Any ideas?

It doesn't appear that it is getting any actual data from the
database. Not sure how to check that other than a search query which is
returning no results.

--
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.
To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/b217c635-915f-4030-9d2d-3fa50419d266%
40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/b217c635-915f-4030-9d2d-3fa50419d266%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/c32b51d9-c1f1-43a4-83c4-a3bed0d022fa%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/c32b51d9-c1f1-43a4-83c4-a3bed0d022fa%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoGqGg2_F-%2BKPSCLEEzOtGyDg1a_%3Dxn3isX48Xpi9ubKoA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Ok so i got the 1.4.0.8.

When that happened I got an error saying that Integrated Security was not
supported with this driver.

I had to put sqljdbc_auth.dll into they system path variables.

After that it started to work. Windows Auth only!!

Thanks for the help.

On Friday, January 2, 2015 3:06:28 PM UTC-6, Jörg Prante wrote:

I pushed out JDBC plugin version 1.4.0.8 with a fix. Thanks for the report.

Jörg

On Fri, Jan 2, 2015 at 9:10 PM, Garrett Johnson <garrett...@gmail.com
<javascript:>> wrote:

I used this type of string here:

jdbc:sqlserver://localhost;databaseName=AdventureWorks;integratedSecurity=true;

like here:

http://msdn.microsoft.com/en-us/library/ms378428(v=sql.110).aspx

Will try to connect with username and password blank.

On Friday, January 2, 2015 1:52:58 PM UTC-6, Garrett Johnson wrote:

Yes because a user name is not required for Integrated security.

I have to get security exceptions to use SQL Auth instead of integrated.

On Friday, January 2, 2015 12:19:24 PM UTC-6, Jörg Prante wrote:

Thanks for report, I have opened an issue for that

https://github.com/jprante/elasticsearch-river-jdbc/issues/430

Do you connect without a user name to JDBC? The error is caused because
you did not pass a user name as parameter.

Jörg

On Fri, Jan 2, 2015 at 7:05 PM, Garrett Johnson garrett...@gmail.com
wrote:

Hi All,

I have set up ElasticSearch 1.4.2 and river-jdbc from jprante. I was
able to add a river using sense

put _river/users/_meta
{
"type":"jdbc",
"jdbc": {
"url":"jdbc:sqlserver://My.SQLSever.mydomain.com:1433;
databaseName=webrepos;integratedSecurity=true;","sql":"SELECT * FROM
[Webrepos].[dbo].[User]"
}
}

This takes but then in the logs I'm getting this:

2015-01-02 11:17:04,829][INFO ][river.jdbc.RiverMetrics ] pipeline
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline@730a6f3 complete:
river jdbc/users metrics: 0 rows, 0.0 mean, (0.0 0.0 0.0), ingest metrics:
elapsed 0 seconds, 0.0 bytes bytes, 0.0 bytes avg, 0 MB/s
[2015-01-02 11:17:04,808][ERROR][river.jdbc.RiverPipeline ]
java.lang.NullPointerException
java.io.IOException: java.lang.NullPointerException
at org.xbib.elasticsearch.river.jdbc.strategy.simple.
SimpleRiverSource.fetch(SimpleRiverSource.java:341)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.
SimpleRiverFlow.fetch(SimpleRiverFlow.java:220)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.
SimpleRiverFlow.execute(SimpleRiverFlow.java:149)
at org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.request(
RiverPipeline.java:88)
at org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(
RiverPipeline.java:66)
at org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(
RiverPipeline.java:30)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at java.util.concurrent.ThreadPoolExecutor.runWorker(
ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(
ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:744)
Caused by: java.lang.NullPointerException
at java.util.Hashtable.put(Hashtable.java:514)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.
SimpleRiverSource.getConnectionForReading(SimpleRiverSource.java:212)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.
SimpleRiverSource.execute(SimpleRiverSource.java:376)
at org.xbib.elasticsearch.river.jdbc.strategy.simple.
SimpleRiverSource.fetch(SimpleRiverSource.java:320)
... 9 more

I am using integrated security and the Service is running as an
account that has access to the DB as well as the elasticsearch folders. We
have other services on the same machine that use the same account and am
not getting Connection refused errors.

Any ideas?

It doesn't appear that it is getting any actual data from the
database. Not sure how to check that other than a search query which is
returning no results.

--
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.
To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/b217c635-915f-4030-9d2d-3fa50419d266%
40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/b217c635-915f-4030-9d2d-3fa50419d266%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
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 <javascript:>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/c32b51d9-c1f1-43a4-83c4-a3bed0d022fa%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/c32b51d9-c1f1-43a4-83c4-a3bed0d022fa%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/5517fad4-0f62-45f5-956b-0139da14902c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.