[GitHub] [seatunnel] CheneyYin commented on pull request #4803: [Feature][Connector-V2] jdbc connector supports Kingbase database

[via GitHub]

CheneyYin commented on PR #4803:
URL: https://github.com/apache/seatunnel/pull/4803#issuecomment-1633574813

   > > > > > > > > please add e2e testcase 
https://github.com/apache/seatunnel/tree/dev/seatunnel-e2e/seatunnel-connector-v2-e2e/connector-jdbc-e2e
   > > > > > > > 
   > > > > > > > 
   > > > > > > > need all success？ <img alt="Snipaste_2023-07-07_09-57-44" 
width="529" 
src="https://user-images.githubusercontent.com/72905543/251616238-826d67fb-2844-470d-9796-053c51ebbb71.png";>
   > > > > > > 
   > > > > > > 
   > > > > > > hello @TyrantLucifer ,when i test using spark container 
`Exception in thread "main" 
org.apache.seatunnel.core.starter.exception.CommandExecuteException: 
ErrorCode:[API-01], ErrorDescription:[Configuration item validate failed] - 
PluginName: jdbc, PluginType: source, Message: 
com.kingbase8.util.KSQLException: FATAL: invalid value for parameter 
"client_encoding": "ANSI_X3.4-1968" at 
org.apache.seatunnel.core.starter.spark.command.SparkTaskExecuteCommand.execute(SparkTaskExecuteCommand.java:63)
 at org.apache.seatunnel.core.starter.SeaTunnel.run(SeaTunnel.java:40) at 
org.apache.seatunnel.core.starter.spark.SeaTunnelSpark.main(SeaTunnelSpark.java:35)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at 
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) 
at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498) at 
org.apache.spark.deploy.JavaMainApplicati
 on.start(SparkApplication.scala:52) at 
org.apache.spark.deploy.SparkSubmit.org$apache$spark$deploy$SparkSubmit$$runMain(SparkSubmit.scala:958)
 at org.apache.spark.deploy.SparkSubmit.doRunMain$1(SparkSubmit.scala:180) at 
org.apache.spark.deploy.SparkSubmit.submit(SparkSubmit.scala:203) at 
org.apache.spark.deploy.SparkSubmit.doSubmit(SparkSubmit.scala:90) at 
org.apache.spark.deploy.SparkSubmit$$anon$2.doSubmit(SparkSubmit.scala:1046) at 
org.apache.spark.deploy.SparkSubmit$.main(SparkSubmit.scala:1055) at 
org.apache.spark.deploy.SparkSubmit.main(SparkSubmit.scala)`
   > > > > > 
   > > > > > 
   > > > > > <img alt="image" width="1720" 
src="https://user-images.githubusercontent.com/72905543/251966367-a62cf1b3-4785-4a54-9db1-077fc63d3bb3.png";>
   > > > > >   in local env is ok,I suspect something is wrong with the 
container
   > > > > 
   > > > > 
   > > > > [This link may help you to fix client encoding 
error](https://h2c.tech/p/os%E5%AD%97%E7%AC%A6%E9%9B%86%E5%BD%B1%E5%93%8Dkingbase%E6%95%B0%E6%8D%AE%E5%BA%93%E8%BF%9E%E6%8E%A5/)
   > > > 
   > > > 
   > > > I tried the method in the link, but I couldn't resolve the issue.It 
seems unrelated to the Kingbase database container.I used a local Spark for 
testing, but the Kingbase database was still the one in the container, and it 
worked successfully.
   > > 
   > > 
   > > Yes, I have added the spark container, but it can't be solved.
   > 
   > <img alt="image" width="865" 
src="https://user-images.githubusercontent.com/72905543/253030175-2c577bdb-0c4e-4e97-af9c-9360d8885f06.png";>
   
   ```shell
    docker run tyrantlucifer/spark:2.4.6 locale -a
    05:17:56.97 
    05:17:56.97 Welcome to the Bitnami spark container
    05:17:56.98 Subscribe to project updates by watching 
https://github.com/bitnami/bitnami-docker-spark
    05:17:56.98 Submit issues and feature requests at 
https://github.com/bitnami/bitnami-docker-spark/issues
   
    05:17:56.98 
   C
   C.UTF-8
   POSIX
   ```
   This container doesn't support `zh_CN.utf-8`.
   And the kingbase container(`huzhihui/kingbase:v8r6`) locale `en_US.UTF-8`.


-- 
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-unsubscr...@seatunnel.apache.org

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