JSP problems

Hi I'm having problems displaying information that I am retrieving from a database through an sql query.

My jsp code is as follows:

<%@ page language="java" contentType="text/html" errorPage="errorpage.jsp" import="java.sql.*, java.util.*" %>
<jsp:useBean id="connect" class="myBeans.HostelConnectBean" />
<jsp:setProperty name="connect" property="*" />

<html><head><title>Login</title></head>
<body>
These are the hostels: <%= connect.selectHostel() %>

</body></html>

But the output from this is:

These are the hostels: oracle.jdbc.driver.OracleResultSet@e134e6 instead of displaying the hostels.

Can anyone shed any light on why this is happening?

Thanks

Jan 30 '07 #1

Subscribe Post Reply

1759

dmjpro

2,476

2GB

I think ur connect.selectHostel() returns the the instance of Resultset interface.
That's why the result is obtained from the toString() method.........
connect.selectHostel().toString() that means the third party implemented class name is oracle.jdbc.driver.OracleResultSet.........
oracle.jdbc.driver.OracleResultSet.toString() method is called...
Such format generally from the toString() method ...XXXX@XXXX

Jan 31 '07 #2

r035198x

13,262

8TB

I think ur connect.selectHostel() returns the the instance of Resultset interface.
That's why the result is obtained from the toString() method.........
connect.selectHostel().toString() that means the third party implemented class name is oracle.jdbc.driver.OracleResultSet.........
oracle.jdbc.driver.OracleResultSet.toString() method is called...
Such format generally from the toString() method ...XXXX@XXXX

It does. The OP should now extract the relevant data from the resultset for display.

Jan 31 '07 #3

dmjpro

2,476

2GB

How the ResultSet istance is used to retrive data.........

<%ResultSet l_result = connect.selectHostel();

while(l_result.next())
{%>
<html_tag><%=l_result.getString("COLUMN_NAME")%> </html_tag>
<%}
%>

I think think hostel name is character basis....
And ur query is somthing like this...
select HOSTEL_NAME from HOSTEL_DATABASE

Jan 31 '07 #4

Similar topics

Some work on the ICPC problems.

by: Jerome Lefebvre | last post by:

Hello, Hope this will interest a few. I been working with a friend on the problems given out during the "International Collegiate Programming Contest" (ICPC) http://icpc.baylor.edu/icpc/ ....

Python

1,596 problems in .Net 1.1

by: Jim Hubbard | last post by:

Are you up to speed on the difficulties in using the 1.1 .Net framework? Not if you are unaware of the 1,596 issues listed at KBAlertz (http://www.kbalertz.com/technology_3.aspx). If you are...

.NET Framework

Installation and Deployment Problems of Web Application

by: 3f | last post by:

Hello; We have made a web application that people can download from our web site and installed on: Windows XP Windows 2000 Professional Windows 2003 Server Windows 2000 Server

ASP / Active Server Pages

DATE function problems

by: Corky | last post by:

This works: db2 SELECT DISTINCT PROBLEM_OBJECTS.PROBLEM_ID FROM PROBLEM_OBJECTS INNER JOIN PROBLEMS ON PROBLEM_OBJECTS.PROBLEM_ID = PROBLEMS.PROBLEM_ID WHERE INTEGER(DAYS(CURRENT DATE) -...

DB2 Database

DB2 8.3.1 on RedHatLinux AS2.1 problems

by: Ellen Graves | last post by:

I am having a lot of problems with DB2 8.3.1 on RH Linux AS2.1. Installing and running stored procedures is problematic. Stored procedures I have used for years on V7 on WinNT are now failing...

DB2 Database

How many ActiveX controls can I have? Stack overflow problems...

by: Jim | last post by:

I have spent the past few weeks designing a database for my company. The problem is I have started running into what I believe are stack overflow problems. There are two tab controls on the form...

Microsoft Access / VBA

recompiling VS NET WinForms app with VS NET 2003 causing serious problems.

by: BBFrost | last post by:

We just recently moved one of our major c# apps from VS Net 2002 to VS Net 2003. At first things were looking ok, now problems are starting to appear. So far ... (1) ...

C# / C Sharp

Custom web control problems in the designer pane (simple examples)

by: Dales | last post by:

I have a custom control that builds what we refer to as "Formlets" around some content in a page. These are basically content "wrapper" sections that are tables that have a colored header and...

ASP.NET

Server Control Collection Properties Solutions,Problems MVP Advice Requested

by: Brian | last post by:

NOTE ALSO POSTED IN microsoft.public.dotnet.framework.aspnet.buildingcontrols I have solved most of my Server Control Collection property issues. I wrote an HTML page that describes all of the...

ASP.NET

Problems with the Process.Start()

by: Sergistm | last post by:

Hello World, :D I have a problem that it is making me crazy, I hope you can help me. I'm trying to execute a .exe file with the Procces.Start, and there is no problem when the file is on my...

C# / C Sharp

Cloud Servers without Credit Card and Email Registration: A Simpler Way to Get on the Cloud

by: CloudSolutions | last post by:

Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...

General

Wordpress or something else?

by: Faith0G | last post by:

I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

Content Management Systems

Access Europe: Command bars, the Access Shortcut Tool and a simple Audit Log - Wed 3 April

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

General

One-click Importing Excel Data into a*Database

by: ryjfgjl | last post by:

In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...

Microsoft Excel

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Basic Javascript concepts

by: aa123db | last post by:

Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...

Javascript

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware