View Old Forum Thread

Old Forum Index » Baseball Beta Testing » Beta News » Beta Apache Tomcat Error

CaseyStengel

---

Beta Apache Tomcat Error

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.

CaseyStengel

---

February 16, 2011 at 02:14AM View formatted

This error occurs when trying to see my Minor League Players.
[quote]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[/quote]

lvnwrth

---

February 16, 2011 at 04:59AM View BBCode

Same thing if you try to check the waiver wire.