Batch Execution in JDBC

Hello Everybody,
How to use different PreparedStatements in a single batch?
e.g.
if i have a 1st prepared statemnt like
insert into emp values(?,?,?,?)
& second one:
delete from emp where empid=?

then how these statements could be added in a single batch & executed?

i hope the question is clear.

Shrinivas Mujumdar

You can't do that (have different prepared statements in one batch).

When you batch prepared statements it is the same statement each time only the parameters for the statement are batched.

Hi,
That means it is the limitation of Batch Execution in JDBC & such issues can only be handled using Stored Procedures. Any other solution than that.?

Shrinivas

A stored procedure is usually a good choice if there are lesser calls to the procedure and much processing which could be handled on the DB end.
I am not sure if your case would exactly suit that. But I guess it would give you some (minor IMO) improvement in the performance.

Thanks a Lot!!!