postgresql.stat.result

From: Minal <minalac(at)yes2etl(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: postgresql.stat.result
Date: 2005-08-03 06:05:27
Message-ID: 42F05EA7.4000102@yes2etl.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

hi....
I am calling a function using the following JSP code...my function name
is "sp_login". As every function is supposed to return something...my
function returns 1, on completion of the task....I am getting the
following error..
org.apache.jasper.JasperException: postgresql.stat.result

The jsp code is as follows:
Can someone help me????
sql="SELECT sp_login ('INSERT','admin','"+username+"','"+password+"')";
//sql="INSERT INTO USERS (USERTYPE,USERNAME,PASSWORD) VALUES
('admin','"+username+"','"+password+"')";
pStat=conn.prepareStatement(sql);
msg=pStat.executeUpdate();
out.println(msg);
if(msg==1)
{%>
<jsp:forward page="message_user.jsp?done=yes&action=add"/>
<%}
else
{%>
<jsp:forward page="message_user.jsp?done=no&action=add"/>
<%}
}%>

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2005-08-03 06:38:03 Re: postgresql.stat.result
Previous Message Oliver Jowett 2005-08-03 03:23:21 Re: Select where id in (LARGE LIST) ?