From: | Kim Ho <kho(at)redhat(dot)com> |
---|---|
To: | tanu b <tanushree_rane(at)yahoo(dot)com> |
Cc: | pgsql-jdbc-list <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: postgres.stat.result exception |
Date: | 2003-08-05 11:41:30 |
Message-ID: | 1060083690.4892.6.camel@yay |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
I'm working in 7.4.
But I can do this:
(Using your function definition)
CallableStatement stmt = conn.prepareCall("{?=call Save_Status(?)}");
stmt.registerOutParameter(1, java.sql.Types.INTEGER);
stmt.setString(2,"'asdfadf'");
stmt.executeQuery();
System.out.println(stmt.getInt(1));
which outputs 0.
In your function, you return 0. My guess is that it's being treated as a
result set so that's why executeUpdate will not work.
Cheers,
Kim
On Tue, 2003-08-05 at 01:16, tanu b wrote:
> 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 | LUTZ GEOFFREY | 2003-08-05 12:56:09 | |
Previous Message | Xavier Poinsard | 2003-08-05 09:23:41 | Broken link on jdbc.postgresql.org main page |