JDBC/JSP: Strange Problem

Поиск
Список
Период
Сортировка
От Scott Street
Тема JDBC/JSP: Strange Problem
Дата
Msg-id 004c01c17aee$b78cd5f0$15fea8c0@driftwood
обсуждение исходный текст
Ответы Re: JDBC/JSP: Strange Problem
Re: JDBC/JSP: Strange Problem
Список 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 ---)

<%@page contentType="text/html"%>
<html>
<head><title>JSP Page</title></head>
<%@taglib uri="/WEB-INF/lib/dbtags.jar" prefix="jdbc" %>
<%@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>

В списке pgsql-jdbc по дате отправления: