Driver to SQLExpress

General Discussion
1

Hello!

I am new to liquibase but it sounds great.
I decided to give it a try even if I am more familiar with .net than java.

So for a quick test my aim is to connect it to my local SQLExpress instance and create a table.

I installed all necessary files (liquibase, SDK for Java, and sqljdbc.jar into lib).
I created a simple “changelog.xml” file with nothing but a simple create table command.

Then I tried a command line such as:
“liquibase update” (or “java -jar liquibase-1.9.5.jar update”).

Unfortunately it returns an error about the driver:
“Migration Failed: Connection could not be created to jdbc:sqlserver:http://MyIP;databaseName=MyDatabaseName; with driver java.lang.String.  Possibly the wrong driver for the given database URL.  For more information, use the --logLevel flag)”

Can someone help me to figure out what is a correct Driver for SQLExpress?
Thanks!

Here is my “liquibase.properties” file:
classpath=lib/sqljdbc.jar;
changeLogFile=changelog.xml
driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://MyIP;databaseName=MyDatabaseName;
username=Foo
password=Foo
logLevel=finest
logFile=log.txt

2

Finally I got it working :slight_smile:

The issue was a syntax error with the line
url=jdbc:sqlserver://MyIP;databaseName=MyDatabaseName;

I basically wrote
url=jdbc:sqlserver:http://100.100.100.100;databaseName=MyDatabaseName;
instead of
url=jdbc:sqlserver://100.100.100.100;databaseName=MyDatabaseName;

3

Glad you found it.  Let us know if you run into any other troubles.

Nathan