Java Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community Forums > Programming > Java Development
Reload this Page

Problem with connecting JSP with MySQL

Discuss Problem with connecting JSP with MySQL in the Java Development forum on Dev Articles.
Problem with connecting JSP with MySQL Java Development forum discussing Java, JSP, J2ME. Get help with Java and all of its related languages, libraries and variations. If it’s Java-related, you can discuss it here.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old April 3rd, 2007, 11:24 AM
saurabhp22 saurabhp22 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 2 saurabhp22 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 38 m 19 sec
Reputation Power: 0
Unhappy Problem with connecting JSP with MySQL
I want to connect jsp code with MySQL.

I am using Tomcat 4.1 , JRE 1.5 and MySQL 5.0

I am executing the following code:

Code:
<html>


<%@page import="java.sql.* , java.sql.Driver ,javax.naming.*, javax.sql.*" %>
<%
String connectionURL = "jdbc:mysql://localhost:3306/student?user=root & password=root";
Connection connection = null;
Statement statement = null;
ResultSet rs = null;
%>

<body>

<%
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
}catch(ClassNotFoundException e){
	System.out.println("\n CLASS CONNECTION....hehehe\n\n  Error:"+e );
}


try{
connection = DriverManager.getConnection(connectionURL, "", "");
}catch(SQLException e){
	System.out.println("Error:" + e);
}


statement = connection.createStatement();
rs = statement.executeQuery("SELECT * FROM student_registration");

while (rs.next()) {
out.println(rs.getString("name")+"<br>");
}



rs.close();
%>

</body></html>


AND I AM GETTING FOLLOWING ERRORS:

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report


description: The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException
at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:207)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:240)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:809)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:198)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:209)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:595)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:432)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:954)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:138)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:595)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:432)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:954)
at org.apache.catalina.core.StandardContext.invoke(St andardContext.java:2459)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:132)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:595)
at org.apache.catalina.valves.ErrorDispatcherValve.in voke(ErrorDispatcherValve.java:118)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:593)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:116)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:593)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:432)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:954)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:126)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:595)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:432)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:954)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(Co yoteAdapter.java:152)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)


root cause

java.lang.NullPointerException
at org.apache.jsp.project_jsp._jspService(project_jsp .java:68)
at org.apache.jasper.runtime.HttpJspBase.service(Http JspBase.java:92)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:809)
at org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:162)
at org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:240)
at org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:187)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:809)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:198)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:209)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:595)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:432)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:954)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:138)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:595)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:432)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:954)
at org.apache.catalina.core.StandardContext.invoke(St andardContext.java:2459)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:132)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:595)
at org.apache.catalina.valves.ErrorDispatcherValve.in voke(ErrorDispatcherValve.java:118)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:593)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:116)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:593)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:432)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:954)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:126)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:595)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:432)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:954)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(Co yoteAdapter.java:152)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)



--------------------------------------------------------------------------------

Apache Tomcat/4.1.34-LE-jdk14


What could be wrong. I have tried mostly all things..i am gettting the samw error!
i have copied mysql-connector-java-5.0.5-bin.jar file into the common/lib of apache tomcat.
Kindly help me please...
Reply With Quote
  #2  
Old April 3rd, 2007, 02:01 PM
saurabhp22 saurabhp22 is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Apr 2007
Posts: 2 saurabhp22 User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 38 m 19 sec
Reputation Power: 0
ok friends aftrer 6hours of hard work i was able to find whats giong wrong...
while executiong the function of driver to getconnection we have to pass the username and password even though we have or havnt mentioned it in connection URL. so thats where i went wrong...and as i dint gave username and password in getConnection methos it gave me null pointer exception...
now i'll sleep satisfied..!
Reply With Quote
Reply

Viewing: Dev Articles Community Forums > Programming > Java Development > Problem with connecting JSP with MySQL

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway. 
Stay green...Green IT