jdbc error

[makkaba]

env

openjdk version "1.8.0_282"
OpenJDK Runtime Environment (build 1.8.0_282-b08)
OpenJDK 64-Bit Server VM (build 25.282-b08, mixed mode)

embulk 0.9.23

jdbc
mysql-connector-java-8.0.25

use case

mysql -> msyql

yaml

nothing special. simple.

error

Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.TimeUtil
	at org.embulk.plugin.PluginClassLoader.loadClass(PluginClassLoader.java:161)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:264)
	at org.embulk.input.MySQLInputPlugin.loadTimeZoneMappings(MySQLInputPlugin.java:161)
	... 15 more

Error: java.lang.RuntimeException: java.lang.ClassNotFoundException: com.mysql.jdbc.TimeUtil

check out please!

[hiroyuki-sato]

Hello, @makkaba

We are still developing the embulk-output-mysql using Connector/J 8.x

#163
#200

Please wait for a while or try this patch

[JongpilW0N]

@hiroyuki-sato
hi.
how to use patch ?
please give me some advice.

[hiroyuki-sato]

Hello, @JongpilW0N

The latest commit has changed many places. So, you can't apply a patch to the latest code easily.

If you want to try my modification, you can build the package with the following steps.

git clone https://github.com/hiroyuki-sato/embulk-input-jdbc.git
cd embulk-input-jdbc
git checkout -b connector-j-v8 origin/topic/connector-j-v8
./gradlew embulk-input-mysql:gem

You will find embulk-input-mysql/build/gems/embulk-input-mysql-0.11.0-java.gem