jdbc连接presto/trino，报错IllegalArgumentException: The datetime zone id ‘GMT+08:00‘ is not recognised

Sivan呀

于 2021-06-16 16:35:44 发布

阅读量5k

点赞数 4

CC 4.0 BY-SA版权

分类专栏：大数据文章标签： presto

本文链接：https://blog.youkuaiyun.com/SivanL/article/details/117961465

使用jdbc连接trino时遇到了一个报错：

java.lang.IllegalArgumentException: The datetime zone id 'GMT+08:00' is not recognised

官方github的issues给出了解决方案：

GMT+08:00 is accepted as a zone identifier by Java Time, but is not accepted by Joda Time, which we use internally for performance reasons.
Please use +08:00 instead.

所以需要在jdbc代码里改变datetime zone，

TimeZone.setDefault(TimeZone.getTimeZone("+08:00"));

附上我的完整代码：

Class.forName("io.trino.jdbc.TrinoDriver");
        TimeZone.setDefault(TimeZone.getTimeZone("+08:00"));
        String url = "jdbc:trino://192.168.2.90:8080";
        Properties properties = new Properties();
        properties.setProperty("user", "trino");
        properties.setProperty("password", "");
//        properties.setProperty("

最低0.47元/天解锁文章