# Can't running mutiple JDBC

**URL:** <https://discuss.elastic.co/t/cant-running-mutiple-jdbc/209778>\
**Category:** Logstash\
**Created:** [November 28, 2019, 2:13am UTC](https://discuss.elastic.co/t/cant-running-mutiple-jdbc/209778 "2019-11-28T02:13:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sist](https://avatars.discourse-cdn.com/v4/letter/s/ba9def/32.png) [@sist](https://discuss.elastic.co/u/sist)\
**Post date:** [November 28, 2019, 2:13am UTC](https://discuss.elastic.co/t/cant-running-mutiple-jdbc/209778/1 "2019-11-28T02:13:12Z")

</div>

I'm trying to import data from multiple database including mysql and sqlserver to es. With single JDBC it works just fine, but with multiple JDBC it doesn't work and gives no error message. Is this caused by using different driver at the sametime? The conf is  
input {  
jdbc {  
jdbc\_connection\_string =\> "jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true"  
jdbc\_user =\> "root"  
jdbc\_password =\> "password"  
jdbc\_driver\_library =\> "C:\logstash-7.4.2\logstash-core\lib\mysql-connector-java-8.0.18.jar"  
jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"  
jdbc\_paging\_enabled =\> "true"  
jdbc\_page\_size =\> "50000"  
statement =\> "select \* from blog\_content WHERE update\_date \>= :sql\_last\_value"  
schedule =\> "\* \* \* \* _"   
jdbc\_default\_timezone =\>"Asia/Shanghai"  
type=\>"mysqltest"   
}  
jdbc {  
jdbc\_connection\_string =\> "jdbc:sqlserver://127.0.0.1:1433;databaseName=logstashtest;"  
jdbc\_driver\_library =\> "C:\logstash-7.4.2\logstash-core\lib\mssql-jdbc-6.2.2.jre8.jar"  
jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
jdbc\_user =\> "sa"  
jdbc\_password =\> "password"  
jdbc\_paging\_enabled =\> "true"  
jdbc\_page\_size =\> "50000"  
statement =\> "SELECT \* FROM blog\_content WHERE UpdateTime \>= :sql\_last\_value"  
schedule =\> "_ \* \* \* \*"  
jdbc\_default\_timezone =\> "Asia/Shanghai"   
type=\>"sqlservertest"  
}

}  
output {  
if[type] == "mysqltest" {  
elasticsearch {  
hosts =\> "127.0.0.1:9200"   
index =\> "blogtest"   
document\_id =\> "%{id}"  
}  
}  
if[type] == "sqlservertest" {  
elasticsearch {  
hosts =\> "127.0.0.1:9200"   
index =\> "blogtest2"   
document\_id =\> "%{Gid}"  
}  
}  
stdout {  
codec =\> json\_lines  
}  
}

---

<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:** [December 26, 2019, 2:13am UTC](https://discuss.elastic.co/t/cant-running-mutiple-jdbc/209778/2 "2019-12-26T02:13:13Z")

</div>

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