| From: | "Scott Street" <sstreet98(at)home(dot)com> |
|---|---|
| To: | "PostgreSQL JDBC List" <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | JDBC/JSP: Strange Problem |
| Date: | 2001-12-02 05:03:43 |
| Message-ID: | 004c01c17aee$b78cd5f0$15fea8c0@driftwood |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Hi folks, new to the list and PostgreSQL -- In the process of converting
all of my MySql programs to Postgres.
I have run into a strange problem I can't resolve, I narrowed the problem
down to a small snippet of code below.
The code compiles and runs, I see the select all * from messages execute
and the data is returned via the network, however, the jsp only outputs the
LAST record returned. Can't figure it out -- anyone else hit this?
BTW: Tomcat 3.3, Java 1.3.1, PostgreSQL 7.1.3 with JDBC 7.1-1.2.jar
(jsp code --- cut here ---)
<%(at)page contentType="text/html"%>
<html>
<head><title>JSP Page</title></head>
<%(at)taglib uri="/WEB-INF/lib/dbtags.jar" prefix="jdbc" %>
<%(at)taglib uri="/WEB-INF/lib/ietags.jar" prefix="pr" %>
<body>
<H1>Message Listing from Dataserver</h1>
<jdbc:connection id="jdbcConn"
driver="org.postgresql.Driver"
url="jdbc:postgresql://ocean/bbs"
user="bbs" password="******" />
<jdbc:query id="msgQuery" connection="jdbcConn" resultsId="msgDS"
resultsScope="session" >
select all * from messages
</jdbc:query>
<TABLE border=1>
<TR>
<TH>MsgId
<TH>fromUser
<TH>toUser
<TH>Subject
<TH>Flags
<TH>Text
</TR>
<pr:iterator results="msgDS" >
<TR>
<TD><pr:field name="msgid"/>
<TD><pr:field name="fromuser"/>
<TD><pr:field name="touser"/>
<TD><pr:field name="subject"/>
<TD><pr:field name="flags"/>
<TD><pr:field name="msgtext"/>
</TR>
</pr:iterator>
</TABLE>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Lawton | 2001-12-02 07:11:06 | java.lang.AbstractMethodError |
| Previous Message | Barry Lind | 2001-11-30 19:03:44 | Re: [HACKERS] JDBC improvements |