Examples of java.sql.Connection.commit()

java.sql.Connection.commit()
Commit makes all changes made since the previous commit/rollback permanent and releases any database locks currently held by the Connection. This method should only be used when auto commit has been disabled. @exception SQLException if a database-access error occurs. @see #setAutoCommit

            if (prepared_stmt) {
                pstmt.close();
            }


            if (transactions) {
                Conn.commit();
            }


            if (prepared_stmt) {
                Query = "INSERT INTO tellers(Tid,Bid,Tbalance) VALUES (?,?,0)";
                pstmt = Conn.prepareStatement(Query);

View Full Code Here


                    Stmt.executeUpdate(Query);
                }


                if ((i % 100 == 0) && (transactions)) {
                    Conn.commit();
                }
            }


            if (prepared_stmt) {
                pstmt.close();

View Full Code Here

            if (prepared_stmt) {
                pstmt.close();
            }


            if (transactions) {
                Conn.commit();
            }


            if (prepared_stmt) {
                Query =
                    "INSERT INTO accounts(Aid,Bid,Abalance) VALUES (?,?,0)";

View Full Code Here


                    Stmt.executeUpdate(Query);
                }


                if ((i % 10000 == 0) && (transactions)) {
                    Conn.commit();
                }


                if ((i > 0) && ((i % 10000) == 0)) {
                    System.out.println("\t" + i + "\t records inserted");
                }

View Full Code Here

            if (prepared_stmt) {
                pstmt.close();
            }


            if (transactions) {
                Conn.commit();
            }


            System.out.println("\t" + (naccounts * tps)
                               + "\t records inserted");

View Full Code Here

            for (int i = 1; i <= 4; i++) {    // [2, 3, 4]
                prep.setInt(1, i);
                prep.addBatch();
                System.out.println("executeBatch() for " + i);
                prep.executeBatch();
                con.commit();


                // prep.clearBatch(); // -> java.lang.NullPointerException
                // at org.hsqldb.Result.getUpdateCounts(Unknown Source)
            }

View Full Code Here

        rs.next();


        int value = rs.getInt(1);


        con2.commit();
        con3.commit();
        con1.commit();


        rs = st.executeQuery("SELECT * FROM T");


        rs.next();

View Full Code Here

    try {
        Connection connection = session.connection();
        Statement statement = connection.createStatement();
        try {
            statement.executeUpdate("insert into o_stat_weekly (businesspath,resid,week,value) values ('businesspath',101,'2010-03',202)");
            connection.commit();
        }
        finally {
            statement.close();
        }
    }

View Full Code Here

            if (httpStatus != HttpServletResponse.SC_OK) {
                response.setStatus(httpStatus);
            }
            
            if (transaction == null && this.batch) {
                connection.commit();
            }


        } catch (Exception e) {
            if (transaction == null && connection != null && this.batch) {
                try {

View Full Code Here

            setupConn.setAutoCommit(false);
            Statement st = setupConn.createStatement();
            st.executeUpdate("SET PASSWORD 'sapwd'");
            populate(st);
            st.close();
            setupConn.commit();
            setupConn.close();
        } catch (SQLException se) {
            throw new RuntimeException(
                "Failed to set up in-memory database", se);
        }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.