Forum:

Problem getting result on Page

Greenhorn

Posts: 19

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I am working with a simple html page that makes a call to a servlet that accesses data from a database using JDBC. Everything seems to be working fine except when I hit the submit button on the html page. I get part of what I expect. I expect to see a html page with a table with information. I get the title of the cells but not the content from the query. I did a view source on that page and it seems like it breaks right after the cell titles are written. I executed a query from the command line and the database is connecting and I also get the results that "should" show up on th e screen. I tried it on IE as well as FireFox same thing happens. I was wondering if anyone had any suggestion of why this could be happening and what I need to do to fix it.

This is the Servlet Code:

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
 
public class licForm extends HttpServlet
{
        public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException
        {
                String url, tname, tsname, sql;
                Statement myStatement;
                Connection myConnection;
                ResultSet rs;
 
                response.setContentType("text/html");
                PrintWriter out = response.getWriter();
 
                sql = "SELECT table_name, tablespace_name FROM user_tables";
 
                out.println("<HTML><HEAD><TITLE>LICENSE FORM</TITLE></HEAD>");
                out.println("<BODY>");
                out.println("<p>Sample</p>");
                out.println("<TABLE BORDER=\"1\"><TR>");
                out.println("<TD>Table Name</TD>");
                out.println("<TD>Table Space Name</TD></TR>");
 
              try
                {
                        Class.forName("oracle.jdbc.driver.OracleDriver");
                        url = "jdbc:oracle:thin:username/password@servername:portnumber:serverinstance";
                        myConnection = DriverManager.getConnection(url);
                        myStatement = myConnection.createStatement();
 
/*                      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                        url = "jdbc:odbc:clients";
                        myConnection = DriverManager.getConnection(url);
                        myStatement = myConnection.createStatement();
*/
                        rs = myStatement.executeQuery(sql);
                        out.println("<TD>Above rd.next()</TD>");
                        while(rs.next())
                        {
                                out.println("<TD>" + rs.getString("table_name") + "</TD>");
                                out.println("<TD>" + rs.getString("tablespace_name") + "</TD></TR>");
                        out.println("<TD>In rd.next()</TD>");
                        }
                        out.println("<TD>Below rd.next()</TD>");
                        out.println("</TABLE></BODY></HTML>");
                        out.close();
 
                }catch(Exception ex){ex.printStackTrace();}

}//end of doGet
}//end of public class

This is the html code:

this is the result from the view source:

Any help is greatly appreciated!! Thank you

Eric Pascarello

author

Posts: 15385

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Moving to jsp since it is the server code giving you rpoblems and not the HTML formatting.

Eric

Bear Bibeault

Sheriff

Posts: 67747

173

I like...

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

A truncated HTML file is a sure sign that an exception was thrown by the server-side code that prevented it from completing.

[Asking smart questions] [About Bear] [Books by Bear]

HTML 5 (verified skill)
Skill verified by Jeanne Boyarsky

CSS 3 (verified skill)
Skill verified by Jeanne Boyarsky

JavaScript (verified skill)
Skill verified by Jeanne Boyarsky

Ben Zung

Ranch Hand

Posts: 109

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Juding from your code and where it broke, it should be a driver issue. It never reached the statement. Check the stack trace printed out.
You also may want to catch the exception in an order like "ClassNotFoundException" for the driver, "SQLException" for query and "Exception" for all if you want. Or simply separate the code of loading the driver and the code to execute your query. And at the end, you want to close your statment(and resultset?)

Good luck.

Brian Smith

Ranch Hand

Posts: 63

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Also rd is not declared anywhere. It looks like a misspelling of your resultset rs.

Jeanne Pierre

Greenhorn

Posts: 19

posted 18 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Thank You so much to all who replied to this message. I was able to find the problem. I did not know that I had to shutdown Tomcat and then start it. that seemed to give me the missing pieces. Thank you so much again, it really means a lot to me that people are willing to help.

With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.