During an upgrade from JAWS 5.8.x the upgrade log shows: Unable to connect: java.sql.SQLException: No suitable driver found jdbc:sqlserver://ServerName:1433;databaseName=AAI

Products

• Automic Automation Intelligence

Issue/Introduction

ERROR [common.db.DatabaseConnection] Unable to connect: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://ServerName:1433;databaseName=AAI
DEBUG [common.db.DatabaseSchemaVersion] Schema version was not in the database -- determining by schema discovery.

Environment

Release : 5.8.3

Component : AUTOMIC AUTOMATION INTELLIGENCE ENGINE

Resolution

If the JAWS database type is SQL Server and the Connection URL is not correct the upgrade to 5.8.5 will fail. 

The /jboss/standalone/configuration/jaws.properties file must be modified to set the Connection URL to the jtds driver (dbms.mssql.url=jdbc:jtds:sqlserver://) prior to running the upgrade.