- Mailing list pgsql-bugs

From suri
Subject
Date
Msg-id CACyS=CjPxqmPmaOnNhLq+9FHtQ0KwZ_CBaPzgmoq5wb8O2JBSg@mail.gmail.com
Whole thread Raw
Responses Re:  (John R Pierce <pierce@hogranch.com>)
List pgsql-bugs
I have created a function to update the data in the table in postgres and i
have 33k records to update. When i was calling the function as SQL the data
is updated fine. But when i was calling the same function through callable
statement only about 28k records are updated in the table and it was
skipping the remaining records no exceptions have thrown. please help me on
this issue.

this is my code. CallableStatement callStatement =3D
ConnectionDB.getConnectionInstance().prepareCall(" { ? =3D call
functionname()}"); callStatement.registerOutParameter(1, Types.VARCHAR);
callStatement.execute();



/*- =96 - =96 - =96 =96 - =96 =96 - =96 =96 - =96 =96 - =96 =96 - =96 =96 -=
 =96 =96 - =96 =96 - =96 =96 - =96 =96 - -

Please consider your environmental responsibility.
Before printing this e-mail message, ask yourself whether you really need a
hard copy.

Life is what happens to you, while you're busy making other plans

We do not inherit the earth from our ancestors; we borrow it from our
children.
Leave them a living planet reduce your carbon foot print.
------------------------------------------------------------
--------------------------------*/






yours suri chinna

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #8579: CoreDump of background writer process
Next
From: "Rajagopal C.R"
Date:
Subject: Please send me the steps to install Debugger-Plugin for Postgresql-9.2