Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Batch Select Query From JDBC to Oracle DB.

RRAApr 24 2011 — edited Apr 25 2011

Hi all,

I ve JSF Application & performing a query on large oracle table. For performance issue, i want to do batch query & based on coming ResultSet, I need to do some operations.

When I am calling the int[] selectCounts = pst.executeBatch() statement, the java.sql.BatchUpdateException: invalid batch command
error is coming.

Can anyone direct me as how to execute batch queries from java to oracle db, with example.

I have oracle 9i db.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on May 23 2011

Added on Apr 24 2011

#java

9 comments

3,489 views