Originariamente inviato da Andrea1979
in WEB-INF ci puoi infilare file di configurazione, librerie etc etc specifiche per quella web-app.

org.apache.jasper.JasperException: An exception occurred processing JSP page /ngeocoder.jsp at line 26

23:
24: String querySQL = "";
25: querySQL= "SELECT * from places";
26: ResultSet rs=s.executeQuery(querySQL);
27: String dat= "";
28: while((rs.next())){
29:


Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:568)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:455)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:390)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:334)
javax.servlet.http.HttpServlet.service(HttpServlet .java:728)

root cause

javax.servlet.ServletException: java.sql.SQLException: no such table: places


Ecco un estratto di una guida che fa al caso mio credo...
Now set up your app. If you don't have a META-INF/context.xml file, then create one. This is a minimal file:

<?xml version="1.0" encoding="UTF-8"?>
<Context>
<Resource name="jdbc/db1.db"
auth="Container"
type="javax.sql.DataSource"
driverClassName="org.sqlite.JDBC"
url="jdbc:sqlite:/${catalina.home}/db1.db"
factory="org.apache.tomcat.dbcp.dbcp.BasicDataSour ceFactory">
</Resource>
</Context>

Then add the following to WEB-INF/web.xml:

<resource-ref>
<description>Reviews Database</description>
<res-ref-name>jdbc/db1.db</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

Qualcuno ha qualche indicazione da darmi?