ORA-01747: user.table.column, table.column 或列说明无效

   org.springframework.jdbc.BadSqlGrammarException: ### Error updating database.  Cause: java.sql.SQLException: ORA-01747: user.table.column, table.column 或列说明无效### The error may involve dci.smartcity.operationsmanagement.dao.IRoleDAO.add-Inline### The error occurred while setting parameters### SQL: insert   into SYS_SECURITY_ROLE(      ROLE_ID,   ROLE_NAME,   ) values (      ?,   ?,   )### Cause: java.sql.SQLException: ORA-01747: user.table.column, table.column 或列说明无效; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-01747: user.table.column, table.column 或列说明无效	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:98)	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:364)	at $Proxy17.insert(Unknown Source)	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:236)	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:46)	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:43)	at $Proxy19.add(Unknown Source)	at dci.smartcity.operationsmanagement.service.RoleServiceImpl.add(RoleServiceImpl.java:24)	at dci.smartcity.operationsmanagement.service.RoleServiceImpl.add(RoleServiceImpl.java:1)	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:597)	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)	at $Proxy21.add(Unknown Source)	at dci.smartcity.operationsmanagement.business.RoleBizImpl.findTest(RoleBizImpl.java:116)	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:597)	at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167)	at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:344)	at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:296)	at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:285)	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:336)	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:177)	at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:936)	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004)	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)	at java.lang.Thread.run(Thread.java:662)Caused by: java.sql.SQLException: ORA-01747: user.table.column, table.column 或列说明无效
 

文章来源: blog.csdn.net，作者：隔壁老瓦，版权归原作者所有，如需转载，请联系作者。

原文链接：blog.csdn.net/wxb880114/article/details/84442229