postgres.stat.result exception

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

Responses

Browse pgsql-jdbc by date

  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)