Before, I can connect database both from applet or
servlet.But today, when I try to connect database from
applet or servlet, there was a problem.
By servlet the error message is : "Couldn't load DB
driver :null".
By applet, in the browser just appear "Connecting to
database ", and in the status bar is a message "Applet
myapplet org/postgresql/jdbc2/Resultset".
Help me please......
The SERVLET code :
import java.io.*;import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class myServlet 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("org.postgresql.Driver"); con =
DriverManager.getConnection("jdbc:postgresql:myDB",
"me", "pass"); stmt = con.createStatement(); rs = stmt.executeQuery("select k_id,
k_name, date
from myTable");
out.println("<HTML><HEAD><TITLE>KAMOKU</TITLE></HEAD>"); out.println("<BODY><FONT
COLOR='RED'><H3><BR>TEST
SERVLET & JDBC</H3><BR></FONT>"); out.println("SELECT id, name, date FROM
kamoku<BR><BR> "); out.println("<UL>"); while(rs.next()){ out.println("<LI>" +
rs.getString("k_id")+" "+
rs.getString("k_name") + " " + rs.getDate("date")); } out.println("<UL>");
out.println("</BODY></HTML>"); } catch(ClassNotFoundException e) { out.println("Couldn't
loadDB driver : " +
e.getMessage()); } catch(SQLException e) { out.println("SQLException caught : " +
e.getMessage()); } finally { try { if (con != null) con.close();
} catch (SQLException ignored) { } } }
}
Thank you.
S.A.Pamungkas
__________________________________________________
Do You Yahoo!?
Kick off your party with Yahoo! Invites.
http://invites.yahoo.com/