This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Has anyone done batch sql statements? I have a bunch of insert statements that will make up an order. I want all the statements to run as one unit, just like a batch, and if any of them fails, it rollsback. So I was wondering that if setAutoCommit(false) is called on a connection, then run executeBatch on the statement object, which will ahve all the insert statements there. Then check to see if all executed, and if not rollback, otherwise commit. Is this the way to go, or is there a better way that anyone knows of? Thanks Mark
Well looking at Sun press's JDBC book. I found that batch is the way I want to go, I can get transactions in it, and it returns an array of ints if it is completely successful, and throws a BatchUpdateException if any one of the statements fail. thanks Mark
If you are using Oracle, then you can control the number of rows when to do a commit. You can either do it at the connection level: ((OracleConnection) conn).setDefaultExecuteBatch(n); or at the PreparedStatement level: ((OraclePreparedStatement) pstmt).setExecuteBatch(n)