Forum:

Error while creating database connection

Greenhorn

Posts: 17

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi All,

i want to retreive records from database but error is coming when i am executing the code..

pls help..

My code is :

<%@page import="java.sql.*"%>
<html>
<head>
<title>Obtaining a Connection</title>
</head>
<body>
<h1>This Page Obtains a Connection to a Database and executes a query</h1>
<%
    Connection conn = null;
    ResultSet result = null;
    Statement stmt = null;
 
 
    try {
      Class c = Class.forName("com.mysql.jdbc.Driver");
    }
    catch (Exception e) {
      System.out.println("Error occurred " + e);
     }
     try {
       conn = DriverManager.getConnection("jdbc:mysql://localhost/master?user='' & password='' ");
     }
     catch (SQLException e) {
        System.out.println("Error occurred " + e);
     }
     try {
        stmt = conn.createStatement();
        result = stmt.executeQuery("SELECT * FROM employees");
     }
     catch (SQLException e) {
         System.out.println("Error occurred " + e);
      }
 
%>  
 <TABLE BORDER="1">
            <TR>
                <TH>ID</TH>
                <TH>Name</TH>
                <TH>City</TH>
                <TH>State</TH>
 
            </TR>
            <% while(result.next()){ %><TR>
                <TD> <%= result.getString(1) %></td>
                <TD> <%= result.getString(2) %></TD>
                <TD> <%= result.getString(3) %></TD>
                <TD> <%= result.getString(4) %></TD>
                
            </TR>
            <% } %>
        </TABLE>
    </BODY>
</HTML>

===================
Error is Coming...

type Exception report

message

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

exception

org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.NullPointerException
org.apache.jsp.prac.email_jsp._jspService(email_jsp.java:69)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.

Thanks & Regards,
Yunus

[ December 14, 2006: Message edited by: Bear Bibeault ]
[BPSouther: Added UBB Code Tags]
[ December 14, 2006: Message edited by: Ben Souther ]

Muhammad Saifuddin

Ranch Hand

Posts: 1325

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Check this DriverManager.getConnection Java Doc

Saifuddin..
[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource

Ben Souther

Sheriff

Posts: 13411

I like...

posted 15 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

The generated servlet source code for Tomcat is under the:
{tomcat install}/work/Catalina/localhost/org/apache/jsp
directory.

Find the file listed above and see what on line 69 is throwing a NullPointerException.

Also:
"pls" is not a word in the English language.
Please see:
http://faq.javaranch.com/view?UseRealWords
to see why we make such a big stinkin deal of this.

Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf

Could you hold this puppy for a sec? I need to adjust this tiny ad:

Free, earth friendly heat - from the CodeRanch trailboss

https://www.kickstarter.com/projects/paulwheaton/free-heat