参考文章
https://blog.csdn.net/weixin_46359306/article/details/125045252
https://blog.csdn.net/weixin_46359306/article/details/125150284
遇到了问题描述:
在源数据库时间正常,但是通过Clickhouse-JDBC-Bridge 迁移到clickhouse之后时间就莫名其妙加了8小时,没办法去把github上的源码pull下来看源码,原来是要加个配置
{
"$schema": "../../../../../docker/config/datasource.jschema",
"myoracle": {
"converter": {
"timezone":"GTM+8",
"driverUrls": ["/data/clickhouse-jdbc-bridge/drivers/oracle"],
"driverClassName": "oracle.jdbc.driver.OracleDriver",
"jdbcUrl": "jdbc:oracle:thin:@localhost:1521/orclpdb1",
"username": "nanchang",
"password": "nanchang",
"connectionTestQuery":"",
"initializationFailTimeout": 0,
"minimumIdle": 0,
"maximumPoolSize": 10
}
}
过程很复杂,分析源码,反复测试,最终发现还有个隐藏的java时区的配置。是反复看了源码,最终猜出来的。
当然也是下段配置得到线索,最终通过代码加了那个配置。测试正常了!
"converter": {
"mappings": [{ "nativeType": "TIMESTAMP", "toType": "String" },
{ "nativeType": "DATE", "toType": "String" }]
},
github源码地址:
https://github.com/guishijin/clickhouse-jdbc-bridge