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)%>
<% RecordsetPubs1.close(); StatementRecordsetPubs1.close(); ConnRecordsetPubs1.close(); %> -------------------------------------------------------------------------------------- -- Nahum Castro González León, Guanajuato, México
В списке pgsql-jdbc по дате отправления
От: Oliver Jowett
Дата:
От: Oliver Jowett
Дата:
Сообщение: Re: next() error
FAQ