Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group