[DISCUSS]The JDBC engine reported an error on Workflow startup

[康悦Rita <ri...@163.com>]

Dear:

Wechat group "Apache Linkis community Development group "chat records are as follows:  微信群"Apache Linkis 社区开发群"的聊天记录如下:



—————  2022-9-7  —————

 utopianet 闪电先生  10:37

@CCweixiao_intsig_leojie 大佬 jdbc引擎好像在workflow里面启动的时候，如果url用了useUnicode=utf8会报错  JDBC engine seems to start in workflow, if the URL uses useUnicode=utf8, an error will be reported




 utopianet 闪电先生   10:37

看看是不是bug    check it ， If there is a bug？




leojie 海森堡  10:39

报啥错？

What is wrong?

 utopianet 闪电先生   10:44

那个生成的shell跑不了

That generated shell won't run




 utopianet 闪电先生   10:44








utopianet 闪电先生  10:44

看起来不能有=号

Doesn't look like you can have an' = ’ sign

 utopianet 闪电先生   10:44

script跑是正常的

Script runs are normal

 utopianet 闪电先生   10:44

workflow不能跑

The workflow can't run

 leojie 海森堡 10:50

是不是参数里有特殊字符 被截断了？

Is there a special character in the argument that is truncated?

 utopianet 闪电先生   10:51

对 就是常见那个设置字符集

Yeah, that's the common character set

 leojie 海森堡  10:57

用引号引起来jdbc url呢

 It's a JDBC URL in quotes？

limeng 李孟  10:57

useUnicode 设置参数有问题，不能填utf8，填true/false 
UseUnicode setting parameter error, cannot use UTf8, use true/false

 

 leojie 海森堡 10:58

传的时候jdbc url中有特殊字符被截断，用"引起来，jdbc引擎内部接收到url会帮你去掉前后引号的

When the JDBC URL is sent, special characters are truncated, which is caused by ". The internal JDBC engine will help you remove the quotation marks after receiving the URL

 utopianet 闪电先生   11:01








utopianet 闪电先生  11:01

我是这样填

I fill it out like this

utopianet 闪电先生  11:01

@CCweixiao_intsig_leojie 我试试 i try 




 leojie 海森堡  11:02

嗯嗯 "jdbc://url" 这样试试  "JDBC :// URL" Try this




 utopianet 闪电先生   11:09

@CCweixiao_intsig_leojie 结果一样 The same result




 utopianet 闪电先生   11:21

我再详细测试一下  Let me test it in more detail




 

Best Regards
------
康悦 ritakang 
GitHub：Ritakang0451
E-mail：rita0451@163.com