# Jdbc importer not working

**URL:** <https://discuss.elastic.co/t/jdbc-importer-not-working/84909>\
**Category:** Elasticsearch\
**Created:** [May 8, 2017, 9:38am UTC](https://discuss.elastic.co/t/jdbc-importer-not-working/84909 "2017-05-08T09:38:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gowtham](https://avatars.discourse-cdn.com/v4/letter/g/b4bc9f/32.png) [@gowtham](https://discuss.elastic.co/u/gowtham)\
**Post date:** [May 8, 2017, 9:38am UTC](https://discuss.elastic.co/t/jdbc-importer-not-working/84909/1 "2017-05-08T09:38:39Z")

</div>

@echo off

set DIR=%~dp0  
set LIB=%DIR%..\lib\*  
set BIN=%DIR%..\bin

REM ???  
echo '{^  
"type" : "jdbc",^  
"jdbc" : {^  
"url" : "jdbc:mysql://localhost:3306/emplo",^  
"user" : "root",^  
"password" : "root",^  
"sql" : "select _, id as \_id,id,username from empl",^  
"elasticsearch" : {^  
"cluster" : "elasticsearch",^  
"host" : "localhost",^  
"port" : 9200^  
},^  
"index" : "data",^  
"type":"da",^  
},^  
},^ '| "C:\Program Files\Java\jdk1.8.0\_131\bin\java" -cp "C:\elastic\elasticsearch-jdbc-2.3.2.0\lib/_" -Dlog4j.configurationFile="C:\elastic\elasticsearch-jdbc-2.3.2.0\bin\log4j2.xml" "org.xbib.tools.Runner" "org.xbib.tools.JDBCImporter"

i am using windows 8 elastic search 2.3.2 and elastic-jdbc 2.3.2.0

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 5, 2017, 9:50am UTC](https://discuss.elastic.co/t/jdbc-importer-not-working/84909/2 "2017-06-05T09:50:58Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.