You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@doris.apache.org by "inventertom (via GitHub)" <gi...@apache.org> on 2023/04/09 04:00:27 UTC

[GitHub] [doris] inventertom opened a new issue, #18489: [Bug] Jdbc connector _register_func_id meet error and error is NoSuchMethodError: convert Date To Long

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: commits-unsubscribe@doris.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org

[GitHub] [doris] zhangstar333 commented on issue #18489: [Bug] Jdbc connector _register_func_id meet error and error is NoSuchMethodError: convert Date To Long

Posted by "zhangstar333 (via GitHub)" <gi...@apache.org>.

zhangstar333 commented on issue #18489:
URL: https://github.com/apache/doris/issues/18489#issuecomment-1503173076

   could leave some information about how to contact you?
   


-- 
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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org