Results 1 to 1 of 1
- 04-20-2011, 04:07 PM #1
Member
- Join Date
- Mar 2010
- Posts
- 26
- Rep Power
- 0
SQLException caught:No data found
hi
i am trying to use database in servlet..in the following program i am receiving an error
SQLException caught:No data found
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class DBPhoneLookup extends HttpServlet{
public void doGet(HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException
{
Connection con=null;
Statement stmt= null;
ResultSet rs = null;
res.setContentType("text/html");
PrintWriter out=res.getWriter();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:Access");
stmt=con.createStatement();
rs=stmt.executeQuery("SELECT NAME,ADDRESS FROM CUSTOMER");
out.println("<HTML><HEAD><TITLE>PhoneBook</TITLE></HEAD>");
out.println("<BODY>");
out.println("<UL>");
while (rs.next()){
out.println("<LI>"+rs.getString("NAME")+" " +rs.getString("address"));
}
out.println("</ul>");
out.println("</body></html>");
}
catch(ClassNotFoundException e)
{
out.println("Couldn't load database driver:"+e.getMessage());
}
catch(SQLException e)
{
out.println("SQLException caught:"+ e.getMessage());
}
finally{
try{
if(con!=null)con.close();
}
catch(SQLException e1)
{
}
}
}
}
please help
Similar Threads
-
SQLException caught: Communications link failure due to underlying exception: **
By sharanya in forum JavaServer Pages (JSP) and JSTLReplies: 0Last Post: 02-25-2011, 09:46 AM -
SQLException caught: Access denied for user 'root'@'localhost' (using password: YES)
By sharanya in forum JavaServer Pages (JSP) and JSTLReplies: 3Last Post: 02-18-2011, 11:31 AM -
SQLException:java.sql.Exception:Data type mismatch in criteria expresion
By Dumisan in forum JDBCReplies: 6Last Post: 02-21-2010, 12:54 AM -
data.txt not found
By RedSix in forum EclipseReplies: 4Last Post: 04-23-2009, 02:43 AM -
Error: java.lang.InterruptedException is not caught and does not appear...
By fernando in forum Advanced JavaReplies: 1Last Post: 07-31-2007, 05:52 AM


LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks