embulk / embulk/embulk-input-jdbc

The "driver_path" paramater is not working in the embulk-input-sqlserver plugin

Open
#266 8 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
106
Forks
76
PR merge metrics
No merged PRs in 30d

Description

# ENV

* OS: Debian 11.4
* Java: openjdk version "1.8.0_342
* embulk-0.9.24
* embulk-input-sqlserver: 0.13.2

# TO REPRODUCE

1. Download the jdbc driver mssql-jdbc-9.2.0.jre8.jar from microsoft github.

```
wget https://github.com/microsoft/mssql-jdbc/releases/download/v9.2.0/mssql-jdbc-9.2.0.jre8.jar
```

2. Create the config.yml.

```
in:
type: sqlserver
driver_path: /path/to/driver/mssql-jdbc-9.2.0.jre8.jar
url: jdbc:sqlserver://xxxxxxxxxx.net:1433;database=xxx;authentication=ActiveDirectoryPassword;
user: xxxxxx
password: xxxxxx
table: xxxxxx
out:
type: stdout
```

4. Execute the "embulk run config.yml"

Data transfer was successful.
However, the log shows that driver v7.2.2.0 is used instead of the driver specified in driver_path(v9.2.0).

```
2024-09-09 07:06:16.024 +0000 [INFO] (0001:transaction): Using JDBC Driver 7.2.2.0
```

[Full log]

```
user# embulk run config.yml
2024-09-09 07:06:10.482 +0000: Embulk v0.9.24
2024-09-09 07:06:11.258 +0000 [WARN] (main): DEPRECATION: JRuby org.jruby.embed.ScriptingContainer is directly injected.
2024-09-09 07:06:13.150 +0000 [INFO] (main): Gem's home and path are set by default: "/root/.embulk/lib/gems"
2024-09-09 07:06:14.689 +0000 [INFO] (main): Started Embulk v0.9.24
2024-09-09 07:06:14.786 +0000 [INFO] (0001:transaction): Loaded plugin embulk-input-sqlserver (0.13.2)
2024-09-09 07:06:14.839 +0000 [WARN] (0001:transaction): "UTC" is recognized as "Z" to be compatible with the legacy style.
2024-09-09 07:06:14.870 +0000 [INFO] (0001:transaction): Connecting to jdbc:sqlserver://xxxxxx.net:1433;database=xxxxxx;authentication=ActiveDirectoryPassword; options {user=xxxxxx, password=***, applicationName=embulk-input-sqlserver, loginTimeout=300, socketTimeout=1800000}
2024-09-09 07:06:15.652 +0000 [INFO] (pool-2-thread-1): [Correlation ID: xxxxxxxxxxxxxxxxxxx] Instance discovery was successful
2024-09-09 07:06:16.024 +0000 [INFO] (0001:transaction): Using JDBC Driver 7.2.2.0
2024-09-09 07:06:16.157 +0000 [INFO] (0001:transaction): Using local thread executor with max_threads=16 / output tasks 8 = input tasks 1 * 8
2024-09-09 07:06:16.164 +0000 [INFO] (0001:transaction): {done: 0 / 1, running: 0}
2024-09-09 07:06:16.195 +0000 [WARN] (0020:task-0000): Z is deprecated as a military time zone name. Use UTC instead.
2024-09-09 07:06:16.196 +0000 [WARN] (0020:task-0000): "Z" is recognized as "Z" to be compatible with the legacy style.
2024-09-09 07:06:16.262 +0000 [INFO] (0020:task-0000): Connecting to jdbc:sqlserver://xxxxxxxxxxx, password=***, applicationName=embulk-input-sqlserver, loginTimeout=300, socketTimeout=1800000}
2024-09-09 07:06:16.513 +0000 [INFO] (pool-5-thread-1): [Correlation ID: xxxxxxxxx] Instance discovery was successful
2024-09-09 07:06:16.814 +0000 [INFO] (0020:task-0000): SQL: SELECT * FROM "xxxxxxx"
2024-09-09 07:06:16.820 +0000 [INFO] (0020:task-0000): > 0.00 seconds
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.