You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/12/14 05:08:20 UTC

[GitHub] [shardingsphere] Kimisme opened a new issue #8607: Mybatis's selectKey does not support

Kimisme opened a new issue #8607:
URL: https://github.com/apache/shardingsphere/issues/8607


   Depend on the following
   
   ```
   <dependency>
       <groupId>com.oracle.database.jdbc</groupId>
       <artifactId>ojdbc8</artifactId>
       <version>12.2.0.1</version>
   </dependency>
   <dependency>
       <groupId>org.apache.shardingsphere</groupId>
       <artifactId>shardingsphere-jdbc-core</artifactId>
       <version>5.0.0-alpha</version>
   </dependency>
   ```
   
   **tb_student is a table that does not participate in sharding.**
   
   It can be executed normally (externally incoming ID) in the following ways.
   
   ```xml
   <insert id="insertOK" parameterType="Student">
       insert into TB_STUDENT(
            ID,
            CREATOR_ID,
            UPDATOR_ID,
       )
       values (
            #{id, jdbcType=DECIMAL},
            #{creatorId, jdbcType=DECIMAL},
            #{updatorId, jdbcType=DECIMAL},
       )
   </insert>
   ```
   
   
   Failed to execute in the following way (Mybatis auto-fetch).
   
   ```xml
   <insert id="insertFail" parameterType="Student">
       <selectKey resultType="long" keyProperty="id" order="BEFORE">
           select TB_STUDENT_SEQ.nextval from dual;
       </selectKey>
       insert into TB_STUDENT (
            ID,
            CREATOR_ID,
            UPDATOR_ID,
       )
       values (
            #{id, jdbcType=DECIMAL},
            #{creatorId, jdbcType=DECIMAL},
            #{updatorId, jdbcType=DECIMAL},
       )
   </insert>
   ```
   
   The error is as follows:
   
   ```
   Caused by: org.apache.shardingsphere.infra.exception.ShardingSphereException: Can not route tables for `[DUAL, TB_STUDENT_SEQ]`, please make sure the tables are in same schema.
   	at org.apache.shardingsphere.sharding.route.engine.type.unconfigured.ShardingUnconfiguredTablesRoutingEngine.route(ShardingUnconfiguredTablesRoutingEngine.java:55)
   	at org.apache.shardingsphere.sharding.route.engine.ShardingSQLRouter.createRouteContext(ShardingSQLRouter.java:70)
   	at org.apache.shardingsphere.sharding.route.engine.ShardingSQLRouter.createRouteContext(ShardingSQLRouter.java:55)
   	at org.apache.shardingsphere.infra.route.engine.impl.PartialSQLRouteExecutor.route(PartialSQLRouteExecutor.java:59)
   	at org.apache.shardingsphere.infra.route.engine.SQLRouteEngine.route(SQLRouteEngine.java:57)
   	at org.apache.shardingsphere.infra.context.kernel.KernelProcessor.generateExecutionContext(KernelProcessor.java:52)
   	at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.createExecutionContext(ShardingSpherePreparedStatement.java:266)
   	at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.execute(ShardingSpherePreparedStatement.java:198)
   	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:59)
   	at com.sun.proxy.$Proxy29.execute(Unknown Source)
   	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:62)
   	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78)
   	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
   	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)
   	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)
   	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)
   	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)
   	at org.apache.ibatis.executor.keygen.SelectKeyGenerator.processGeneratedKeys(SelectKeyGenerator.java:68)
   ```
   
   By the way, I can't find the `RC version` in the Maven repository.
   
   ![image](https://user-images.githubusercontent.com/10137968/102041359-3aaddd00-3e0a-11eb-955e-e1ae26d3181d.png)
   


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

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



[GitHub] [shardingsphere] menghaoranss closed issue #8607: Mybatis's selectKey does not support

Posted by GitBox <gi...@apache.org>.
menghaoranss closed issue #8607:
URL: https://github.com/apache/shardingsphere/issues/8607


   


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

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



[GitHub] [shardingsphere] Kimisme edited a comment on issue #8607: Mybatis's selectKey does not support

Posted by GitBox <gi...@apache.org>.
Kimisme edited a comment on issue #8607:
URL: https://github.com/apache/shardingsphere/issues/8607#issuecomment-744250032


   > Please configure `sql.show=true` and print the logic & actual SQL.
   
   ```java
   15:50:27.046 [main] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
   15:50:27.046 [main] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4af12a63] was not registered for synchronization because synchronization is not active
   15:50:27.048 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
   15:50:27.048 [main] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection@22b7ef2b] will not be managed by Spring
   15:50:27.048 [main] DEBUG ServTypeTmp.insert!selectKey - ==>  Preparing: SELECT TB_STUDENT_SEQ.NEXTVAL FROM DUAL 
   15:50:27.054 [main] DEBUG ServTypeTmp.insert!selectKey - ==> Parameters: 
   15:50:32.253 [main] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4af12a63]
   15:50:32.253 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
   Exception in thread "main" org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorException: Error selecting key or setting result to parameter object. Cause: org.apache.shardingsphere.infra.exception.ShardingSphereException: Can not route tables for `[DUAL, TB_STUDENT_SEQ]`, please make sure the tables are in same schema.
   	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
   	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:365)
   	at com.sun.proxy.$Proxy26.insert(Unknown Source)
   	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:237)
   	at com.xxx.mybatis.dao.base.BaseDaoImpl.create(BaseDaoImpl.java:72)
   	at com.xxx.mybatis.dao.ServTypeTmpDAOImpl.createServTypeTmpOK(ServTypeTmpDAOImpl.java:20)
   	at com.xxx.mybatis.ShardingJdbcProgram.main(ShardingJdbcProgram.java:47)
   Caused by: org.apache.ibatis.executor.ExecutorException: Error selecting key or setting result to parameter object. Cause: org.apache.shardingsphere.infra.exception.ShardingSphereException: Can not route tables for `[DUAL, TB_STUDENT_SEQ]`, please make sure the tables are in same schema.
   	at org.apache.ibatis.executor.keygen.SelectKeyGenerator.processGeneratedKeys(SelectKeyGenerator.java:92)
   	at org.apache.ibatis.executor.keygen.SelectKeyGenerator.processBefore(SelectKeyGenerator.java:47)
   	at org.apache.ibatis.executor.statement.BaseStatementHandler.generateKeys(BaseStatementHandler.java:140)
   	at org.apache.ibatis.executor.statement.BaseStatementHandler.<init>(BaseStatementHandler.java:63)
   	at org.apache.ibatis.executor.statement.PreparedStatementHandler.<init>(PreparedStatementHandler.java:39)
   	at org.apache.ibatis.executor.statement.RoutingStatementHandler.<init>(RoutingStatementHandler.java:45)
   	at org.apache.ibatis.session.Configuration.newStatementHandler(Configuration.java:502)
   	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:47)
   	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:115)
   	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
   	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:170)
   	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:157)
   	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:355)
   	... 5 more
   Caused by: org.apache.shardingsphere.infra.exception.ShardingSphereException: Can not route tables for `[DUAL, TB_STUDENT_SEQ]`, please make sure the tables are in same schema.
   	at org.apache.shardingsphere.sharding.route.engine.type.unconfigured.ShardingUnconfiguredTablesRoutingEngine.route(ShardingUnconfiguredTablesRoutingEngine.java:55)
   	at org.apache.shardingsphere.sharding.route.engine.ShardingSQLRouter.createRouteContext(ShardingSQLRouter.java:70)
   	at org.apache.shardingsphere.sharding.route.engine.ShardingSQLRouter.createRouteContext(ShardingSQLRouter.java:55)
   	at org.apache.shardingsphere.infra.route.engine.impl.PartialSQLRouteExecutor.route(PartialSQLRouteExecutor.java:59)
   	at org.apache.shardingsphere.infra.route.engine.SQLRouteEngine.route(SQLRouteEngine.java:57)
   	at org.apache.shardingsphere.infra.context.kernel.KernelProcessor.generateExecutionContext(KernelProcessor.java:52)
   	at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.createExecutionContext(ShardingSpherePreparedStatement.java:266)
   	at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.execute(ShardingSpherePreparedStatement.java:198)
   	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:59)
   	at com.sun.proxy.$Proxy29.execute(Unknown Source)
   	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:62)
   	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78)
   	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
   	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)
   	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)
   	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)
   	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)
   	at org.apache.ibatis.executor.keygen.SelectKeyGenerator.processGeneratedKeys(SelectKeyGenerator.java:68)
   	... 21 more
   ```
   
   thanks @menghaoranss 


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

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



[GitHub] [shardingsphere] menghaoranss commented on issue #8607: Mybatis's selectKey does not support

Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #8607:
URL: https://github.com/apache/shardingsphere/issues/8607#issuecomment-744205617


   Please configure `sql.show=true` and print the logic & actual 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.

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



[GitHub] [shardingsphere] Kimisme commented on issue #8607: Mybatis's selectKey does not support

Posted by GitBox <gi...@apache.org>.
Kimisme commented on issue #8607:
URL: https://github.com/apache/shardingsphere/issues/8607#issuecomment-744250032


   > Please configure `sql.show=true` and print the logic & actual SQL.
   
   ```java
   15:50:27.046 [main] DEBUG org.mybatis.spring.SqlSessionUtils - Creating a new SqlSession
   15:50:27.046 [main] DEBUG org.mybatis.spring.SqlSessionUtils - SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4af12a63] was not registered for synchronization because synchronization is not active
   15:50:27.048 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Fetching JDBC Connection from DataSource
   15:50:27.048 [main] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction - JDBC Connection [org.apache.shardingsphere.driver.jdbc.core.connection.ShardingSphereConnection@22b7ef2b] will not be managed by Spring
   15:50:27.048 [main] DEBUG ServTypeTmp.insert!selectKey - ==>  Preparing: SELECT TB_STUDENT_SEQ.NEXTVAL FROM DUAL 
   15:50:27.054 [main] DEBUG ServTypeTmp.insert!selectKey - ==> Parameters: 
   15:50:32.253 [main] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4af12a63]
   15:50:32.253 [main] DEBUG org.springframework.jdbc.datasource.DataSourceUtils - Returning JDBC Connection to DataSource
   Exception in thread "main" org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorException: Error selecting key or setting result to parameter object. Cause: org.apache.shardingsphere.infra.exception.ShardingSphereException: Can not route tables for `[DUAL, TB_STUDENT_SEQ]`, please make sure the tables are in same schema.
   	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
   	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:365)
   	at com.sun.proxy.$Proxy26.insert(Unknown Source)
   	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:237)
   	at com.xxx.mybatis.dao.base.BaseDaoImpl.create(BaseDaoImpl.java:72)
   	at com.xxx.mybatis.dao.ServTypeTmpDAOImpl.createServTypeTmpOK(ServTypeTmpDAOImpl.java:20)
   	at com.xxx.mybatis.ShardingJdbcProgram.main(ShardingJdbcProgram.java:47)
   Caused by: org.apache.ibatis.executor.ExecutorException: Error selecting key or setting result to parameter object. Cause: org.apache.shardingsphere.infra.exception.ShardingSphereException: Can not route tables for `[DUAL, TB_STUDENT_SEQ]`, please make sure the tables are in same schema.
   	at org.apache.ibatis.executor.keygen.SelectKeyGenerator.processGeneratedKeys(SelectKeyGenerator.java:92)
   	at org.apache.ibatis.executor.keygen.SelectKeyGenerator.processBefore(SelectKeyGenerator.java:47)
   	at org.apache.ibatis.executor.statement.BaseStatementHandler.generateKeys(BaseStatementHandler.java:140)
   	at org.apache.ibatis.executor.statement.BaseStatementHandler.<init>(BaseStatementHandler.java:63)
   	at org.apache.ibatis.executor.statement.PreparedStatementHandler.<init>(PreparedStatementHandler.java:39)
   	at org.apache.ibatis.executor.statement.RoutingStatementHandler.<init>(RoutingStatementHandler.java:45)
   	at org.apache.ibatis.session.Configuration.newStatementHandler(Configuration.java:502)
   	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:47)
   	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:115)
   	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:75)
   	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:170)
   	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:157)
   	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:355)
   	... 5 more
   Caused by: org.apache.shardingsphere.infra.exception.ShardingSphereException: Can not route tables for `[DUAL, TB_STUDENT_SEQ]`, please make sure the tables are in same schema.
   	at org.apache.shardingsphere.sharding.route.engine.type.unconfigured.ShardingUnconfiguredTablesRoutingEngine.route(ShardingUnconfiguredTablesRoutingEngine.java:55)
   	at org.apache.shardingsphere.sharding.route.engine.ShardingSQLRouter.createRouteContext(ShardingSQLRouter.java:70)
   	at org.apache.shardingsphere.sharding.route.engine.ShardingSQLRouter.createRouteContext(ShardingSQLRouter.java:55)
   	at org.apache.shardingsphere.infra.route.engine.impl.PartialSQLRouteExecutor.route(PartialSQLRouteExecutor.java:59)
   	at org.apache.shardingsphere.infra.route.engine.SQLRouteEngine.route(SQLRouteEngine.java:57)
   	at org.apache.shardingsphere.infra.context.kernel.KernelProcessor.generateExecutionContext(KernelProcessor.java:52)
   	at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.createExecutionContext(ShardingSpherePreparedStatement.java:266)
   	at org.apache.shardingsphere.driver.jdbc.core.statement.ShardingSpherePreparedStatement.execute(ShardingSpherePreparedStatement.java:198)
   	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:59)
   	at com.sun.proxy.$Proxy29.execute(Unknown Source)
   	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:62)
   	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:78)
   	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
   	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:303)
   	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:154)
   	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:102)
   	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:82)
   	at org.apache.ibatis.executor.keygen.SelectKeyGenerator.processGeneratedKeys(SelectKeyGenerator.java:68)
   	... 21 more
   ```
   
   thanks


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

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



[GitHub] [shardingsphere] menghaoranss commented on issue #8607: Mybatis's selectKey does not support

Posted by GitBox <gi...@apache.org>.
menghaoranss commented on issue #8607:
URL: https://github.com/apache/shardingsphere/issues/8607#issuecomment-747186337


   Special algorithms are not supported, you can use the distributed key generator provided by shardingsphere.


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

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