# Unable to ingest data using different JDBC Drivers in one Conf file

**URL:** <https://discuss.elastic.co/t/unable-to-ingest-data-using-different-jdbc-drivers-in-one-conf-file/266261>\
**Category:** Logstash\
**Created:** [March 4, 2021, 4:21pm UTC](https://discuss.elastic.co/t/unable-to-ingest-data-using-different-jdbc-drivers-in-one-conf-file/266261 "2021-03-04T16:21:31Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ronaldom](https://avatars.discourse-cdn.com/v4/letter/r/8baadc/32.png) [@ronaldom](https://discuss.elastic.co/u/ronaldom)\
**Post date:** [March 4, 2021, 4:21pm UTC](https://discuss.elastic.co/t/unable-to-ingest-data-using-different-jdbc-drivers-in-one-conf-file/266261/1 "2021-03-04T16:21:31Z")

</div>

Hello, I am currently doing a proof of concept where I try to pull data from 2 different databases (SQL and Snowflake). I don't see any error in the logs when running the conf file and logstash never seem to complete even though I'm query top 1 record for each database. I am using v5.6 logstash version.

Sample conf:

```auto
    input {
      jdbc {
        jdbc_driver_library => "/home/ubuntu/sqljdbc_6.2/enu/mssql-jdbc-6.2.1.jre8.jar"
        jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
        jdbc_connection_string => "jdbc:sqlserver://<server>;user=<user>;password=<password>;"
        jdbc_user => "<user>"
        jdbc_password => "<password>"
        jdbc_validate_connection => true
        jdbc_validation_timeout => -1
    	last_run_metadata_path => "/etc/logstash/.logstash_jdbc_employee_last_run"
        clean_run => true
        statement => "SELECT TOP 1 * FROM [ABC].[dbo].[Employee] ORDER BY ID"
        type => "employee"
      }
      jdbc {
        jdbc_driver_library => "/home/ubuntu/snowflake-jdbc-3.13.0/snowflake-jdbc-3.13.0.jar"
        jdbc_driver_class => "com.snowflake.client.jdbc.SnowflakeDriver"
        jdbc_connection_string => "jdbc:snowflake://<account name>.snowflakecomputing.com/?role=<role>&warehouse=<warehouse>&db=<db>&schema=<schema>"
        jdbc_user => "<user>"
        jdbc_password => "<password>"
        jdbc_validate_connection => true
        jdbc_validation_timeout => -1
        last_run_metadata_path => "/etc/logstash/.logstash_jdbc_department_last_run"
        clean_run => true
        statement => "SELECT TOP 1 * FROM WH.PUB_COM.V_DEPT"
        type => "department"
      }
    }
    output {
    }

```

I didn't see any documentation that says logstash does not support loading multiple types of db is not supported. The closest one I saw is from another forum [post](https://discuss.elastic.co/t/logstash-jdbc-input-unable-to-connect-to-multiple-db/104461) similar to what I'm trying to do but never answered.

---

<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:** [April 1, 2021, 4:22pm UTC](https://discuss.elastic.co/t/unable-to-ingest-data-using-different-jdbc-drivers-in-one-conf-file/266261/2 "2021-04-01T16:22:21Z")

</div>

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