![](images/header_16_5a-smaller.jpg)
![](images/mitt_only2.jpg)
February 16, 2011 at 02:12AM View BBCode
I get this message when attempting to set my pitching rotation.HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 171 in the jsp file: /top_headnew.jsp
query cannot be resolved
168: }
169: }
170: if(myteamsrefresh == null) { // get from DB
171: query="select * from teamowner, owner, team, league where team_active >= 1 and teamowner_active = 1 and teamowner_owner_id = owner_id and team_league_id = league_id and owner_id ='"+username+"' AND team_id=teamowner_team_id and league_defunct = 0 order by teamowner_displayorder";
172: Connection confb = DriverManager.getConnection(fbconnstring, fbdbusername, fbdbpassword);
173: Statement stmtfb = confb.createStatement();
174: ResultSet rsetfb = stmtfb.executeQuery(query);
An error occurred at line: 174 in the jsp file: /top_headnew.jsp
query cannot be resolved
171: query="select * from teamowner, owner, team, league where team_active >= 1 and teamowner_active = 1 and teamowner_owner_id = owner_id and team_league_id = league_id and owner_id ='"+username+"' AND team_id=teamowner_team_id and league_defunct = 0 order by teamowner_displayorder";
172: Connection confb = DriverManager.getConnection(fbconnstring, fbdbusername, fbdbpassword);
173: Statement stmtfb = confb.createStatement();
174: ResultSet rsetfb = stmtfb.executeQuery(query);
175: while(rsetfb.next()) {
176: String leagueabbr = "";
177: String leaguename = rsetfb.getString("league_name").toUpperCase();
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:439)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:349)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:327)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:314)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:592)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.29 logs.
February 16, 2011 at 02:14AM View BBCode
This error occurs when trying to see my Minor League Players.HTTP Status 500 -
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 171 in the jsp file: /top_headnew.jsp
query cannot be resolved
168: }
169: }
170: if(myteamsrefresh == null) { // get from DB
171: query="select * from teamowner, owner, team, league where team_active >= 1 and teamowner_active = 1 and teamowner_owner_id = owner_id and team_league_id = league_id and owner_id ='"+username+"' AND team_id=teamowner_team_id and league_defunct = 0 order by teamowner_displayorder";
172: Connection confb = DriverManager.getConnection(fbconnstring, fbdbusername, fbdbpassword);
173: Statement stmtfb = confb.createStatement();
174: ResultSet rsetfb = stmtfb.executeQuery(query);
An error occurred at line: 174 in the jsp file: /top_headnew.jsp
query cannot be resolved
171: query="select * from teamowner, owner, team, league where team_active >= 1 and teamowner_active = 1 and teamowner_owner_id = owner_id and team_league_id = league_id and owner_id ='"+username+"' AND team_id=teamowner_team_id and league_defunct = 0 order by teamowner_displayorder";
172: Connection confb = DriverManager.getConnection(fbconnstring, fbdbusername, fbdbpassword);
173: Statement stmtfb = confb.createStatement();
174: ResultSet rsetfb = stmtfb.executeQuery(query);
175: while(rsetfb.next()) {
176: String leagueabbr = "";
177: String leaguename = rsetfb.getString("league_name").toUpperCase();
Stacktrace:
org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:92)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:330)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:439)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:349)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:327)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:314)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:592)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:317)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.29 logs.
Apache Tomcat/6.0.29
Pages: 1