From: suri <surendranath1021(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject:
Date: 2013-11-06 07:22:17
Message-ID: CACyS=CjPxqmPmaOnNhLq+9FHtQ0KwZ_CBaPzgmoq5wb8O2JBSg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 =
ConnectionDB.getConnectionInstance().prepareCall(" { ? = call
functionname()}"); callStatement.registerOutParameter(1, Types.VARCHAR);
callStatement.execute();

/*- – - – - – – - – – - – – - – – - – – - – – - – – - – – - – – - – – - -

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

Responses

  • Re: at 2013-11-06 19:38:52 from John R Pierce

Browse pgsql-bugs by date

  From Date Subject
Next Message rgr 2013-11-06 08:54:43 BUG #8579: CoreDump of background writer process
Previous Message Robert Nix 2013-11-06 03:05:05 Re: BUG #8578: loading a 33G (compressed) pg_dump into a fresh host and db instance crashes a postgresql process