Hi,
thanx for the response,
I am using,
JDBC ODBC,
connecting to a MS SQL DB,
Could you please let me know , waht might be the problem,
I am updating and inserting in different tables together.
The code goes like this.
.....
for()
{...
String ls_query1 = "insert into table2...."
String ls_query2 = "update table1...."
String ls_query3 = "update table3...."
Statemetn.addBatch(ls_query1 )
Statemetn.addBatch(ls_query3 )
Statemetn.addBatch(ls_query2 )
}
Statemetn.executeBatch();
thanx in advance,
somwya