|
22.11.2013, 21:08:20
#38474970
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
|
|
|
|
Доброго времени суток!
Возникает такая ошибка:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
ноя 22, 2013 5:31:07 PM org.apache.catalina.core.ApplicationDispatcher invoke
SEVERE: Servlet.service() for servlet jsp threw exception
javax.servlet.ServletException: File "/jsp/TableScheduleShow.jsp" not found
at org.apache.jasper.servlet.JspServlet.handleMissingResource(JspServlet.java:412)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:379)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
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.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)
at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954)
at org.apache.jsp.index_jsp._jspService(index_jsp.java:79)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
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.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
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:953)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:722)
Сначала вылетала на строчке: forward(request,response)потом на пул соединении к бд(при инициализации). Потом ради интереса создал новый проект, дак даже в пустом выдает эту же ошибку! Дайте направление, куда идти!(желательно не отсылать на иностранные статьи)
на всякий приведу кода Сервлета TABLECHEDULE:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
package servlets;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.StringTokenizer;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.naming.NamingException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import mylib.ConnectionBD;
import mylib.TableScheduleField;
public class TableSchedule extends HttpServlet {
ConnectionBD conbBD,conBD2;
mylib.TableScheduleField ListShedule = null;
int les1 = 0;
int les2 = 0;
String url="index.jsp";
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {}
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String type = "";
String ShowType= "";
String ShowLine,query;
request.setCharacterEncoding("windows-1251");
ShowType = request.getParameter("showtype");
ShowLine = request.getParameter("showline");
type = request.getParameter("type");
request.removeAttribute("showtype");
request.removeAttribute("type");
request.removeAttribute("showline");
massivShift rowdata= new massivShift();
if((type.equals("show"))&&(ShowType.equals("teacher"))){
// Таблица просмотра расписания Учитель
ResultSet Rs=null;
Statement St = null;
StringTokenizer fio = new StringTokenizer(TeacherSurname(ShowLine), " ");
query = "";
query = query.concat("SELECT idk,idp,idkb,numles,numgroup FROM restricsys,(SELECT idS as s FROM staff WHERE surname = '");
query = query.concat(fio.nextToken().trim() + "' and name LIKE '"+
fio.nextToken().trim()+ "%' and otch LIKE '"+fio.nextToken().trim() +
"%') as ts WHERE restricsys.ids = ts.s ORDER BY numles asc");
try {
conbBD = new ConnectionBD();
St = conbBD.CreatePool().createStatement();
Rs = St.executeQuery(query);
} catch (SQLException ex) {Logger.getLogger(TableSchedule.class.getName()).log(Level.SEVERE, null, ex); } catch (NamingException ex) {
Logger.getLogger(TableSchedule.class.getName()).log(Level.SEVERE, null, ex);
}
ListShedule = new TableScheduleField(9, 6, ShowLine);
ListShedule.SetType(type);
ListShedule.SetShowType(ShowType);
try {
while(Rs.next()){
rowdata.Setidk(Rs.getInt("idk"));
rowdata.Setidp(Rs.getInt("idp"));
rowdata.Setidkb(Rs.getInt("idkb"));
rowdata.Setnumles(Rs.getInt("numles"));
rowdata.Setnumgroup(Rs.getInt("numgroup"));
//Поиск передвижек
ResultSet Rsp = null;
Statement Stp = null;
conBD2 = new ConnectionBD();
Stp = conBD2.CreatePool().createStatement();
query = "";
query = query.concat("SELECT lesson1, lesson2 FROM shift WHERE idk =");
query = query.concat(rowdata.idk + " and (lesson1 = "+ rowdata.numles + " or lesson2 = "+
rowdata.numles + ") and datepr = now()");
Rsp = Stp.executeQuery(query);
boolean flag = false;
while(Rsp.next()){
les1 = Rsp.getInt("lesson1");
les2 = Rsp.getInt("lesson2");
flag=true;
}
conBD2.ClosePool(Rsp, Stp);
if(flag){
//Найдена передвижка, замена
int Shiftlesson = 0;
if(rowdata.numles == les1) Shiftlesson = les2;
if(rowdata.numles == les2) Shiftlesson = les1;
rowdata.Setnumles(Shiftlesson);
}
CreateTeacherFieldSchedule(rowdata, ShowLine);
}
} catch (SQLException ex) { Logger.getLogger(TableSchedule.class.getName()).log(Level.SEVERE, null, ex); } catch (NamingException ex) {
Logger.getLogger(TableSchedule.class.getName()).log(Level.SEVERE, null, ex);
}
finally{conbBD.ClosePool(Rs, St);}
conbBD.ClosePool(Rs, St);
request.setAttribute("type","show");
request.setAttribute("data",ListShedule);
url="index.jsp";
}
RequestDispatcher rd = request.getRequestDispatcher(url);
if(rd != null)
rd.forward(request, response);
}
@Override
public String getServletInfo() {return "Short description";}
}
Класс ConnectionDB:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
package mylib;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
public class ConnectionBD {
// Компоненты соединения с БД
private Connection jdbcConn;
public ConnectionBD() throws SQLException, NamingException{
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/SchoolServer");
if (ds != null)
jdbcConn = ds.getConnection();
}
public Connection CreatePool(){
return jdbcConn;
}
public void ClosePool(ResultSet Rs,Statement St){
try {
if(Rs != null){
Rs.close();
Rs=null;
}
} catch (SQLException ex) {
Logger.getLogger(ConnectionBD.class.getName()).log(Level.SEVERE, null, ex);
}
try {
if(St != null){
St.close();
St = null;
}
} catch (SQLException ex) {
Logger.getLogger(ConnectionBD.class.getName()).log(Level.SEVERE, null, ex);
}
try {
if(jdbcConn != null){
jdbcConn.close();
jdbcConn = null;
}
} catch (SQLException ex) {Logger.getLogger(ConnectionBD.class.getName()).log(Level.SEVERE, null, ex);}
}
public void CloseConnection(ResultSet Rs,Statement St){
try {
Rs.close();
Rs=null;
} catch (SQLException ex) {
Logger.getLogger(ConnectionBD.class.getName()).log(Level.SEVERE, null, ex);
}
try {
St.close();
St = null;
} catch (SQLException ex) {
Logger.getLogger(ConnectionBD.class.getName()).log(Level.SEVERE, null, ex);
}
try {
jdbcConn.close();
} catch (SQLException ex) {Logger.getLogger(ConnectionBD.class.getName()).log(Level.SEVERE, null, ex);}
jdbcConn = null;
}
}
Прошу помочь!( |
|
|
