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/06/04 03:53:38 UTC

[I] seata 1.6.1 Client Oracle指定schema不生效 [incubator-seata]

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

   ### Check Ahead
   
   - [x] I have searched the [issues](https://github.com/seata/seata/issues) of this repository and believe that this is not a duplicate.
   
   
   ### Ⅰ. Issue Description
   
   版本信息:
   Seata版本 1.6.1(My SQL DB)
   Client端DB:Oracle 11g
   后端框架:SpringBoot 2.6.13
   持久层:MybatisPlus 3.5.6
   JDK:1.8
   
   Client端(OracleDB)使用的username为:defschema, 需要访问的schema为:difchema
   
   麻烦确认一下seata 1.6.1 Client 是否支援Oracle DB配置与Username不同的Schema?
   实际相关代码:
   
   ![Image](https://github.com/user-attachments/assets/7333bf2a-3642-4fb7-b7ab-4213ac28ec78)
   
   实体类注解:
   
   ![Image](https://github.com/user-attachments/assets/9a1a0630-1aff-48a5-8306-f9705f1c5aef)
   
   MybatisPlus配置:
   
   ```
   mybatis-plus:
     global-config:
       enable-sql-runner: true
       db-config:
         table-prefix: difschema.
   ```
   
   SQL代码:
   
   ![Image](https://github.com/user-attachments/assets/6efe787b-9808-448d-9a28-b7009a7184b9)
   
   测试表结构:
   ```
   CREATE TABLE "DIFSCHEMA"."ACCOUNT_TABLE" 
      (	"ACCOUNT_ID" NUMBER NOT NULL ENABLE, 
   	"USER_ID" VARCHAR2(50) NOT NULL ENABLE, 
   	"BALANCE" NUMBER(10,2) DEFAULT NULL NOT NULL ENABLE, 
   	"CREATE_TIME" TIMESTAMP (6) DEFAULT NULL NOT NULL ENABLE, 
   	 CONSTRAINT "SYS_C0052270" PRIMARY KEY ("ACCOUNT_ID", "CREATE_TIME")
     USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
     STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
     PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
     BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
     TABLESPACE "REAL_T"  ENABLE
      ) SEGMENT CREATION IMMEDIATE 
     PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
   NOCOMPRESS LOGGING
     STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
     PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
     BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
     TABLESPACE "REAL_T" ;
    
   CREATE OR REPLACE TRIGGER "DIFSCHEMA"."ACCOUNT_TRIG" BEFORE INSERT ON "DIFSCHEMA"."ACCOUNT_TABLE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW 
   BEGIN
       SELECT account_seq.NEXTVAL INTO :NEW.account_id FROM DUAL;
   END;
   ALTER TRIGGER "DIFSCHEMA"."ACCOUNT_TRIG" DISABLE
   ```
   
   完整堆栈信息:
   不使用Seata:
   ```
   2025-06-04 11:18:33.052 [SW_CTX: N/A] [http-nio-8007-exec-1] INFO  o.a.c.c.C.[Tomcat].[localhost].[/] -Initializing Spring DispatcherServlet 'dispatcherServlet'
   2025-06-04 11:18:33.053 [SW_CTX: N/A] [http-nio-8007-exec-1] INFO  o.s.web.servlet.DispatcherServlet -Initializing Servlet 'dispatcherServlet'
   2025-06-04 11:18:33.053 [SW_CTX: N/A] [http-nio-8007-exec-1] INFO  o.s.web.servlet.DispatcherServlet -Completed initialization in 0 ms
   Creating a new SqlSession
   SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7ee8bfe] was not registered for synchronization because synchronization is not active
   JDBC Connection [oracle.jdbc.driver.T4CConnection@e1bbf45] will not be managed by Spring
   ==>  Preparing: SELECT ACCOUNT_ID,USER_ID,BALANCE,CREATE_TIME FROM difschema.ACCOUNT_TABLE WHERE (USER_ID = ?)
   ==> Parameters: user1(String)
   <==    Columns: ACCOUNT_ID, USER_ID, BALANCE, CREATE_TIME
   <==        Row: 1, user1, 0.95, 2025-04-18 19:16:37
   <==      Total: 1
   Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7ee8bfe]
   Creating a new SqlSession
   SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7fcaab16] was not registered for synchronization because synchronization is not active
   JDBC Connection [oracle.jdbc.driver.T4CConnection@e1bbf45] will not be managed by Spring
   ==>  Preparing: UPDATE difschema.ACCOUNT_TABLE SET ACCOUNT_ID=?, USER_ID=?, BALANCE=?, CREATE_TIME=? WHERE (ACCOUNT_ID = ?)
   ==> Parameters: 1(BigDecimal), user1(String), 0.94(BigDecimal), 2025-04-18T19:16:37(LocalDateTime), 1(BigDecimal)
   <==    Updates: 1
   Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7fcaab16]
   2025-06-04 11:18:33.591 [SW_CTX: N/A] [http-nio-8007-exec-1] INFO  c.a.s.impl.AccountTableServiceImpl -更新成功,影响行数:1
   ```
   使用Seata
   ```
   Creating a new SqlSession
   SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6bfa971a] was not registered for synchronization because synchronization is not active
   JDBC Connection [io.seata.rm.datasource.ConnectionProxy@212fe986] will not be managed by Spring
   ==>  Preparing: SELECT ACCOUNT_ID,USER_ID,BALANCE,CREATE_TIME FROM difschema.ACCOUNT_TABLE WHERE (USER_ID = ?)
   ==> Parameters: user1(String)
   <==    Columns: ACCOUNT_ID, USER_ID, BALANCE, CREATE_TIME
   <==        Row: 1, user1, 0.94, 2025-04-18 19:16:37
   <==      Total: 1
   Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6bfa971a]
   Creating a new SqlSession
   SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@390f6156] was not registered for synchronization because synchronization is not active
   JDBC Connection [io.seata.rm.datasource.ConnectionProxy@1579b962] will not be managed by Spring
   ==>  Preparing: UPDATE difschema.ACCOUNT_TABLE SET ACCOUNT_ID=?, USER_ID=?, BALANCE=?, CREATE_TIME=? WHERE (ACCOUNT_ID = ?)
   ==> Parameters: 1(BigDecimal), user1(String), 0.93(BigDecimal), 2025-04-18T19:16:37(LocalDateTime), 1(BigDecimal)
   2025-06-04 11:19:16.153 [SW_CTX: N/A] [http-nio-8007-exec-2] WARN  i.s.c.l.EnhancedServiceLoader$InnerEnhancedServiceLoader -Load [io.seata.rm.datasource.undo.parser.ProtostuffUndoLogParser] class fail. io/protostuff/runtime/IdStrategy
   2025-06-04 11:19:16.254 [SW_CTX: N/A] [http-nio-8007-exec-2] ERROR i.s.rm.datasource.ConnectionProxy -process connectionProxy commit error: ORA-00942: 表或视图不存在
   
   java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
   
   	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630)
   	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)
   	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151)
   	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771)
   	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
   	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498)
   	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:152)
   	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1052)
   	at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1531)
   	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311)
   	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3746)
   	at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3918)
   	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3897)
   	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:992)
   	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:255)
   	at io.seata.rm.datasource.undo.oracle.OracleUndoLogManager.insertUndoLog(OracleUndoLogManager.java:92)
   	at io.seata.rm.datasource.undo.oracle.OracleUndoLogManager.insertUndoLogWithNormal(OracleUndoLogManager.java:74)
   	at io.seata.rm.datasource.undo.AbstractUndoLogManager.flushUndoLogs(AbstractUndoLogManager.java:245)
   	at io.seata.rm.datasource.ConnectionProxy.processGlobalTransactionCommit(ConnectionProxy.java:255)
   	at io.seata.rm.datasource.ConnectionProxy.doCommit(ConnectionProxy.java:230)
   	at io.seata.rm.datasource.ConnectionProxy.lambda$commit$0(ConnectionProxy.java:188)
   	at io.seata.rm.datasource.ConnectionProxy$LockRetryPolicy.execute(ConnectionProxy.java:344)
   	at io.seata.rm.datasource.ConnectionProxy.commit(ConnectionProxy.java:187)
   	at io.seata.rm.datasource.exec.AbstractDMLBaseExecutor.lambda$executeAutoCommitTrue$2(AbstractDMLBaseExecutor.java:138)
   	at io.seata.rm.datasource.ConnectionProxy$LockRetryPolicy.doRetryOnLockConflict(ConnectionProxy.java:356)
   	at io.seata.rm.datasource.exec.AbstractDMLBaseExecutor$LockRetryPolicy.execute(AbstractDMLBaseExecutor.java:180)
   	at io.seata.rm.datasource.exec.AbstractDMLBaseExecutor.executeAutoCommitTrue(AbstractDMLBaseExecutor.java:136)
   	at io.seata.rm.datasource.exec.AbstractDMLBaseExecutor.doExecute(AbstractDMLBaseExecutor.java:82)
   	at io.seata.rm.datasource.exec.BaseTransactionalExecutor.execute(BaseTransactionalExecutor.java:125)
   	at io.seata.rm.datasource.exec.ExecuteTemplate.execute(ExecuteTemplate.java:137)
   	at io.seata.rm.datasource.exec.ExecuteTemplate.execute(ExecuteTemplate.java:56)
   	at io.seata.rm.datasource.PreparedStatementProxy.execute(PreparedStatementProxy.java:55)
   	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   	at java.lang.reflect.Method.invoke(Method.java:498)
   	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:58)
   	at com.sun.proxy.$Proxy169.execute(Unknown Source)
   	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:48)
   	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:75)
   	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
   	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
   	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
   	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
   	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   	at java.lang.reflect.Method.invoke(Method.java:498)
   	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
   	at com.sun.proxy.$Proxy115.update(Unknown Source)
   	at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:288)
   	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:64)
   	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152)
   	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
   	at com.sun.proxy.$Proxy123.update(Unknown Source)
   	at com.auo.service.impl.AccountTableServiceImpl.reduceByUser(AccountTableServiceImpl.java:74)
   	at com.auo.service.impl.AccountTableServiceImpl$$FastClassBySpringCGLIB$$cc15e1df.invoke(<generated>)
   	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
   	at org.springframework.aop.framework.CglibAopProxy.invokeMethod(CglibAopProxy.java:386)
   	at org.springframework.aop.framework.CglibAopProxy.access$000(CglibAopProxy.java:85)
   	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:704)
   	at com.auo.service.impl.AccountTableServiceImpl$$EnhancerBySpringCGLIB$$4bc44499.reduceByUser(<generated>)
   	at com.auo.controller.AccountTableController.reduceByUser(AccountTableController.java:55)
   	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   	at java.lang.reflect.Method.invoke(Method.java:498)
   	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
   	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
   	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
   	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
   	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
   	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
   	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071)
   	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964)
   	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
   	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
   	at javax.servlet.http.HttpServlet.service(HttpServlet.java:696)
   	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
   	at javax.servlet.http.HttpServlet.service(HttpServlet.java:779)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
   	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
   	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
   	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
   	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
   	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
   	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
   	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
   	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
   	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
   	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
   	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
   	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
   	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)
   	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
   	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
   	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
   	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
   	at java.lang.Thread.run(Thread.java:748)
   Caused by: oracle.jdbc.OracleDatabaseException: ORA-00942: 表或视图不存在
   
   	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
   	... 112 common frames omitted
   2025-06-04 11:19:16.261 [SW_CTX: N/A] [http-nio-8007-exec-2] ERROR i.s.r.d.exec.AbstractDMLBaseExecutor -execute executeAutoCommitTrue error:java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
   
   java.sql.SQLException: java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
   
   	at io.seata.rm.datasource.ConnectionProxy.processGlobalTransactionCommit(ConnectionProxy.java:260)
   	at io.seata.rm.datasource.ConnectionProxy.doCommit(ConnectionProxy.java:230)
   	at io.seata.rm.datasource.ConnectionProxy.lambda$commit$0(ConnectionProxy.java:188)
   	at io.seata.rm.datasource.ConnectionProxy$LockRetryPolicy.execute(ConnectionProxy.java:344)
   	at io.seata.rm.datasource.ConnectionProxy.commit(ConnectionProxy.java:187)
   	at io.seata.rm.datasource.exec.AbstractDMLBaseExecutor.lambda$executeAutoCommitTrue$2(AbstractDMLBaseExecutor.java:138)
   	at io.seata.rm.datasource.ConnectionProxy$LockRetryPolicy.doRetryOnLockConflict(ConnectionProxy.java:356)
   	at io.seata.rm.datasource.exec.AbstractDMLBaseExecutor$LockRetryPolicy.execute(AbstractDMLBaseExecutor.java:180)
   	at io.seata.rm.datasource.exec.AbstractDMLBaseExecutor.executeAutoCommitTrue(AbstractDMLBaseExecutor.java:136)
   	at io.seata.rm.datasource.exec.AbstractDMLBaseExecutor.doExecute(AbstractDMLBaseExecutor.java:82)
   	at io.seata.rm.datasource.exec.BaseTransactionalExecutor.execute(BaseTransactionalExecutor.java:125)
   	at io.seata.rm.datasource.exec.ExecuteTemplate.execute(ExecuteTemplate.java:137)
   	at io.seata.rm.datasource.exec.ExecuteTemplate.execute(ExecuteTemplate.java:56)
   	at io.seata.rm.datasource.PreparedStatementProxy.execute(PreparedStatementProxy.java:55)
   	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   	at java.lang.reflect.Method.invoke(Method.java:498)
   	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:58)
   	at com.sun.proxy.$Proxy169.execute(Unknown Source)
   	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:48)
   	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:75)
   	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
   	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
   	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
   	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
   	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   	at java.lang.reflect.Method.invoke(Method.java:498)
   	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
   	at com.sun.proxy.$Proxy115.update(Unknown Source)
   	at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:288)
   	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:64)
   	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152)
   	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
   	at com.sun.proxy.$Proxy123.update(Unknown Source)
   	at com.auo.service.impl.AccountTableServiceImpl.reduceByUser(AccountTableServiceImpl.java:74)
   	at com.auo.service.impl.AccountTableServiceImpl$$FastClassBySpringCGLIB$$cc15e1df.invoke(<generated>)
   	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
   	at org.springframework.aop.framework.CglibAopProxy.invokeMethod(CglibAopProxy.java:386)
   	at org.springframework.aop.framework.CglibAopProxy.access$000(CglibAopProxy.java:85)
   	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:704)
   	at com.auo.service.impl.AccountTableServiceImpl$$EnhancerBySpringCGLIB$$4bc44499.reduceByUser(<generated>)
   	at com.auo.controller.AccountTableController.reduceByUser(AccountTableController.java:55)
   	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   	at java.lang.reflect.Method.invoke(Method.java:498)
   	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
   	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
   	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
   	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
   	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
   	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
   	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071)
   	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964)
   	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
   	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
   	at javax.servlet.http.HttpServlet.service(HttpServlet.java:696)
   	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
   	at javax.servlet.http.HttpServlet.service(HttpServlet.java:779)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
   	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
   	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
   	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
   	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
   	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
   	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
   	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
   	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
   	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
   	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
   	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
   	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
   	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)
   	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
   	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
   	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
   	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
   	at java.lang.Thread.run(Thread.java:748)
   Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
   
   	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630)
   	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)
   	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151)
   	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771)
   	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
   	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498)
   	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:152)
   	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1052)
   	at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1531)
   	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311)
   	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3746)
   	at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3918)
   	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3897)
   	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:992)
   	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:255)
   	at io.seata.rm.datasource.undo.oracle.OracleUndoLogManager.insertUndoLog(OracleUndoLogManager.java:92)
   	at io.seata.rm.datasource.undo.oracle.OracleUndoLogManager.insertUndoLogWithNormal(OracleUndoLogManager.java:74)
   	at io.seata.rm.datasource.undo.AbstractUndoLogManager.flushUndoLogs(AbstractUndoLogManager.java:245)
   	at io.seata.rm.datasource.ConnectionProxy.processGlobalTransactionCommit(ConnectionProxy.java:255)
   	... 94 common frames omitted
   Caused by: oracle.jdbc.OracleDatabaseException: ORA-00942: 表或视图不存在
   
   	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
   	... 112 common frames omitted
   Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@390f6156]
   2025-06-04 11:19:16.321 [SW_CTX: N/A] [http-nio-8007-exec-2] ERROR o.a.c.c.C.[.[.[.[dispatcherServlet] -Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.jdbc.BadSqlGrammarException: 
   ### Error updating database.  Cause: java.sql.SQLException: java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
   
   ### The error may exist in com/auo/mapper/AccountTableMapper.java (best guess)
   ### The error may involve com.auo.mapper.AccountTableMapper.update-Inline
   ### The error occurred while setting parameters
   ### SQL: UPDATE difschema.ACCOUNT_TABLE  SET ACCOUNT_ID=?, USER_ID=?, BALANCE=?, CREATE_TIME=?       WHERE  (ACCOUNT_ID = ?)
   ### Cause: java.sql.SQLException: java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
   
   ; bad SQL grammar []; nested exception is java.sql.SQLException: java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
   ] with root cause
   oracle.jdbc.OracleDatabaseException: ORA-00942: 表或视图不存在
   
   	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
   	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)
   	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1151)
   	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:771)
   	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
   	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:498)
   	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:152)
   	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1052)
   	at oracle.jdbc.driver.OracleStatement.executeSQLStatement(OracleStatement.java:1531)
   	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1311)
   	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3746)
   	at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3918)
   	at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3897)
   	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:992)
   	at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:255)
   	at io.seata.rm.datasource.undo.oracle.OracleUndoLogManager.insertUndoLog(OracleUndoLogManager.java:92)
   	at io.seata.rm.datasource.undo.oracle.OracleUndoLogManager.insertUndoLogWithNormal(OracleUndoLogManager.java:74)
   	at io.seata.rm.datasource.undo.AbstractUndoLogManager.flushUndoLogs(AbstractUndoLogManager.java:245)
   	at io.seata.rm.datasource.ConnectionProxy.processGlobalTransactionCommit(ConnectionProxy.java:255)
   	at io.seata.rm.datasource.ConnectionProxy.doCommit(ConnectionProxy.java:230)
   	at io.seata.rm.datasource.ConnectionProxy.lambda$commit$0(ConnectionProxy.java:188)
   	at io.seata.rm.datasource.ConnectionProxy$LockRetryPolicy.execute(ConnectionProxy.java:344)
   	at io.seata.rm.datasource.ConnectionProxy.commit(ConnectionProxy.java:187)
   	at io.seata.rm.datasource.exec.AbstractDMLBaseExecutor.lambda$executeAutoCommitTrue$2(AbstractDMLBaseExecutor.java:138)
   	at io.seata.rm.datasource.ConnectionProxy$LockRetryPolicy.doRetryOnLockConflict(ConnectionProxy.java:356)
   	at io.seata.rm.datasource.exec.AbstractDMLBaseExecutor$LockRetryPolicy.execute(AbstractDMLBaseExecutor.java:180)
   	at io.seata.rm.datasource.exec.AbstractDMLBaseExecutor.executeAutoCommitTrue(AbstractDMLBaseExecutor.java:136)
   	at io.seata.rm.datasource.exec.AbstractDMLBaseExecutor.doExecute(AbstractDMLBaseExecutor.java:82)
   	at io.seata.rm.datasource.exec.BaseTransactionalExecutor.execute(BaseTransactionalExecutor.java:125)
   	at io.seata.rm.datasource.exec.ExecuteTemplate.execute(ExecuteTemplate.java:137)
   	at io.seata.rm.datasource.exec.ExecuteTemplate.execute(ExecuteTemplate.java:56)
   	at io.seata.rm.datasource.PreparedStatementProxy.execute(PreparedStatementProxy.java:55)
   	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   	at java.lang.reflect.Method.invoke(Method.java:498)
   	at org.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:58)
   	at com.sun.proxy.$Proxy169.execute(Unknown Source)
   	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:48)
   	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:75)
   	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
   	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
   	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
   	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
   	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   	at java.lang.reflect.Method.invoke(Method.java:498)
   	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:425)
   	at com.sun.proxy.$Proxy115.update(Unknown Source)
   	at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:288)
   	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:64)
   	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:152)
   	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
   	at com.sun.proxy.$Proxy123.update(Unknown Source)
   	at com.auo.service.impl.AccountTableServiceImpl.reduceByUser(AccountTableServiceImpl.java:74)
   	at com.auo.service.impl.AccountTableServiceImpl$$FastClassBySpringCGLIB$$cc15e1df.invoke(<generated>)
   	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
   	at org.springframework.aop.framework.CglibAopProxy.invokeMethod(CglibAopProxy.java:386)
   	at org.springframework.aop.framework.CglibAopProxy.access$000(CglibAopProxy.java:85)
   	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:704)
   	at com.auo.service.impl.AccountTableServiceImpl$$EnhancerBySpringCGLIB$$4bc44499.reduceByUser(<generated>)
   	at com.auo.controller.AccountTableController.reduceByUser(AccountTableController.java:55)
   	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   	at java.lang.reflect.Method.invoke(Method.java:498)
   	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
   	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)
   	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)
   	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
   	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)
   	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
   	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1071)
   	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:964)
   	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
   	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
   	at javax.servlet.http.HttpServlet.service(HttpServlet.java:696)
   	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
   	at javax.servlet.http.HttpServlet.service(HttpServlet.java:779)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
   	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
   	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
   	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)
   	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
   	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
   	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
   	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
   	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
   	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
   	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
   	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
   	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:360)
   	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:399)
   	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
   	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
   	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1789)
   	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
   	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
   	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
   	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
   	at java.lang.Thread.run(Thread.java:748)
   ```
   
   
   ### Ⅱ. Describe what happened
   
   _No response_
   
   ### Ⅲ. Describe what you expected to happen
   
   _No response_
   
   ### Ⅳ. How to reproduce it (as minimally and precisely as possible)
   
   _No response_
   
   ### Ⅴ. Anything else we need to know?
   
   _No response_
   
   ### Ⅵ. Environment
   
   _No response_


-- 
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 Client Oracle指定schema不生效 [incubator-seata]

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

   > > 从堆栈信息看是插入undoLog表失败,需要确认当前连接的库是否有undoLog表,跨schema的访问本身是支持的。
   > > From the stack information, it seems that the insertion into the undoLog table failed. You need to confirm whether the currently connected DB has an undoLog table. Cross-schema access is supported.
   > 
   > 有undo_log表,但是只在difschema中有,默认登陆的DB的defschema下是没有的。需要在defschema 下创建吗?无法使用difschema里的undo_log的吗?
   
   是的,undolog记录只在当前连接的schema插入
   
   Right, undolog records are only inserted in the currently connected schema.


-- 
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 Client Oracle指定schema不生效 [incubator-seata]

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

   > 从堆栈信息看是插入undoLog表失败,需要确认当前连接的库是否有undoLog表,跨schema的访问本身是支持的。
   > 
   > From the stack information, it seems that the insertion into the undoLog table failed. You need to confirm whether the currently connected DB has an undoLog table. Cross-schema access is supported.
   
   有undo_log表,但是只在difschema中有,默认登陆的DB的defschema下是没有的。需要在defschema 下创建吗?无法使用difschema里的undo_log的吗? 


-- 
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 Client Oracle指定schema不生效 [incubator-seata]

Posted by "funky-eyes (via GitHub)" <gi...@apache.org>.
funky-eyes closed issue #7410: seata 1.6.1 Client Oracle指定schema不生效
URL: https://github.com/apache/incubator-seata/issues/7410


-- 
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 Client Oracle指定schema不生效 [incubator-seata]

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

   从堆栈信息看是插入undoLog表失败,需要确认当前连接的库是否有undoLog表,跨schema的访问本身是支持的。
   
   From the stack information, it seems that the insertion into the undoLog table failed. You need to confirm whether the currently connected DB has an undoLog table. Cross-schema access is supported.


-- 
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