ganti :
Class.forName( "com.mysql. jdbc.Driver" ).newInstance( );
jadi:
Class.forName( "com.mysql. jdbc.Driver" );
--- On Mon, 1/14/08, rh4gh13lz <[EMAIL PROTECTED]> wrote:
From: rh4gh13lz <[EMAIL PROTECTED]>
Subject: [ITCENTER] Tanya Koneksi MySQL pakai JSP
To: itcenter@yahoogroups.com
Date: Monday, January 14, 2008, 7:20
Dear all,
Langsung aja dech ke pertanyaan, saya lagi test bikin web dengan menggunakan
JSP & MySQL, step2 yang udah dilakukan.
1. Yang pasti mah Install Tomcat & MySQL
2. Tambahin mysql connector (C:\Program Files\Apache Software
Foundation\Tomcat 5.5\common\lib\ mysql-connector- java-5.1. 5-bin.jar)
3. Setting CLASSPATH buat mysql connector seperti di no. 2.
4. Bikin Code seperti dibawah ini :
<%@ page import="java. sql.*" %>
<%
String connectionURL =
"jdbc:mysql://localhost: 3306/verificatio n?user=root; password= root";
Connection connection = null;
Statement statement = null;
ResultSet rs = null;
%>
<html><body>
<%
Class.forName( "com.mysql. jdbc.Driver" ).newInstance( );
connection = DriverManager. getConnection( connectionURL, "", "");
statement = connection.createSt atement() ;
rs = statement.executeQu ery("SELECT nama FROM test");
String nama = null;
while (rs.next()) {
nama = rs.getString( "nama");
out.println( rs.getString( "nama")+" <br>");
}
rs.close();
%>
</body></html>
Lalu pas code tersebut dieksekusi di browser, muncul error seperti ini :
*type* Exception report
*message*
*description* *The server encountered an internal error () that prevented it
from fulfilling this request.*
*exception*
org.apache.jasper. JasperException: Exception in JSP: /test.jsp:12
9: <html><body>
10:
11: <%
12: Class.forName( "com.mysql. jdbc.Driver" ).newInstance( );
13: connection = DriverManager. getConnection( connectionURL, "", "");
14: statement = connection.createSt atement() ;
15: rs = statement.executeQu ery("SELECT nama FROM test");
Stacktrace:
org.apache.jasper. servlet.JspServl etWrapper. handleJspExcepti
on(JspServletWra pper.java: 451)
org.apache.jasper. servlet.JspServl etWrapper. service(JspServl etWrapper.
java:355)
org.apache.jasper. servlet.JspServl et.serviceJspFil e(JspServlet. java:329)
org.apache.jasper. servlet.JspServl et.service( JspServlet. java:265)
javax.servlet. http.HttpServlet .service( HttpServlet. java:803)
*root cause*
javax.servlet. ServletException : com.mysql.jdbc. Driver
org.apache.jasper. runtime.PageCont extImpl.doHandle PageException(
PageContextImpl. java:841)
org.apache.jasper. runtime.PageCont extImpl.handlePa geException(
PageContextImpl. java:774)
org.apache.jsp. test_jsp. _jspService( test_jsp. java:76)
org.apache.jasper. runtime.HttpJspB ase.service( HttpJspBase. java:98)
javax.servlet. http.HttpServlet .service( HttpServlet. java:803)
org.apache.jasper. servlet.JspServl etWrapper. service(JspServl etWrapper.
java:331)
org.apache.jasper. servlet.JspServl et.serviceJspFil e(JspServlet. java:329)
org.apache.jasper. servlet.JspServl et.service( JspServlet. java:265)
javax.servlet. http.HttpServlet .service( HttpServlet. java:803)
*root cause*
java.lang.ClassNotF oundException: com.mysql.jdbc. Driver
org.apache.catalina .loader.WebappCl assLoader. loadClass( WebappClassLoade
r.java:1362)
org.apache.catalina .loader.WebappCl assLoader. loadClass( WebappClassLoade
r.java:1208)
org.apache.jasper. servlet.JasperLo ader.loadClass( JasperLoader. java:125)
org.apache.jasper. servlet.JasperLo ader.loadClass( JasperLoader. java:63)
java.lang.ClassLoad er.loadClassInte rnal(Unknown Source)
java.lang.Class. forName0( Native Method)
java.lang.Class. forName(Unknown Source)
org.apache.jsp. test_jsp. _jspService( test_jsp. java:56)
org.apache.jasper. runtime.HttpJspB ase.service( HttpJspBase. java:98)
javax.servlet. http.HttpServlet .service( HttpServlet. java:803)
org.apache.jasper. servlet.JspServl etWrapper. service(JspServl etWrapper.
java:331)
org.apache.jasper. servlet.JspServl et.serviceJspFil e(JspServlet. java:329)
org.apache.jasper. servlet.JspServl et.service( JspServlet. java:265)
javax.servlet. http.HttpServlet .service( HttpServlet. java:803)
*note* *The full stack trace of the root cause is available in the Apache
Tomcat/5.5.25 logs.*
Dimohonkan bantuannya dari rekan2 sekalian, atas bantuannya, saya ucapkan
terima kasih.
Regard,
Ragil
[Non-text portions of this message have been removed]
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
--
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia
Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
