| 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: | Whole Thread | Raw Message | 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"/>
<%}
}%>
| 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) ? |