No default DRIVER registered for jdbc:mysql
I edit /exa/etc/EXAConf, and then add
# MYSQL driver configuration
[[MYSQL]]
# BucketFS that contains the MYSQL driver
BucketFS = bfsdefault
# Bucket that contains the MYSQL driver
Bucket = default
# Directory within the bucket that contains the drivers
Dir = drivers/mysql
settings.cfg is DRIVERNAME=MYSQL JAR=mysql-connector-java-8.0.23.jar DRIVERMAIN=com.mysql.jdbc.Driver PREFIX=jdbc:mysq: FETCHSIZE=100000 INSERTSIZE=-1
then I put "mysql-connector-java-8.0.23.jar" & " settings.cfg" into both /exa/etc/drivers/jdbc/ /exa/etc/drivers/mysql/ /exa/data/bucketfs/default/drivers/jdbc/ /exa/data/bucketfs/default/drivers/mysql/
when I run the sql
CREATE OR REPLACE CONNECTION JDBC_MYSQL TO 'jdbc:mysql://114.115.160.23:13306/dbtest' USER 'root' IDENTIFIED BY '123456';
SELECT * FROM ( import from JDBC at JDBC_MYSQL statement 'select''dbtype cmd cost''FROM exec' );
SQL 错误 [ETL-1]: No default DRIVER registered for jdbc:mysql://192.168.1.124:3306/dbtest. Please specify DRIVER or add a default via EXAoperation (Session: 1692655403001184256)