docker-db icon indicating copy to clipboard operation
docker-db copied to clipboard

No default DRIVER registered for jdbc:mysql

Open 555chy opened this issue 4 years ago • 7 comments

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)

555chy avatar Feb 25 '21 09:02 555chy