next() error
От
Nahum Castro
Тема
next() error
Дата
Msg-id
714bb51a050203145120066735@mail.gmail.com
Список
Дерево обсуждения
next() error Nahum Castro <nahumcastro@gmail.com>
Re: next() error Oliver Jowett <oliver@opencloud.com>
Re: next() error Nahum Castro <nahumcastro@gmail.com>
I am using postgresql 8 and the 8 JDBC 3 driver.
I get the next error:
javax.servlet.ServletException: ResultSet not positioned properly,
perhaps you need to call next.
This code used to work on postgresql 7.4.6 and 215 JDBC 3 driver
Has changed something on the server or on the driver?
Thanks for your help.
This is the code on a jsp page:
-------------------------------------------------------------------------------------
<%@ page contentType="text/html; charset=iso-8859-1" language="java"
import="java.sql.*" errorPage="" %>
<%@ include file="Connections/connPubs.jsp" %>
<%
String RecordsetPubs1 = "1";
if (request.getParameter("au_id") != null)
{
RecordsetPubs1 = (String)request.getParameter("au_id");
}
%>
<%
Driver DriverRecordsetPubs1 =
(Driver)Class.forName(connPubs_DRIVER).newInstance();
Connection ConnRecordsetPubs1 =
DriverManager.getConnection(connPubs_STRING,connPubs_USERNAME,connPubs_PASSWORD);
PreparedStatement StatementRecordsetPubs1 =
ConnRecordsetPubs1.prepareStatement("SELECT * FROM public.authors
WHERE au_id = " + RecordsetPubs1 + "");
ResultSet RecordsetPubs1 = StatementRecordsetPubs1.executeQuery();
boolean RecordsetPubs1_isEmpty = ! RecordsetPubs1.next();
boolean RecordsetPubs1_hasData = ! RecordsetPubs1_isEmpty;
Object RecordsetPubs1_data;
int RecordsetPubs1_numRows = 0;
%>
Untitled Document
| au_id | <%=(((RecordsetPubs1_data = RecordsetPubs1.getObject("au_id"))==null || RecordsetPubs1.wasNull())?"":RecordsetPubs1_data)%> |
| au_lname | <%=(((RecordsetPubs1_data = RecordsetPubs1.getObject("au_lname"))==null || RecordsetPubs1.wasNull())?"":RecordsetPubs1_data)%> |
| au_fname | <%=(((RecordsetPubs1_data = RecordsetPubs1.getObject("au_fname"))==null || RecordsetPubs1.wasNull())?"":RecordsetPubs1_data)%> |
| phone | <%=(((RecordsetPubs1_data = RecordsetPubs1.getObject("phone"))==null || RecordsetPubs1.wasNull())?"":RecordsetPubs1_data)%> |
| address | <%=(((RecordsetPubs1_data = RecordsetPubs1.getObject("address"))==null || RecordsetPubs1.wasNull())?"":RecordsetPubs1_data)%> |
| city | <%=(((RecordsetPubs1_data = RecordsetPubs1.getObject("city"))==null || RecordsetPubs1.wasNull())?"":RecordsetPubs1_data)%> |
| state | <%=(((RecordsetPubs1_data = RecordsetPubs1.getObject("state"))==null || RecordsetPubs1.wasNull())?"":RecordsetPubs1_data)%> |
| zip | <%=(((RecordsetPubs1_data = RecordsetPubs1.getObject("zip"))==null || RecordsetPubs1.wasNull())?"":RecordsetPubs1_data)%> |
В списке pgsql-jdbc по дате отправления