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>