ZhangchengHu0923 edited a comment on issue #844:
URL:
https://github.com/apache/incubator-seatunnel/issues/844#issuecomment-1061596017
# need attention for Jack1007
@Jack1007 Hi Jack,I have done some test, and it confirmed that the timeout
config wouldn't work in config1, and config2 is the right way, u can do a test
urself, by the way, my source database is Clickhouse
```
-- config 1
jdbc:mysql://localhost:3306/test?connectTimeout=10000&socketTimeout=10000
-- config 2
jdbc:mysql://localhost:3306/test?connect_timeout=10000&socket_timeout=10000
```
# Easy way to config
don't be surprise, this is exactly the easy way u like, I haven't changed
any code, but review the code of spark-jdbc-source plugin, guessing that
connect_timeout/socket_timeout is no-special configuration, and our code has
already handled them, I have done enough test to confirm the guess and the
configuration below.
@Jack1007 @garyelephant @CalvinKirs @leo65535
```
source {
jdbc {
driver = "ru.yandex.clickhouse.ClickHouseDriver"
url = "jdbc:clickhouse://192.168.1.111:8123/test"
table = "st_source_date"
result_table_name = "SOURCE_VIEW"
user = "..."
password = "..."
jdbc.partitionColumn = "age"
jdbc.numPartitions = "10"
jdbc.lowerBound = 0
jdbc.upperBound = 100
jdbc.connect_timeout = 10000
jdbc.socket_timeout = 10000
}
}
```
# todo
record the way to config connect_timeout/socket_timeout to the doc will be
helpful, I'm handling this
@garyelephant @CalvinKirs @leo65535
--
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]
