Salve mi chiamo Roberto e sto iniziando a scrivere pagine JSP, attualmente il problema più grosso è la connessione con il database access, problema che in un script java non ho. L'ho implementato in questo modo che segue, ma mi da l'errore che ho evidenziato, potete aiutarmi.

saluti Roberto

<%@ page import = “ java.io.*, java.util.*, java.sql.*” %>


<body>
<%


Connection conn = null;
Statement stmt;
ResultSet rslt;
ResultSetMetaData rsmd;

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newI nstance();
conn=DriverManager.getConnection("jdbcdbc:;Driver={Microsoft Access Driver (*.mdb)};DBQ=dbAccess.mdb");

stmt=conn.createStatement();
rslt= stmt.executeQuery("SELECT * FROM tabellAccess;");
rsmd= rslt.getMetaData();
String dat=null;

while(rslt.next()){
//ottiene il dato
dat = rslt.getString("nome");
//stampa a video
out.println(dat);
}
%>

</body>

ERRORE :

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: An exception occurred processing JSP page /ConnessioneAccess.jsp at line 20

17: ResultSetMetaData rsmd;
18:
19: Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newI nstance();
20: conn=DriverManager.getConnection("jdbcdbc:;Driver={Microsoft Access Driver (*.mdb)};DBQ=dbAccess.mdb");
21:
22: stmt=conn.createStatement();
23: rslt= stmt.executeQuery("SELECT * FROM tabellAccess;");


Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
root cause
javax.servlet.ServletException: java.sql.SQLException: [Microsoft][Driver ODBC Microsoft Access] Impossibile trovare il file "(sconosciuto)".
org.apache.jasper.runtime.PageContextImpl.doHandle PageException(PageContextImpl.java:852)
org.apache.jasper.runtime.PageContextImpl.handlePa geException(PageContextImpl.java:781)
org.apache.jsp.ConnessioneAccess_jsp._jspService(C onnessioneAccess_jsp.java:97)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
root cause
java.sql.SQLException: [Microsoft][Driver ODBC Microsoft Access] Impossibile trovare il file "(sconosciuto)".
sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source)
sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknow n Source)
sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
org.apache.jsp.ConnessioneAccess_jsp._jspService(C onnessioneAccess_jsp.java:74)
org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:267)
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.18 logs.