Re: BatchUpdate exception

From: Kris Jurka <books(at)ejurka(dot)com>
To: "Kranti K K Parisa \[GetSet-India\]" <kranti(dot)parisa(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: BatchUpdate exception
Date: 2007-12-06 09:47:33
Message-ID: Pine.BSO.4.64.0712060446210.19865@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 6 Dec 2007, Kranti K K Parisa [GetSet-India] wrote:

> I realized it after posting it and then i have changed it to the following
>
> CallableStatement proc=null;
> try{
> for (int i=0;i<200;i++){
> for(int j=0;j<4;j++){
> proc=con.prepareCall("{call test_function()}");

You're still doing the exact same thing, initializing proc inside the
loop. You need to do this once outside the loops.

Kris Jurka

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Usama Dar 2007-12-06 12:23:35 Re: Connection attempt hangs when server is unresponsive
Previous Message Kranti K K Parisa [GetSet-India] 2007-12-06 09:42:22 Re: BatchUpdate exception