public String getLeaseOwnerStatement() { if (leaseOwnerStatement == null) { leaseOwnerStatement = "SELECT BROKER_NAME, TIME FROM " + getFullLockTableName() + " WHERE ID = 1"; } return leaseOwnerStatement; }
public String[] getCreateLockSchemaStatements() { if (createLockSchemaStatements == null) { createLockSchemaStatements = new String[] { "CREATE TABLE " + getFullLockTableName() + "( ID " + longDataType + " NOT NULL, TIME " + longDataType + ", BROKER_NAME " + stringIdDataType + ", PRIMARY KEY (ID) )", "INSERT INTO " + getFullLockTableName() + "(ID) VALUES (1)" }; } return createLockSchemaStatements; }
public String getCurrentDateTime() { if (currentDateTimeStatement == null) { currentDateTimeStatement = "SELECT CURRENT_TIMESTAMP FROM " + getFullLockTableName(); } return currentDateTimeStatement; }
public String getLeaseUpdateStatement() { if (leaseUpdateStatement == null) { leaseUpdateStatement = "UPDATE " + getFullLockTableName() + " SET BROKER_NAME=?, TIME=?" + " WHERE BROKER_NAME=? AND ID = 1"; } return leaseUpdateStatement; }
public String getLockCreateStatement() { if (lockCreateStatement == null) { lockCreateStatement = "SELECT * FROM " + getFullLockTableName(); if (useLockCreateWhereClause) { lockCreateStatement += " WHERE ID = 1"; } lockCreateStatement += " FOR UPDATE"; } return lockCreateStatement; }
public String getLeaseObtainStatement() { if (leaseObtainStatement == null) { leaseObtainStatement = "UPDATE " + getFullLockTableName() + " SET BROKER_NAME=?, TIME=?" + " WHERE (TIME IS NULL OR TIME < ?) AND ID = 1"; } return leaseObtainStatement; }
public String getLockUpdateStatement() { if (lockUpdateStatement == null) { lockUpdateStatement = "UPDATE " + getFullLockTableName() + " SET TIME = ? WHERE ID = 1"; } return lockUpdateStatement; }
public String[] getDropSchemaStatements() { if (dropSchemaStatements == null) { dropSchemaStatements = new String[] {"DROP TABLE " + getFullAckTableName() + "", "DROP TABLE " + getFullMessageTableName() + "", "DROP TABLE " + getFullLockTableName() + ""}; } return dropSchemaStatements; }
@Override public void setStatements(Statements statements) { String lockCreateStatement = "LOCK TABLE " + statements.getFullLockTableName() + " IN EXCLUSIVE MODE"; statements.setLockCreateStatement(lockCreateStatement); super.setStatements(statements); }
if( !type.equals(INNODB) && !type.equals(NDBCLUSTER) ) { statements.setLockCreateStatement("LOCK TABLE " + statements.getFullLockTableName() + " WRITE"); l.add("ALTER TABLE "+statements.getFullMessageTableName()+" ENGINE="+NDBCLUSTER); l.add("ALTER TABLE "+statements.getFullAckTableName()+" ENGINE="+NDBCLUSTER); l.add("ALTER TABLE "+statements.getFullLockTableName()+" ENGINE="+NDBCLUSTER); l.add("FLUSH TABLES"); s = l.toArray(new String[l.size()]);
@Override public void setStatements(Statements statements) { String lockCreateStatement = "SELECT * FROM " + statements.getFullLockTableName() + " WITH (UPDLOCK, ROWLOCK)"; if (statements.isUseLockCreateWhereClause()) { lockCreateStatement += " WHERE ID = 1"; } statements.setLockCreateStatement(lockCreateStatement); super.setStatements(statements); } }
@Override public void setStatements(Statements statements) { statements.setLockCreateStatement("LOCK TABLE " + statements.getFullLockTableName() + " IN EXCLUSIVE MODE"); statements.setLongDataType("DECIMAL"); statements.setSequenceDataType("DECIMAL"); super.setStatements(statements); } }
public String[] getCreateLockSchemaStatements() { if (createLockSchemaStatements == null) { createLockSchemaStatements = new String[] { "CREATE TABLE " + getFullLockTableName() + "( ID " + longDataType + " NOT NULL, TIME " + longDataType + ", BROKER_NAME " + stringIdDataType + ", PRIMARY KEY (ID) )", "INSERT INTO " + getFullLockTableName() + "(ID) VALUES (1)" }; } return createLockSchemaStatements; }
public String getLockUpdateStatement() { if (lockUpdateStatement == null) { lockUpdateStatement = "UPDATE " + getFullLockTableName() + " SET TIME = ? WHERE ID = 1"; } return lockUpdateStatement; }
public String getLockCreateStatement() { if (lockCreateStatement == null) { lockCreateStatement = "SELECT * FROM " + getFullLockTableName(); if (useLockCreateWhereClause) { lockCreateStatement += " WHERE ID = 1"; } lockCreateStatement += " FOR UPDATE"; } return lockCreateStatement; }
public String getLeaseUpdateStatement() { if (leaseUpdateStatement == null) { leaseUpdateStatement = "UPDATE " + getFullLockTableName() + " SET BROKER_NAME=?, TIME=?" + " WHERE BROKER_NAME=? AND ID = 1"; } return leaseUpdateStatement; }
public String getLeaseOwnerStatement() { if (leaseOwnerStatement == null) { leaseOwnerStatement = "SELECT BROKER_NAME, TIME FROM " + getFullLockTableName() + " WHERE ID = 1"; } return leaseOwnerStatement; }
public String getLeaseOwnerStatement() { if (leaseOwnerStatement == null) { leaseOwnerStatement = "SELECT BROKER_NAME, TIME FROM " + getFullLockTableName() + " WHERE ID = 1"; } return leaseOwnerStatement; }
public String[] getDropSchemaStatements() { if (dropSchemaStatements == null) { dropSchemaStatements = new String[] {"DROP TABLE " + getFullAckTableName() + "", "DROP TABLE " + getFullMessageTableName() + "", "DROP TABLE " + getFullLockTableName() + ""}; } return dropSchemaStatements; }
@Override public void setStatements(Statements statements) { String lockCreateStatement = "SELECT * FROM " + statements.getFullLockTableName() + " WITH (UPDLOCK, ROWLOCK)"; if (statements.isUseLockCreateWhereClause()) { lockCreateStatement += " WHERE ID = 1"; } statements.setLockCreateStatement(lockCreateStatement); super.setStatements(statements); } }