换成oracle数据库 角色管理的时候报违反协议,mybatisplus主键自增不起作用

提问 3 1644
杨杨杨
杨杨杨 2018-07-24
版本:renren-fast 1.2.1 开发环境:谷歌63
img[//cdn.renren.io/71906201807241022202018.png]
回帖
  • 杨杨杨
    杨杨杨 (楼主)
    2018-07-24
    [pre] 2018-07-24 09:59:14.134 DEBUG 840 --- [io-8080-exec-10] i.r.m.sys.dao.SysRoleMenuDao.insert : ==> Preparing: INSERT INTO sys_role_menu ( role_id, menu_id ) VALUES ( ?, ? ) 2018-07-24 09:59:14.137 DEBUG 840 --- [io-8080-exec-10] i.r.m.sys.dao.SysRoleMenuDao.insert : ==> Parameters: 123(Integer), 2(Integer) 2018-07-24 09:59:14.138 DEBUG 840 --- [io-8080-exec-10] i.r.m.sys.dao.SysRoleMenuDao.insert : ==> Parameters: 123(Integer), 15(Integer) 2018-07-24 09:59:14.139 DEBUG 840 --- [io-8080-exec-10] i.r.m.sys.dao.SysRoleMenuDao.insert : ==> Parameters: 123(Integer), 16(Integer) 2018-07-24 09:59:14.139 DEBUG 840 --- [io-8080-exec-10] i.r.m.sys.dao.SysRoleMenuDao.insert : ==> Parameters: 123(Integer), 17(Integer) 2018-07-24 09:59:14.139 DEBUG 840 --- [io-8080-exec-10] i.r.m.sys.dao.SysRoleMenuDao.insert : ==> Parameters: 123(Integer), 18(Integer) 2018-07-24 09:59:14.140 DEBUG 840 --- [io-8080-exec-10] i.r.m.sys.dao.SysRoleMenuDao.insert : ==> Parameters: 123(Integer), 1(Integer) 2018-07-24 09:59:14.169 ERROR 840 --- [io-8080-exec-10] com.alibaba.druid.util.JdbcUtils : close connection error java.sql.SQLException: 违反协议 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208) at oracle.jdbc.driver.T4C7Ocommoncall.receive(T4C7Ocommoncall.java:150) at oracle.jdbc.driver.T4CConnection.logoff(T4CConnection.java:465) at oracle.jdbc.driver.PhysicalConnection.close(PhysicalConnection.java:1203) at com.alibaba.druid.filter.FilterChainImpl.connection_close(FilterChainImpl.java:186) at com.alibaba.druid.filter.stat.StatFilter.connection_close(StatFilter.java:261) at com.alibaba.druid.filter.FilterChainImpl.connection_close(FilterChainImpl.java:181) at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.close(ConnectionProxyImpl.java:115) at com.alibaba.druid.util.JdbcUtils.close(JdbcUtils.java:73) at com.alibaba.druid.pool.DruidDataSource.discardConnection(DruidDataSource.java:1340) at com.alibaba.druid.pool.DruidDataSource.handleFatalError(DruidDataSource.java:1598) at com.alibaba.druid.pool.DruidDataSource.handleConnectionException(DruidDataSource.java:1540) at com.alibaba.druid.pool.DruidPooledConnection.handleException(DruidPooledConnection.java:133) at com.alibaba.druid.pool.DruidPooledConnection.rollback(DruidPooledConnection.java:783) at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:344) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:838) at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:812) at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:550) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:298) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) at io.renren.modules.sys.service.impl.SysRoleServiceImpl$$EnhancerBySpringCGLIB$$c85bab1e.save(<generated>) at io.renren.modules.sys.controller.SysRoleController.save(SysRoleController.java:92) at io.renren.modules.sys.controller.SysRoleController$$FastClassBySpringCGLIB$$93656f3b.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:88) at io.renren.common.aspect.SysLogAspect.around(SysLogAspect.java:46) 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.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:644) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:633) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:174) at org.apache.shiro.spring.security.interceptor.AopAllianceAnnotationsAuthorizingMethodInterceptor$1.proceed(AopAllianceAnnotationsAuthorizingMethodInterceptor.java:82) at org.apache.shiro.authz.aop.AuthorizingMethodInterceptor.invoke(AuthorizingMethodInterceptor.java:39) at org.apache.shiro.spring.security.interceptor.AopAllianceAnnotationsAuthorizingMethodInterceptor.invoke(AopAllianceAnnotationsAuthorizingMethodInterceptor.java:115) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) at io.renren.modules.sys.controller.SysRoleController$$EnhancerBySpringCGLIB$$bce1d408.save(<generated>) at io.renren.modules.sys.controller.SysRoleController$$FastClassBySpringCGLIB$$93656f3b.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.apache.shiro.spring.security.interceptor.AopAllianceAnnotationsAuthorizingMethodInterceptor$1.proceed(AopAllianceAnnotationsAuthorizingMethodInterceptor.java:82) at org.apache.shiro.authz.aop.AuthorizingMethodInterceptor.invoke(AuthorizingMethodInterceptor.java:39) at org.apache.shiro.spring.security.interceptor.AopAllianceAnnotationsAuthorizingMethodInterceptor.invoke(AopAllianceAnnotationsAuthorizingMethodInterceptor.java:115) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688) at io.renren.modules.sys.controller.SysRoleController$$EnhancerBySpringCGLIB$$7ef9b188.save(<generated>) 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:209) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:877) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:783) [/pre]
    0 回复
  • 杨杨杨
    杨杨杨 (楼主)
    2018-07-24
    求大神解答face[可怜] 谢谢谢谢
    0 回复
  • @杨杨杨 修改 id-type: 2,如下: [pre] mybatis-plus: mapper-locations: classpath*:mapper/**/*.xml #实体扫描,多个package用逗号或者分号分隔 typeAliasesPackage: io.renren.modules.*.entity global-config: #主键类型 0:"数据库ID自增", 1:"用户输入ID",2:"全局唯一ID (数字类型唯一ID)", 3:"全局唯一ID UUID"; id-type: 2 [/pre]
    0 回复