jsp页面 HTTP Status 500这啥问题

Question

type Exception report
message 
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in conf/ibatis/Radius_SqlMap.xml.  
--- The error occurred while applying a parameter map.  
--- Check the radius.p_usesrname.  
--- Check the statement (update procedure failed).  
--- Cause: java.sql.SQLException: ORA-06550: 第 1 行, 第 7 列: 
PLS-00201: 必须声明标识符 'UPDATERELATERADINFOBYUSERNAME'
ORA-06550: 第 1 行, 第 7 列: 
PL/SQL: Statement ignored    org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:515)
    org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:419)root cause
org.springframework.jdbc.BadSqlGrammarException: SqlMapClient operation; bad SQL grammar []; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in conf/ibatis/Radius_SqlMap.xml.  
--- The error occurred while applying a parameter map.  
--- Check the radius.p_usesrname.  
--- Check the statement (update procedure failed).  
--- Cause: java.sql.SQLException: ORA-06550: 第 1 行, 第 7 列: 
PLS-00201: 必须声明标识符 'UPDATERELATERADINFOBYUSERNAME'
ORA-06550: 第 1 行, 第 7 列: 
PL/SQL: Statement ignored    org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:107)
    org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:276)
    org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:191)
    org.springframework.orm.ibatis.SqlMapClientTemplate.queryForObject(SqlMapClientTemplate.java:236)
    com.poson.daopub.database.impl.PublicDAOImpl.callProcedureBySqlMapId(PublicDAOImpl.java:301)
    radius.service.busi.UserstService.updaterUserRelateInfo(UserstService.java:105)
    radius.service.busi.UserstService.updateUserst(UserstService.java:128)
    radius.service.busi.UserstService.updateUserst(UserstService.java:132)
    radius.service.busi.UserstService$$FastClassByCGLIB$$d32450f9.invoke(<generated>)
    net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
    org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:714)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:162)
    org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
    org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
    
——————————————————————————————————————————————
root cause
com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in conf/ibatis/Radius_SqlMap.xml.  
--- The error occurred while applying a parameter map.  
--- Check the radius.p_usesrname.  
--- Check the statement (update procedure failed).  
--- Cause: java.sql.SQLException: ORA-06550: 第 1 行, 第 7 列: 
PLS-00201: 必须声明标识符 'UPDATERELATERADINFOBYUSERNAME'
ORA-06550: 第 1 行, 第 7 列: 
PL/SQL: Statement ignored——————————————————————————————————————————————————
com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
    com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
    com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
    org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:170)
    com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
    com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
    com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
    com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:123)
    com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
    com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
    com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
    com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
    com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
    com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
    com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
    com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
    org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:50)
    org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:504)
    org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:419)note The full stack trace of the root cause is available in the Apache Tomcat/6.0.26 logs.Apache Tomcat/6.0.26
谢谢高手了

Answer 1

java.sql.SQLException: ORA-06550: 第 1 行, 第 7 列:  sql语句错误。。

Answer 2

看看查询的sql语句是否有问题！

Answer 3

错误信息写的很清楚了啊，第 1 行, 第 7 列的SQL语句出错，建议将你的SQL语句直接拷到数据库中去运行一下

Answer 4

是你的sql语句的问题，检查下

Answer 5

先确保sql 没问题了在用java操作

Answer 6

 
有可能 之前出这个问题都是重新安装下oracle就行了 这两天重新安装oracle也不管用了，，，sql语句什么的我就没改啊

Answer 7

自己搞定了 还是数据库问题 重新安装了三遍oracle 就好了