Re: BatchUpdate exception

Hi Kris,

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++){
//System.out.println("inside outer==>>"+i);
for(int j=0;j<4;j++){
//System.out.println("inside inner==>>"+j);
proc=con.prepareCall("{call test_function()}");
//proc.registerOutParameter(1, Types.INTEGER);
proc.addBatch();
}
}
int []intUpdates=proc.executeBatch();
System.out.println("intUpdates length==>>"+intUpdates.length);
for(int i=0;i<intUpdates.length;i++){
System.out.println("i number is==>>"+i);
System.out.println("i value is==>>"+intUpdates[i]);
al.add(new Integer(intUpdates[i]));
}
}catch(SQLException e){
System.out.println(e.getNextException());
}
--------------------------

But the output remains same, which is

----------
intUpdates length==>>1
i number is==>>0
i value is==>>0
test size===>>[0]

------------------

Please suggest

On Dec 6, 2007 3:09 PM, Kris Jurka <books(at)ejurka(dot)com> wrote:

>
>
> On Thu, 6 Dec 2007, Kranti K K Parisa [GetSet-India] wrote:
>
> > for (int i=0;i<200;i++){
> > //System.out.println("inside outer==>>"+i);
> > for(int j=0;j<4;j++){
> > proc=null;
> > //System.out.println("inside inner==>>"+j);
> > proc=con.prepareCall("{call
> > client255271111.test_function()}");
> > //proc.registerOutParameter(1, Types.INTEGER);
> > proc.addBatch();
> > }
> > }
> > int []intUpdates=proc.executeBatch();
>
>
> Since you're reinitializing proc inside the loop you only end up adding
> one batch to it, so you only get one batch out.
>
> Kris Jurka
>

--
------------------
Best Regards
Kranti Kiran Kumar Parisa
Mobile: +91 - 9849 - 625 - 625
+91 - 9391 - 438 - 738