【mysql5.1.47会报一个时间戳设置未null的错】

有你安然陶醉

已于 2022-11-22 13:10:10 修改

阅读量354

点赞数

文章标签： mybatis java spring mysql hibernate

于 2022-11-22 11:06:27 首次发布

本文链接：https://blog.csdn.net/m0_57190670/article/details/127978824

版权

使用 Hikari代理数据源 mysql会报一个时间戳设置未null的错 报错日志如下：
/**
 * 
 * java.lang.NullPointerException: null
 *     at com.mysql.jdbc.PreparedStatement.setTimestamp(PreparedStatement.java:4241) ~[mysql-connector-java-5.1.47.jar:5.1.47]
 *     at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.setTimestamp(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.1.jar:na]
 *     at io.seata.rm.datasource.AbstractPreparedStatementProxy.setTimestamp(AbstractPreparedStatementProxy.java:202) ~[seata-all-0.9.0.jar:0.9.0]
 *     at org.apache.ibatis.type.DateTypeHandler.setNonNullParameter(DateTypeHandler.java:33) ~[mybatis-3.5.2.jar:3.5.2]
 *     at org.apache.ibatis.type.DateTypeHandler.setNonNullParameter(DateTypeHandler.java:28) ~[mybatis-3.5.2.jar:3.5.2]
 *     at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHxzzandler.java:69) ~[mybatis-3.5.2.jar:3.5.2]
 *     at com.baomidou.mybatisplus.core.MybatisDefaultParameterHandler.setParameters(MybatisDefaultParameterHandler.java:228) ~[mybatis-plus-core-3.2.0.jar:3.2.0]
 *     at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:94) ~[mybatis-3.5.2.jar:3.5.2]
 *     at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:64) ~[mybatis-3.5.2.jar:3.5.2]
 *     at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.prepareStatement(MybatisSimpleExecutor.java:99) ~[mybatis-plus-core-3.2.0.jar:3.2.0]
 *     at com.baomidou.mybatisplus.core.executor.MybatisSimpleExecutor.doUpdate(MybatisSimpleExecutor.java:53) ~[mybatis-plus-core-3.2.0.jar:3.2.0]
 *     at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) ~[mybatis-3.5.2.jar:3.5.2]
 *     at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) ~[mybatis-3.5.2.jar:3.5.2]
 *     at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197) ~[mybatis-3.5.2.jar:3.5.2]
 *     at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184) ~[mybatis-3.5.2.jar:3.5.2]
 *     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_131]
 *     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_131]
 *     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_131]
 *     at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_131]
 *     at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426) ~[mybatis-spring-2.0.2.jar:2.0.2]
 *     at com.sun.proxy.$Proxy99.insert(Unknown Source) ~[na:na]
 *     at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:271) ~[mybatis-spring-2.0.2.jar:2.0.2]
 *     at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:58) ~[mybatis-plus-core-3.2.0.jar:3.2.0]
 *     at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:61) ~[mybatis-plus-core-3.2.0.jar:3.2.0]
 *     at com.sun.proxy.$Proxy100.insert(Unknown Source) ~[na:na]

追踪代码到:

public void setTimestamp(int parameterIndex, Timestamp x) throws java.sql.SQLException {
    synchronized (checkClosed().getConnectionMutex()) {
        int fractLen = -1;
        if (!this.sendFractionalSeconds || !this.serverSupportsFracSecs) {
            fractLen = 0;
        } else if (this.parameterMetaData != null && parameterIndex <= this.parameterMetaData.metadata.fields.length && parameterIndex >= 0) {
            fractLen = this.parameterMetaData.metadata.getField(parameterIndex).getDecimals();
        }

        setTimestampInternal(parameterIndex, x, null, this.connection.getDefaultTimeZone(), false, fractLen,
                this.connection.getUseSSPSCompatibleTimezoneShift());
    }

会发现metadata是null

解决方案:

将mysql降级到5.1.35