Hi,
My code are below:
================================================================================
public void init() throws ServletException
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc

dbc:tweb";
dbCon = DriverManager.getConnection(url,"larva","larva");
}
catch(ClassNotFoundException e)
{
System.out.println("DB Driver not found");
System.out.println(e.toString());
throw new UnavailableException(this,"Database driver class not found");
}
catch(SQLException e)
{
System.out.println("Error connecting to DB");
System.out.println(e.toString());
throw new UnavailableException(this,"Can't connect to DB");
}
}
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
ResultSet rs;
Statement stmt;
StringBuffer qry = new StringBuffer(1024);
int numCriteria = 0;
String r1;
res.setContentType("text/html");
PrintWriter out = res.getWriter();
String user = req.getParameter("txt_username");
qry.append("SELECT * FROM USERS WHERE NAME = '");
qry.append(user);
qry.append("'");
try
{
stmt = dbCon.createStatement();
rs = stmt.executeQuery(qry.toString());
r1 = rs.getString("LOGON_PASSWORD");
}
catch(SQLException e)
{
res.sendError(res.SC_ACCEPTED, qry.toString());
return;
}
================================================================================
I m connecting to my local Oracle8i DB. I got I following error message:
message : SELECT * FROM USERS WHERE NAME = 'larva'
description :This request was accepted for processing, but has not been completed (SELECT * FROM USERS WHERE NAME = 'larva').
There isn't any for connecting to DB but when executing a query, I receive this stupid message. Please help, Thanks !
regards,
Larva