Using JDBC catalog for insert data from MS SQL Server into StarRocks

Working with Data Data Loading Tools & Integrations
1

Hello everybody!

I created JDBC catalog as shown in the documentation:

CREATE EXTERNAL CATALOG jdbc0
PROPERTIES
(
    "type" = "jdbc",
    "user" = "my_user",
    "password" = "my_password",
    "jdbc_uri" = "jdbc:sqlserver://my_host:1433;databaseName=my_database;",
    "driver_url" = "https://my_repository/maven/com/microsoft/sqlserver/mssql-jdbc/12.4.2.jre11/mssql-jdbc-12.4.2.jre11.jar",
    "driver_class" = "com.microsoft.sqlserver.jdbc.SQLServerDriver"
);

And I success run next queries:

SHOW DATABASES FROM jdbc0; -- the list of databases from SQL Server
SHOW TABLES FROM jdbc0.my_database; -- the list of database's tables from SQL Server
SHOW COLUMNS FROM jdbc0.my_database.my_table; -- the list of columns with data types of table from SQL Server

But when I run:

SELECT * FROM jdbc0.my_database.my_table; -- the reading of table from SQL Server

I’m expecting a read table “my_table” from SQL Server, but I getting that error:

A error occurred: errorCode=2001 errorMessage:Connection reset, host: unknown

Details of error

org.jkiss.dbeaver.model.sql.DBSQLException: SQL Error [1064] [42000]: A error occurred: errorCode=2001 errorMessage:Connection reset, host: unknown at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:133) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeStatement(SQLQueryJob.java:631) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.lambda$2(SQLQueryJob.java:522) at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:192) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.executeSingleQuery(SQLQueryJob.java:541) at org.jkiss.dbeaver.ui.editors.sql.execute.SQLQueryJob.extractData(SQLQueryJob.java:1001) at org.jkiss.dbeaver.ui.editors.sql.SQLEditor$QueryResultsContainer.readData(SQLEditor.java:4238) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.lambda$0(ResultSetJobDataRead.java:128) at org.jkiss.dbeaver.model.exec.DBExecUtils.tryExecuteRecover(DBExecUtils.java:192) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetJobDataRead.run(ResultSetJobDataRead.java:126) at org.jkiss.dbeaver.ui.controls.resultset.ResultSetViewer$ResultSetDataPumpJob.run(ResultSetViewer.java:5166) at org.jkiss.dbeaver.model.runtime.AbstractJob.run(AbstractJob.java:117) at org.eclipse.core.internal.jobs.Worker.run(Worker.java:63) Caused by: java.sql.SQLSyntaxErrorException: A error occurred: errorCode=2001 errorMessage:Connection reset, host: unknown at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:770) at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:653) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.execute(JDBCStatementImpl.java:332) at org.jkiss.dbeaver.model.impl.jdbc.exec.JDBCStatementImpl.executeStatement(JDBCStatementImpl.java:131)

So maybe somebody has experience solving that problem?
Or the use case like that for export data from SQL Server into StarRocks?
Or does anyone have any ideas where I can look for an answer?

StarRocks version - 8.0.33
MS SQL Server version - 15.0.4223.1

2

can u try add limit 1 and see if can success?

3

SOLVING THE PROBLEM:
It was necessary to set the environment variable “JAVA_HOME” on the StarRocks side.