inventertom opened a new issue, #18489: URL: https://github.com/apache/doris/issues/18489
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Version doris 1.2.3 mssel-jdbc-11.2.3.jre8.jar mssel-jdbc-12.2.0.jre8.jar mssel-jdbc-8.4.1.jre8.jar ### What's Wrong? 利用外表 查询sqlserver 数据 报，Execution failed: Error Failed to execute sql: java.sql.SQLException: (conn=839) errCode = 2, detailMessage = Jdbc connector _register_func_id meet error and error is NoSuchMethodError: convertDateToLong ### What You Expected? 支持 converDateToLong ### How to Reproduce? sqlserver schema CREATE TABLE [dbo].[rt_prdSNTraceDetail]( [ProcessTraceID] [dbo].[dm_SystemID] NOT NULL, [PrdID] [dbo].[dm_SystemID] NOT NULL, [ParentPrdID] [dbo].[dm_SystemID] NULL, [inDTime] [datetime] NOT NULL, [AssemblyType] [varchar](12) NOT NULL CONSTRAINT [PK_rt_prdSNTraceDetail] PRIMARY KEY CLUSTERED ( [ProcessTraceID] ASC, [PrdID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ) Doris schema CREATE EXTERNAL RESOURCE sqlserver_resource1 properties ( "type"="jdbc", "user"="DaasUser", "password"="Kaifa#daasuser", "jdbc_url"="jdbc:sqlserver://xxxxxx:xxxx;databaseName=KFDB_Mes_CSBU2", "driver_url"="http://xxxxxxx.xxxxx/mssql-jdbc-12.2.0.jre8.jar";, "driver_class"="com.microsoft.sqlserver.jdbc.SQLServerDriver" ); CREATE EXTERNAL TABLE sqlserver_db.external_test1( ProcessTraceID STRING NOT NULL, PrdID STRING NOT NULL , ParentPrdID STRING NULL , inDTime datetimev2 not NULL, AssemblyType Varchar(12) NOT NULL ) ENGINE=JDBC COMMENT 'JDBC' PROPERTIES ( "resource" = "sqlserver_resource1", "table" = "rt_PrdSNTraceDetail", "table_type"="sqlserver" ); select * from external_test1 limit 10; Execution failed: Error Failed to execute sql: java.sql.SQLException: (conn=839) errCode = 2, detailMessage = Jdbc connector _register_func_id meet error and error is NoSuchMethodError: convertDateToLong ### Anything Else? _No response_ ### Are you willing to submit PR? - [X] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
