search

embulk / embulk-output-jdbc

MySQL, PostgreSQL, Redshift and generic JDBC output plugins for Embulk
Other
88 stars 86 forks source link

embulk-output-sqlserver can't connect to db with instance name #262

Closed hieudion closed 4 years ago

hieudion commented 5 years ago

I faced this issue when using the new version of mssql:JDBC 7.2.2. It runs fine with jtds:jdbc but when updates to mssql:jdbc i can't connect to the db. DB is on Azure I think. Just raise the issue here so we can aware of it.

nickolay commented 4 years ago

FWIW, specifying an instance name works fine here (not Azure, but a local SQL Server 2012):

  out:
    type: sqlserver
  #  driver_path: %(embulk_path)s\mssqljdbc\mssql-jdbc-7.2.1.jre8.jar
    driver_path: %(embulk_path)s\mssqljdbc\mssql-jdbc-7.4.1.jre8.jar

    host: ...
    instance: ...
    user: ...
    password: ...
    mode: insert_direct
    insert_method: native
  # ...
hieudion commented 4 years ago

Thank @nickolay,

Just found the reason, I discussed with Hito about that issue here: https://github.com/embulk/embulk-input-jdbc/issues/168 Going to close this issue.