Ciao a tutti...
come mai questa servlet
private void searchInDB(String data, PrintWriter out){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String filename = "C:\\Programmi\\JONAS_4_8_4\\webapps\\autoload\\ca llc\\registrochiamate.mdb";
String database = "jdbcdbc
river={Microsoft Access Driver (*.mdb)};DBQ=";
database+= filename.trim() + ";DriverID=22;READONLY=true}"; // add on to the end
// now we can get the connection from the DriverManager
Connection con = DriverManager.getConnection( database ,"","");
Statement s = con.createStatement();
String query = "select * from Chiamate"; //where quando = '"+data+"'";
System.out.println(query);
s.execute(query);
ResultSet rs = s.getResultSet();
out.println("<html><head><title></title><meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\"><meta name=\"generator\" content" +
"=\"CSE HTML Validator Professional (http://www.htmlvalidator.com/)\"></head><body><table style=\"width: 100%; height: 11px\"><tr><img " +
"src=\"http://intranet:9000/test/images/logo_idealista_it.gif\" /><td colspan=\"3\" style=\"height: 20px; text-align: left\"></td></tr>" +
"<tr><td colspan=\"3\" style=\"text-align: left\" bgcolor=\"#99ff00\">BACK OFFICE TOOLS</td></tr><tr><td style=\"text-align: " +
"center\"><span style=\"font-size: 16pt\">chiamate effettuate
</span></td></tr>");
if (rs != null) // if rs == null, then there is no ResultSet to view
while ( rs.next() ) // this will step through our data row-by-row
{
/* the next line will get the first column in our current row's ResultSet
as a String ( getString( columnNumber) ) and output it to the screen */
//System.out.println("Data from column_name: " + rs.getString(1) + " " + rs.getString(2) + " " + rs.getString(3) );
risultati.add(rs.getString(1));
risultati.add(rs.getString(2));
risultati.add(rs.getString(3));
risultati.add(rs.getString(4));
risultati.add(rs.getString(5));
risultati.add(rs.getString(6));
risultati.add(rs.getString(7));
risultati.add(rs.getString(8));
risultati.add(rs.getString(9));
risultati.add(rs.getString(10));
out.println("ciao");
out.println("<tr><td>"+rs.getString(1)+"</td><td>"+rs.getString(2)+"</td>" +
"<td>"+rs.getString(3)+"</td><td>"+rs.getString(4)+"</td>" +
"<td>"+rs.getString(5)+"</td><td>"+rs.getString(6)+"</td>" +
"<td>"+rs.getString(7)+"</td><td>"+rs.getString(8)+"</td>" +
"<td>"+rs.getString(9)+"</td><td>"+rs.getString(10)+"</td></tr>");
}
out.println("</body></html>");
s.close(); // close the Statement to let the database know we're done with it
con.close(); // close the Connection to let the database know we're done with it
}
catch(Exception e){System.out.println("ERROR: " + e);}
}
...mi dice NO DATA FOUND??? lanciando la stessa query da access correttamente mi restituisce i risultati!
Grazie
Rispondi quotando
mannaggia quanti problemi per una cosa cosi banale!! :master: 
