From: | tanu b <tanushree_rane(at)yahoo(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | postgres.stat.result exception |
Date: | 2003-08-05 05:16:34 |
Message-ID: | 20030805051634.49395.qmail@web20701.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi
I am having a problem using a stored procedure/function in postgres ver 7.2.2
My JDBC code is as follows
----------------------------------------------------------------------------------------------------------
Connection conn = null;
CallableStatement cs = null;
try{
conn = DatabaseAccess.CreateDBConnection() ;
cs = conn.prepareCall("{? = call Save_Status(?)}");
cs.registerOutParameter(1,java.sql.Types.INTEGER);
cs.setString(2,strStatus);
int iStatus = cs.executeUpdate();
................
}
---------------------------------------------------------------------------------------------------------
The function is written as follows
------------------------------------------------------------------------------------------------------------------------------
CREATE FUNCTION save_status(varchar) RETURNS int4 AS '
Begin
update TA_REGISTRATION_DATA SET REG_STATUS = $1 WHERE REG_ID = 1;
return 0;
END;
' LANGUAGE 'plpgsql';
------------------------------------------------------------------------------------------------------------------------------
The update to the postgresql database succeeds but a postgresql.stat.result exception is thrown.
What do I need to modify in my JAVA code/function to avoid this exception.
Thanks and Regards
Tanu
---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
From | Date | Subject | |
---|---|---|---|
Next Message | Xavier Poinsard | 2003-08-05 09:23:41 | Broken link on jdbc.postgresql.org main page |
Previous Message | Kris Jurka | 2003-08-05 03:56:06 | Re: JDBC (fwd) |