title: ElasticSearch JDBC River for SQL Server 2012 enterprise
body: <p>I am having issues with using JDBC Driver for ElasticSearch River to feed data from SQL Server 2012 enterprise.  </p>
  
  <p>Here is my setup:</p>
  
  <ul>
  <li>OS : Windows 2008 R2 X64</li>
  <li>ES : 1.2.1</li>
  <li>JDK : jdk-7u60-windows-x64</li>
  <li>JRE : jre-7u60-windows-x64</li>
  <li>Microsoft JDBC Driver 4.0 for SQL Server</li>
  </ul>
  
  <p>When I ran the jdbc to feed the data into ES i got the below exception:</p>
  
  <hr>
  
  <p><code>C:\Users\madhavan.ram&gt;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</code></p>
  
  <hr>
  
  <p>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?</p>