You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@seata.apache.org by "tbUoky (via GitHub)" <gi...@apache.org> on 2025/04/03 08:55:24 UTC

[I] seata 1.6.1 MP批量Insert 不支持（Client DB：Oracle 11g） [incubator-seata]

tbUoky opened a new issue, #7268:
URL: https://github.com/apache/incubator-seata/issues/7268

   版本信息：
     Seata版本 1.6.1(My SQL DB)
     Client端DB：Oracle 11g
     后端框架：SpringBoot 2.6.13
     持久层：MybatisPlus 3.5.6
     JDK：1.8
    
   目前使用仅单笔insert能回滚（PS：使用MP的批量insert方法，无法执行，报错Cause: java.sql.SQLException: Error…registerReturnParamsForAutoKey）
   测试过写INSERT ALL INTO，能执行，不能回滚
    
   请教一下是否已经有哪个版本支持使用MP自带的Insert方法，批量Insert可执行，可回滚？（Client：Oracle DB）
   
   以下是两种情况的详细说明
   
   1. MP insert 无法正常执行
   ![Image](https://github.com/user-attachments/assets/3afd4758-828a-457c-b323-c03138e12120)
   
   ![Image](https://github.com/user-attachments/assets/7e8625ca-fc00-46ed-bd0f-b9941aaddfc5)
   
   2. MP 使用insert into all SQL
   
   ![Image](https://github.com/user-attachments/assets/a368ba16-219e-49e5-81a0-9ea24cc8d675)
   有seata的日志，显示will not be managed by Spring
   ![Image](https://github.com/user-attachments/assets/7605c3e8-f896-42ab-948d-67e466c40896)
   但debug时，并没有写入Undo_log表&seata回滚后，数据未回滚
   日志显示Rollbacked
   ![Image](https://github.com/user-attachments/assets/ab234703-889d-431e-8b95-c3f8551670e6)
   
   ![Image](https://github.com/user-attachments/assets/551100ba-e1a0-414a-a168-90f07c2f2706)
   
   麻烦解答一下，十分感谢！


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For additional commands, e-mail: notifications-help@seata.apache.org

Re: [I] seata 1.6.1 MP批量Insert 不支持（Client DB：Oracle 11g） [incubator-seata]

Posted by "tbUoky (via GitHub)" <gi...@apache.org>.
tbUoky commented on issue #7268:
URL: https://github.com/apache/incubator-seata/issues/7268#issuecomment-2809431624

   > 你可以下，理论上会通过sql获取尝试主键值。 你可以尝试一下；理论上，Seata会通过SQL检索主键值。
   
   我试过了，虽然我的主键是自行设定的，不是使用Oracle的主键递增策略，但还是一样的报错，还是 registerReturnParamsForAutoKey 相关的报错


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For additional commands, e-mail: notifications-help@seata.apache.org

Re: [I] seata 1.6.1 MP批量Insert 不支持（Client DB：Oracle 11g） [incubator-seata]

Posted by "funky-eyes (via GitHub)" <gi...@apache.org>.
funky-eyes commented on issue #7268:
URL: https://github.com/apache/incubator-seata/issues/7268#issuecomment-2775457256

   savebatch 无法获取准确的自增主键，所以无法支持
   至于你说rollbacked时没有回滚，请看官网 faq排查分支是否注册


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For additional commands, e-mail: notifications-help@seata.apache.org

Re: [I] seata 1.6.1 MP批量Insert 不支持（Client DB：Oracle 11g） [incubator-seata]

Posted by "funky-eyes (via GitHub)" <gi...@apache.org>.
funky-eyes commented on issue #7268:
URL: https://github.com/apache/incubator-seata/issues/7268#issuecomment-2803482145

   你可以尝试下，理论上会通过sql获取主键值。
   You can give it a try; theoretically, Seata will retrieve the primary key value through SQL.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For additional commands, e-mail: notifications-help@seata.apache.org

Re: [I] seata 1.6.1 MP批量Insert 不支持（Client DB：Oracle 11g） [incubator-seata]

Posted by "tbUoky (via GitHub)" <gi...@apache.org>.
tbUoky commented on issue #7268:
URL: https://github.com/apache/incubator-seata/issues/7268#issuecomment-2775646031

   > savebatch无法获取准确的自增主键，所以无法支持​​至于你说回滚时没有回滚，请看官网faq排查分支是否注册
   Client DB为 11g， 没有使用自增主键，也没有触发器的情况下，可以支持MP 批量Insert吗？


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For additional commands, e-mail: notifications-help@seata.apache.org