Mogdb版本:MogDB 5.0.0,使用Docker容器部署。
创建B兼容性数据库,使用mysql5.7 命令行工具连接正常。但在Java代码中,使用mysql-connector-java-8.0.30版本连接无法正常执行SQL预计,提示:
Caused by: java.lang.NullPointerException
at com.mysql.cj.NativeSession.queryServerVariable(NativeSession.java:603) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:1394) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.mysql.cj.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:1387) ~[mysql-connector-java-8.0.30.jar:8.0.30]
at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:463) ~[druid-1.2.9.jar:1.2.9]
at com.alibaba.druid.filter.FilterAdapter.connection_isReadOnly(FilterAdapter.java:894) ~[druid-1.2.9.jar:1.2.9]
at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:459) ~[druid-1.2.9.jar:1.2.9]
at com.alibaba.druid.filter.FilterAdapter.connection_isReadOnly(FilterAdapter.java:894) ~[druid-1.2.9.jar:1.2.9]
at com.alibaba.druid.filter.FilterChainImpl.connection_isReadOnly(FilterChainImpl.java:459) ~[druid-1.2.9.jar:1.2.9]
at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.isReadOnly(ConnectionProxyImpl.java:291) ~[druid-1.2.9.jar:1.2.9]
at com.alibaba.druid.pool.DruidConnectionHolder.<init>(DruidConnectionHolder.java:143) ~[druid-1.2.9.jar:1.2.9]
at com.alibaba.druid.pool.DruidConnectionHolder.<init>(DruidConnectionHolder.java:81) ~[druid-1.2.9.jar:1.2.9]
……
数据库连接参数:
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://172.xx.xx.xxx:13308/xxxx
jdbc.username=xxx
同时DBeaver 24.2.2版本使用mysql模式连接数据库无法正常查看数据库信息,使用Mogeaver 23.1.1可正常查看数据库信息,正常加载数据库表数据。
求教各位大佬!!
墨值悬赏

评论

