Import Bridge for Microsoft SQL Server Database (via JDBC) Failing with "java.sql.SQLException: No suitable driver found" (Doc ID 2634361.1)

Last updated on JUNE 01, 2023

Applies to:

Symptoms

When attempting to import from SQL server using the import bridge from Microsoft SQL Server Database (via JDBC) the following error can be seen in the log with debug mode:

Error accessing repository. Please check logs for details.

[Information]     [2020-01-30 13:26:39]  MIMB process ID=6654
[Information]     [2020-01-30 13:26:39]  Running as an application on behalf of '<OS_SYSTEM_USER>'
[Information]     [2020-01-30 13:26:39]  System Hardware: null at 6 CPU(s)/Core(s) with 15772 RAM
[Information]     [2020-01-30 13:26:39]  System Software: Linux 4.14.35-1902.9.2.el7uek.x86_64 amd64 on <HOST_NAME> with Office:
[Information]     [2020-01-30 13:26:39]  System encoding: UTF-8
[Information]     [2020-01-30 13:26:39]  Data directory: /home/oracle/OracleMetadataManagement/tomcat/../data
[Information]     [2020-01-30 13:26:39]  Using OEM license MIR_WEB
[Information]     [2020-01-30 13:26:39]  Import tool: Microsoft SQL Server Database 7.0 to 14.x (2017) (http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx)
[Information]     [2020-01-30 13:26:39]  Import interface: [Relational Database] Data Store (Physical Data Model, Stored Procedure Expression Parsing) via JDBC API from JdbcMicrosoftSqlServer <2020-01-30 13:26:39>
[Information]     [2020-01-30 13:26:39]  Import bridge: 'JdbcMicrosoftSqlServer' JdbcSqlServer: 10.0.0 - 2019-01-09 11:40:11
[Information]     [2020-01-30 13:26:39]   Driver location = /home/oracle/Downloads/OracleMetadataManagement/java/Jdbc/mssql
[Information]     [2020-01-30 13:26:39]   Host = <HOST_NAME>
[Information]     [2020-01-30 13:26:39]   Port = 14331
[Information]     [2020-01-30 13:26:39]   Instance = <NAME>
[Information]     [2020-01-30 13:26:39]   User = <USER_NAME>
[Information]     [2020-01-30 13:26:39]   Password = ******
[Information]     [2020-01-30 13:26:39]   Database = <DB_NAME>
[Information]     [2020-01-30 13:26:39]   Schema =
[Information]     [2020-01-30 13:26:39]   Tables, Views =
[Information]     [2020-01-30 13:26:39]   Stored Procedures, Functions =
[Information]     [2020-01-30 13:26:39]   Stored procedure details = Signature
[Information]     [2020-01-30 13:26:39]   Import indexes = False
[Information]     [2020-01-30 13:26:39]   Miscellaneous =
[Information]     [2020-01-30 13:26:39]  Browsing bridge parameter 'Database'...
[Information]     [2020-01-30 13:26:39]  Loading jar files from '/home/oracle/Downloads/OracleMetadataManagement/java/Jdbc/mssql'
[Information]     [2020-01-30 13:26:39]  Started Java Oracle Corporation version 1.8.0_181-b13 in '/home/oracle/OracleMetadataManagement/jre' using 1820 MB RAM. Custom options: -Xms256m, -Xmx2048m
[Information]     [2020-01-30 13:26:39]  MITI component(s) with build version '10.0.0 - 2019-01-09': JdbcSqlServer.jar
[Information]     [2020-01-30 13:26:39]  MITI component(s) with build version '10.0.0 - 2019-02-06': MIR.jar
[Information]     [2020-01-30 13:26:39]  MITI component(s) with build version '10.0.0 - 2019-02-08': Mimb.jar
[Information]     [2020-01-30 13:26:39]  MITI component(s) with build version '10.0.0 - 2019-04-10': MIRUtil.jar
[Information]     [2020-01-30 13:26:39]  MITI component(s) with build version '10.0.0 - 2019-04-12': Licensing.jar
[Information]     [2020-01-30 13:26:39]  MITI component(s) with build version '10.0.0 - 2019-04-26': MIRBridgeConstants.jar
[Information]     [2020-01-30 13:26:39]  MITI component(s) with build version '10.0.0 - 2019-08-02': MIRModelConverter.jar
[Information]     [2020-01-30 13:26:39]  MITI component(s) with build version '10.0.0 - 2019-08-19': DdlScriptLib.jar
[Information]     [2020-01-30 13:26:39]  MITI component(s) with build version '10.0.0 - 2019-09-11': MIRExpressionLib.jar
[Information]     [2020-01-30 13:26:39]  MITI component(s) with build version '10.0.0 - 2019-09-12': MIREtlBridgeLib.jar
[Information]     [2020-01-30 13:26:39]  MITI component(s) with build version '10.0.0 - 2019-12-17': JdbcCommon.jar
[Information]     [2020-01-30 13:26:39]  MITI component(s) with build version '10.0.0 - 2020-01-16': MIRModelBridge.jar
[Error]     [2020-01-30 13:26:39]  MITI.MIRException: No suitable driver found for jdbc:sqlserver://<HOST_NAME>
MITI.MIRException: No suitable driver found for jdbc:sqlserver://<HOST_NAME>
  at MITI.bridges.jdbc4.Import.database.DatabaseEnvironmentImporter.createConnection(DatabaseEnvironmentImporter.java:242)
  at MITI.bridges.jdbc4.Import.database.DatabaseEnvironmentImporter.loadDatabaseVerion(DatabaseEnvironmentImporter.java:91)
  at MITI.bridges.jdbc4.Import.database.DatabaseEnvironmentImporter.<init>(DatabaseEnvironmentImporter.java:78)
  at MITI.bridges.jdbc4.Import.database.sqlserver.SqlServerImportBridge.getDatabaseImporter(SqlServerImportBridge.java:130)
  at MITI.bridges.jdbc4.Import.database.ImportBridge.browse(ImportBridge.java:390)
  at MITI.bridges.javabridge.JavaBridge.runBrowse(JavaBridge.java:162)
  at MITI.bridges.javabridge.JavaBridge.main(JavaBridge.java:468)
Caused by: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://<HOST_NAME>
  at java.sql.DriverManager.getConnection(DriverManager.java:689)
  at java.sql.DriverManager.getConnection(DriverManager.java:208)
  at MITI.bridges.jdbc4.Import.database.DatabaseEnvironmentImporter.getConnection(DatabaseEnvironmentImporter.java:283)
  at MITI.bridges.jdbc4.Import.database.DatabaseEnvironmentImporter.createConnection(DatabaseEnvironmentImporter.java:223)
  ... 6 more
[Error]     [2020-01-30 13:26:39]  [JBDG_F0006] The Java process did not complete successfully
MITI.MIRException: [JBDG_F0006] The Java process did not complete successfully
  at MITI.bridges.javabridgeinterface.JavaBridgeExec.exec(JavaBridgeExec.java:514)
  at MITI.bridges.javabridgeinterface.JavaBridgeExec.javaBrowse(JavaBridgeExec.java:145)
  at MITI.bridges.jdbc4.Import.database.AbstractJdbcBridgeInterface.browse(AbstractJdbcBridgeInterface.java:154)
  at MITI.mimb.executable.actions.BrowseAction.run(BrowseAction.java:188)
  at MITI.mimb.executable.actions.Action.execute(Action.java:90)
  at MITI.mimb.executable.MimbExecutable.executeRequest(MimbExecutable.java:585)
  at MITI.mimb.executable.MimbExecutable.executeRequest(MimbExecutable.java:507)
  at MITI.mimb.executable.MimbExecutable.executeRequest(MimbExecutable.java:488)
  at MITI.providers.mimb.MimbExecutionThread.run(MimbExecutionThread.java:170)
[Information]     [2020-01-30 13:26:40]  MITI component(s) with build version '10.0.0 - 2019-02-06': MIR.jar
[Information]     [2020-01-30 13:26:40]  MITI component(s) with build version '10.0.0 - 2019-04-10': MIRUtil.jar
[Information]     [2020-01-30 13:26:40]  MITI component(s) with build version '10.0.0 - 2019-10-31': MIRModelBridge.jar
[Information]     [2020-01-30 13:26:40]  MITI component(s) with build version '10.0.0 - 2019-12-13': MIMBWebServices.jar

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.