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

    try {
        Connection connection = session.connection();
        Statement statement = connection.createStatement();
        try {
            statement.executeUpdate("insert into o_stat_hourofday (businesspath,resid,hour,value) values ('businesspath',101,2,202)");
            connection.commit();
        }
        finally {
            statement.close();
        }
    }

View Full Code Here

    try {
        Connection connection = session.connection();
        Statement statement = connection.createStatement();
        try {
            statement.executeUpdate("insert into o_stat_dayofweek (businesspath,resid,day,value) values ('businesspath',101,2,202)");
            connection.commit();
        }
        finally {
            statement.close();
        }
    }

View Full Code Here

    try {
        Connection connection = session.connection();
        Statement statement = connection.createStatement();
        try {
            statement.executeUpdate("insert into o_stat_daily (businesspath,resid,day,value) values ('businesspath',101,now(),202)");
            connection.commit();
        }
        finally {
            statement.close();
        }
    }

View Full Code Here

                    if (conn != null && !conn.isClosed() && !conn.getAutoCommit())
                    {
                        // Make sure any remaining statements are executed and commit the connection
                        ((RDBMSStoreManager)storeMgr).getSQLController().processConnectionStatement(this);
                        this.needsCommitting = false;
                        conn.commit();
                        if (NucleusLogger.CONNECTION.isDebugEnabled())
                        {
                            NucleusLogger.CONNECTION.debug(LOCALISER_RDBMS.msg("052005", conn.toString()));
                        }
                    }

View Full Code Here

                            if (sqlController != null)
                            {
                                sqlController.processConnectionStatement(this);
                            }


                            conn.commit();
                            needsCommitting = false;
                            if (NucleusLogger.CONNECTION.isDebugEnabled())
                            {
                                NucleusLogger.CONNECTION.debug(LOCALISER_RDBMS.msg("052005", connStr));
                            }

View Full Code Here

            while (RS.next()) {
                accountsnb = RS.getInt(1);
            }


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


            Stmt.close();


            if (accountsnb == (naccounts * tps)) {

View Full Code Here


            Stmt.execute(Query);
            Stmt.clearWarnings();


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


            Stmt.close();
        } catch (Exception E) {}

View Full Code Here

            Stmt.execute("SET TABLE BRANCHES SOURCE \"BBRANCHES.TXT\"");
            Stmt.execute("SET TABLE TELLERS SOURCE \"TELLERS.TXT\"");
            Stmt.execute("SET TABLE HISTORY SOURCE \"HISTORY.TXT\"");
*/
            if (transactions) {
                Conn.commit();
            }


            Stmt.close();
        } catch (Exception E) {
            System.out.println(

View Full Code Here


            Stmt.execute(Query);
            Stmt.clearWarnings();


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


            /* prime database using TPC BM B scaling rules.
             **  Note that for each branch and teller:
             **      branch_id = teller_id  / ntellers

View Full Code Here


                    Stmt.executeUpdate(Query);
                }


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


            if (prepared_stmt) {
                pstmt.close();

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.