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

               {
                  keys.add(rst.getString(1));
               }
            }


            _conn.commit();
            success = true;
            exception = null;
            
            break;
         }

View Full Code Here

            else if (getLogger().isTraceEnabled())
            {
               getLogger().trace(getStoreName() + ": No persisted data object found");
            }


            _conn.commit();
            success = true;
            exception = null;
            break;
         }
         catch (SQLException e)

View Full Code Here

         boolean success = false;
         try
         {
            executeRemove(realId, _conn);


            _conn.commit();
            success = true;
            exception = null;
            break;
         }
         catch (SQLException e)

View Full Code Here

                     throw new IllegalStateException("Cannot insert session " + maskId(sessionData) + " as session metadata is not available");
                  }
               }
            }


            _conn.commit();
            success = true;
            exception = null;
            break;
         }
         catch (SQLException e)

View Full Code Here

            if (rst.next())
            {
               result = Long.valueOf(rst.getLong(1));
            }


            _conn.commit();
            success = true;
            exception = null;
            break;
         }
         catch (SQLException e)

View Full Code Here

         boolean success = false;
         Connection _conn = safeGetConnection();   
         try
         {
            result = executeGetSessionVersion(_conn, realId);
            _conn.commit();
            success = true;
            exception = null;
            break;
         }
         catch (SQLException e)

View Full Code Here

            preparedCleanupSql.setString(1, getName());
            preparedCleanupSql.setLong(2, earliest);
            preparedCleanupSql.setLong(3, (now - maxUnrep));
            preparedCleanupSql.execute();


            _conn.commit();
            lastCleanup = now;
            success = true;
         }
         catch (Exception e)
         {

View Full Code Here

        conn.setAutoCommit(false);
        stmt.execute("INSERT INTO trig_test VALUES (1, 'hello')");
        stmt.execute("INSERT INTO trig_test VALUES (2, 'now what?')");
        stmt.execute("INSERT INTO trig_test VALUES (3, 'unchangable')");
        stmt.execute("INSERT INTO trig_test VALUES (4, 'goodbye')");
        conn.commit();
        dumpTable("trig_test");
        stmt.execute("UPDATE trig_test SET value = 'all done'");
        conn.commit();
        dumpTable("trig_test");
        stmt.execute("DELETE FROM trig_test");

View Full Code Here

        stmt.execute("INSERT INTO trig_test VALUES (3, 'unchangable')");
        stmt.execute("INSERT INTO trig_test VALUES (4, 'goodbye')");
        conn.commit();
        dumpTable("trig_test");
        stmt.execute("UPDATE trig_test SET value = 'all done'");
        conn.commit();
        dumpTable("trig_test");
        stmt.execute("DELETE FROM trig_test");
        conn.rollback();
        dumpTable("trig_test");

View Full Code Here

        } catch (SQLException se) {
            se.printStackTrace();
        }


        stmt.execute("INSERT INTO trig_test VALUES(10, 'whatever')");
        conn.commit();
        dumpTable("trig_test");
        stmt.close();
        conn.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.