File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JSP and the fly likes Problem getting result on Page Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "Problem getting result on Page" Watch "Problem getting result on Page" New topic

Problem getting result on Page

Jeanne Pierre

Joined: Feb 23, 2006
Posts: 19
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:

This is the html code:

this is the result from the view source:

Any help is greatly appreciated!! Thank you
Eric Pascarello

Joined: Nov 08, 2001
Posts: 15385
Moving to jsp since it is the server code giving you rpoblems and not the HTML formatting.

Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63844

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]
Ben Zung
Ranch Hand

Joined: Mar 25, 2004
Posts: 109
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

Joined: May 20, 2005
Posts: 63
Also rd is not declared anywhere. It looks like a misspelling of your resultset rs.
Jeanne Pierre

Joined: Feb 23, 2006
Posts: 19
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.
I agree. Here's the link:
subject: Problem getting result on Page
It's not a secret anymore!