当前使用版本(必填,否则不予处理)
v 3.5.2
该问题是如何引起的？(确定最新版也有问题再提!!!)
经过反复测试, mybatis-plus似乎对于id字段会固定放到insert语句中,不管字段是否为null, 也不管insertStrategy设置成什么都一样,也不管tableid设置成什么,其他字段不会, 因为本来mybatis-plus不支持SAP HANA ID自增, 那么我希望通过将id设置为null的方式,让mybatis-plus生成insert语句的时候不要包含id字段,但最终发现mybatis-plus不管如何都会在insert语句中加上id这个字段,而SAP HANA又不允许对自增字段插入内容, 这下尴尬了:
- SAP不允许对自增ID插入内容.
- Mybatis-plus又会对ID这个字符自动添加到insert语句中.
- 试过唯有将TableField(exists=false), 这样插入的时候不会插入ID, 但是Select的时候又不会查询该字段.
我可以理解id这个字段是个特别的字段, 但是不是主键不应该是我用@TableID来标识么? MyBatis-plus为什么要特别处理ID这个字段名?这样就丧失了系统的灵活性.
重现步骤(如果有就写完整)
报错信息
Caused by: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [406]: INSERT, UPDATE and UPSERT are disallowed on the generated field: cannot insert into generated identity column field ID: line 1 col 30 (at pos 29)
at com.sap.db.jdbc.exceptions.SQLExceptionSapDB._newInstance(SQLExceptionSapDB.java:209)
at com.sap.db.jdbc.exceptions.SQLExceptionSapDB.newInstance(SQLExceptionSapDB.java:42)
at com.sap.db.jdbc.packet.HReplyPacket._buildExceptionChain(HReplyPacket.java:841)
at com.sap.db.jdbc.packet.HReplyPacket.getSQLExceptionChain(HReplyPacket.java:195)
at com.sap.db.jdbc.packet.HPartInfo.getSQLExceptionChain(HPartInfo.java:39)
at com.sap.db.jdbc.ConnectionSapDB._receive(ConnectionSapDB.java:4901)
at com.sap.db.jdbc.ConnectionSapDB.exchange(ConnectionSapDB.java:2026)
at com.sap.db.jdbc.PreparedStatementSapDB._prepare(PreparedStatementSapDB.java:2961)
at com.sap.db.jdbc.PreparedStatementSapDB._doParse(PreparedStatementSapDB.java:2854)
at com.sap.db.jdbc.PreparedStatementSapDB.(PreparedStatementSapDB.java:166)
at com.sap.db.jdbc.PreparedStatementSapDB9.(Unknown Source)
at com.sap.db.jdbc.HanaPreparedStatement.(Unknown Source)
at com.sap.db.jdbc.HanaPreparedStatementClean.(Unknown Source)
at com.sap.db.jdbc.HanaPreparedStatementClean.newInstance(Unknown Source)
at com.sap.db.jdbc.ConnectionSapDB9._prepareStatement(Unknown Source)
at com.sap.db.jdbc.ConnectionSapDB.prepareStatement(ConnectionSapDB.java:369)
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:572)
at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:930)
at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122)
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:568)
at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:341)
at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:351)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogger.java:55)
at com.sun.proxy.$Proxy182.prepareStatement(Unknown Source)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86)
at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:83)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy181.prepare(Unknown Source)
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:87)
at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:83)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
at com.sun.proxy.$Proxy180.update(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
... 90 more
Comment From: miemieYaho
你的entity的id难道用的int类型而不是Integer?
Comment From: tonysmz
我当然用的是Integer, 但是Mybatis-plus还是会给它一个值,而且这个值是超出Integer范围的, 如下, 这个ID字段在实体类中是null, 但在Mybatis-plus生成SQL插入数据库的时候,依然给了它一个值1540237890110394369,如果id被当成一个普通字段来处理的话,在insert的字段中不应该出现ID字段,更不应该出现这个值才对.
SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@579d9fdb] was not registered for synchronization because synchronization is not active
JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@12de2ca] will not be managed by Spring
==> Preparing: INSERT INTO errorcode ( id, codeType, errorCode, errorName ) VALUES ( ?, ?, ?, ? )
==> Parameters: 1540237890110394369(Long), TONY(String), A023(String), smzdgmail(String)
Comment From: miemieYaho
TableId 注解指定 type=auto
Comment From: tonysmz
准确的来讲,看起来Mybatis-plus对于ID这个字段, 即使没有指定@TableID,注解, 也会默认它的类型为ASSIGN_ID(源自全局配置中的DbConfig.idType), 给它指定一个值.
Comment From: miemieYaho
然后呢
Comment From: llanc
我遇到了相似的问题，
@TableId(value = "id", type = IdType.ASSIGN_UUID)
private String id;
insertStrategy为not_null 在save时即使id为null 也会被生成UUID
Comment From: qmdx
SAP 问题这边无法处理，欢迎分享你的解决办法 PR 暂时关闭