I am having issues with using JDBC Driver for ElasticSearch River to feed data from SQL Server 2012 enterprise. 

Here is my setup:

* OS : Windows 2008 R2 X64
* ES : 1.2.1
* JDK : jdk-7u60-windows-x64
* JRE : jre-7u60-windows-x64
* Microsoft JDBC Driver 4.0 for SQL Server

When I ran the jdbc to feed the data into ES i got the below exception:

---

`C:\Users\madhavan.ram>curl -XPUT 'localhost:9200/orders/order/_meta' -d' {"type": "jdbc", "jdbc": {"driver
": "com.microsoft.sqlserver.jdbc.SQLServerDriver","url": "jdbc:sqlserver://localhost:1433;databaseName=adventureworks", "user":"sa","password":"password",
"sql": "SELECT * From [orders]","index": "orders","type": "order","bulk_size": 100,"max_retries": 5,"max_retries_wait": "30s","max_bulk_requests": 5,"bulk_flush_interval": "5s"}}'
curl: (3) [globbing] nested brace in column 83
curl: (6) Could not resolve host: *
curl: (6) Could not resolve host: From
curl: (3) [globbing] bad range in column 6`

---

It looks like MSSQL 4.0 driver does not support JDK 1.7. But If i configure the JAVA\_Home to JDK 1.6.. ES does not work on windows. Is there a better way to load data from SQL Server 2012 to ElasticSearch?