is it possible to execute 3-4 prepated statements at once as batch?

[Arun_N]

Ex:-
PreparedStatement pstmt = conn.prepareStatement(INSERT_RECORD);
pstmt.setString(1, "1");
pstmt.setString(2, "name1");
pstmt.addBatch();
pstmt = conn.prepareStatement(DELETE_RECORD);
pstmt.setString(1, "5");
pstmt.addBatch();//is it possible?
int[] i = pstmt.executeBatch();//is it possible?

[masijade]

Well, seeing as how you are redefining the variable and so pstmt after the second prepareStatement no longer refers to the same object as it did before that, what do you think?

[Arun_N]

yes , even i got the same doubt, if i want to execute all statements at once is it possible? any other way?

[masijade]

It is not a "doubt", it is a certainty.

You can't, but what you are really looking for, I believe, is doing them as a single transaction. IOW, connection.setAutoCommit(false); statement; statement; statement; conn.commit();