Wrong driver for the given database URL

Community Answers
1

I run the command

liquibase --changeLogFile=dbchangelog.xml generateChangeLog

Then there ws a error saying “Wrong driver for the given database URL”

Starting Liquibase at 15:56:03 (version 4.1.1 #10 built at 2020-10-12 19:24+0000)
[2022-05-13 15:56:03] FINE [liquibase.integration] Adding 'file:/home/nikeshi/Documents/liquibase/database/lib/mysql-connector-java-8.0.29.jar' to the Java classpath.
[2022-05-13 15:56:03] FINE [liquibase.integration] Liquibase Hub URL:      https://hub.liquibase.com
[2022-05-13 15:56:03] FINE [liquibase.integration] Liquibase Hub Mode:     all
[2022-05-13 15:56:03] FINE [liquibase.resource] Adding path /home/nikeshi/Documents/liquibase/database/. to resourceAccessor liquibase.resource.FileSystemResourceAccessor
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.DB2Database
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.Db2zDatabase
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.DerbyDatabase
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.Firebird3Database
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.FirebirdDatabase
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.H2Database
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.HsqlDatabase
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.InformixDatabase
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.Ingres9Database
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.MSSQLDatabase
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.MariaDBDatabase
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.MockDatabase
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.MySQLDatabase
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.OracleDatabase
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.PostgresDatabase
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.SQLiteDatabase
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.SybaseASADatabase
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.SybaseDatabase
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.Database instance liquibase.database.core.UnsupportedDatabase
[2022-05-13 15:56:03] FINE [liquibase.database] Properties:
[2022-05-13 15:56:03] FINE [liquibase.database] Key:'user' Value:'nikeshi'
[2022-05-13 15:56:03] FINE [liquibase.database] Key:'password' Value:'**********'
[2022-05-13 15:56:03] FINE [liquibase.database] Connecting to the URL:'"jdbc:edb://35.244.39.57:3306/employees"' using driver:'com.mysql.cj.jdbc.Driver'
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.DatabaseConnection instance liquibase.database.jvm.JdbcConnection
[2022-05-13 15:56:03] FINE [liquibase.servicelocator] Loaded liquibase.database.DatabaseConnection instance com.datical.liquibase.ext.database.jvm.ProJdbcConnection
Unexpected error running Liquibase: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to "jdbc:edb://35.244.39.57:3306/employees" with driver com.mysql.cj.jdbc.Driver.  Possibly the wrong driver for the given database URL
For more information, please use the --logLevel flag
[2022-05-13 15:56:03] SEVERE [liquibase.integration] Unexpected error running Liquibase: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to "jdbc:edb://35.244.39.57:3306/employees" with driver com.mysql.cj.jdbc.Driver.  Possibly the wrong driver for the given database URL
liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to "jdbc:edb://35.244.39.57:3306/employees" with driver com.mysql.cj.jdbc.Driver.  Possibly the wrong driver for the given database URL
	at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:131)
	at liquibase.integration.commandline.Main.doMigration(Main.java:1408)
	at liquibase.integration.commandline.Main$1.lambda$run$0(Main.java:361)
	at liquibase.Scope.lambda$child$0(Scope.java:160)
	at liquibase.Scope.child(Scope.java:169)
	at liquibase.Scope.child(Scope.java:159)
	at liquibase.Scope.child(Scope.java:138)
	at liquibase.Scope.child(Scope.java:222)
	at liquibase.Scope.child(Scope.java:226)
	at liquibase.integration.commandline.Main$1.run(Main.java:360)
	at liquibase.integration.commandline.Main$1.run(Main.java:193)
	at liquibase.Scope.child(Scope.java:169)
	at liquibase.Scope.child(Scope.java:145)
	at liquibase.integration.commandline.Main.run(Main.java:193)
	at liquibase.integration.commandline.Main.main(Main.java:156)
Caused by: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to "jdbc:edb://35.244.39.57:3306/employees" with driver com.mysql.cj.jdbc.Driver.  Possibly the wrong driver for the given database URL
	at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:250)
	at liquibase.database.DatabaseFactory.openDatabase(DatabaseFactory.java:140)
	at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject(CommandLineUtils.java:96)
	... 14 more
Caused by: liquibase.exception.DatabaseException: liquibase.exception.DatabaseException: Connection could not be created to "jdbc:edb://35.244.39.57:3306/employees" with driver com.mysql.cj.jdbc.Driver.  Possibly the wrong driver for the given database URL
	at liquibase.database.ConnectionServiceFactory.create(ConnectionServiceFactory.java:36)
	at liquibase.database.DatabaseFactory.openConnection(DatabaseFactory.java:247)
	... 16 more
Caused by: liquibase.exception.DatabaseException: Connection could not be created to "jdbc:edb://35.244.39.57:3306/employees" with driver com.mysql.cj.jdbc.Driver.  Possibly the wrong driver for the given database URL
	at liquibase.database.jvm.JdbcConnection.open(JdbcConnection.java:39)
	at com.datical.liquibase.ext.database.jvm.ProJdbcConnection.open(Unknown Source)
	at liquibase.database.ConnectionServiceFactory.create(ConnectionServiceFactory.java:33)
	... 17 more

The liquibase. properties file is as follows.

          driver: com.mysql.cj.jdbc.Driver
          classpath: lib/mysql-connector-java-8.0.29.jar
          url:"jdbc:mysql://35.244.39.57:3306/employees"
          username: nikeshi
          password: <>
          changeLogFile: changelog.mysql.sql
          logLevel: finest

How can solve this issue?

2

Welcome to the Liquibase Community, @nikeshi - This is a pretty common question.

In your properties file, use single quotes around the URL and try again.

3

thank you, it works now

1 Like