Re: BatchUpdate exception - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: BatchUpdate exception
Date
Msg-id Pine.BSO.4.64.0712060446210.19865@leary.csoft.net
Whole thread Raw
In response to Re: BatchUpdate exception  ("Kranti K K Parisa [GetSet-India]" <kranti.parisa@gmail.com>)
List 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

pgsql-jdbc by date:

Previous
From: "Kranti K K Parisa [GetSet-India]"
Date:
Subject: Re: BatchUpdate exception
Next
From: "Usama Dar"
Date:
Subject: Re: Connection attempt hangs when server is unresponsive