jdbc-river error: no sqljdbc_auth in java.ibrary.path for sqlserver dll

[Alfredo Serafini]

Hi to all

I have the following problem with sqlserver authentication.


I am using ElasticSearch with SQLServer using the mixed authentication; I 
define my indexing on the river plugin as something like:
>> curl -XPUT "http://localhost:9200/_river/itra_jdbc_river/_meta"; -d'
{
  "type": "jdbc",
  "jdbc": {
    "driver": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
    "url": 
"jdbc:sqlserver://MY_SERVER;integratedSecurity=true;databaseName=MY_DB",
    "user": "INTRANET\\MY_USER",
    "password": "MY_PWD",
    "sql": "SELECT * FROM A_TABLE",
    "versioning": false
  },
  "index": {
    "index": "test",
    "type": "values"
  }
}'

and I started ES with -Djava.library.path="mssql\auth\x64" option, where 
"mssql" folder is under the jdbc-river plugin folder.

However, I still obtain the "no sqljdbc_auth in java.ibrary.path" error, so 
the dll seems to be not correctly referenced. I also notice that the jar 
for sqlserver must be instead on the jdbc-river folder itself.

Any suggestions?

thanks in advance,
Alfredo

-- 
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/elasticsearch/000230a4-2f06-4fc8-b1f1-56ec69ada894%40googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.