/** add session to the end of queue when a transaction starts (depending on isolation mode) */
public void beginAction(Session session, Statement cs) {
synchronized (liveTransactionTimestamps) {
session.actionTimestamp = nextChangeTimestamp();
if (!session.isTransaction) {
session.transactionTimestamp = session.actionTimestamp;
session.isTransaction = true;
liveTransactionTimestamps.addLast(session.actionTimestamp);
}
}
if (session.hasLocks()) {
return;
}
try {
writeLock.lock();
boolean canProceed = beginActionTPL(session, cs);
if (!canProceed) {
session.abortTransaction = true;
}
} finally {
writeLock.unlock();
}
}
/** add session to the end of queue when a transaction starts (depending on isolation mode) */
public void beginAction(Session session, Statement cs) {
if (session.hasLocks(cs)) {
return;
}
writeLock.lock();
try {
if (cs.getCompileTimestamp() < database.schemaManager.getSchemaChangeTimestamp()) {
cs = session.statementManager.getStatement(session, cs);
session.sessionContext.currentStatement = cs;
if (cs == null) {
return;
}
}
boolean canProceed = setWaitedSessionsTPL(session, cs);
if (canProceed) {
if (session.tempSet.isEmpty()) {
lockTablesTPL(session, cs);
// we don't set other sessions that would now be waiting for this one too
} else {
setWaitingSessionTPL(session);
}
} else {
session.abortTransaction = true;
}
} finally {
writeLock.unlock();
}
}
/**
* Drops the index with the specified name from this database.
*
* @param indexname the name of the index to drop
* @param ifExists if true and if the Index to drop does not exist, fail silently, else throw
* @param session the execution context
* @throws HsqlException if the index does not exist, the session lacks the permission or the
* operation violates database integrity
*/
void dropIndex(Session session, String indexname, String tableName, boolean ifExists)
throws HsqlException {
Table t = findUserTableForIndex(session, indexname);
if (t == null) {
if (ifExists) {
return;
} else {
throw Trace.error(Trace.INDEX_NOT_FOUND, indexname);
}
}
if (tableName != null && !t.getName().name.equals(tableName)) {
throw Trace.error(Trace.INDEX_NOT_FOUND, indexname);
}
t.checkDropIndex(indexname, null);
// fredt@users 20020405 - patch 1.7.0 by fredt - drop index bug
// see Table.moveDefinition();
session.commit();
session.setScripting(!t.isTemp());
TableWorks tw = new TableWorks(session, t);
tw.dropIndex(indexname);
}
/**
* Retrieves the <code>User</code> objects representing the database users that are visible to the
* <code>User</code> object represented by the <code>session</code> argument.
*
* <p>If the <code>session</code> argument's <code>User</code> object attribute has isAdmin() true
* (directly or by virtue of a Role), then all of the <code>User</code> objects in this collection
* are considered visible. Otherwise, only this object's special <code>PUBLIC</code> <code>User
* </code> object attribute and the session <code>User</code> object, if it exists in this
* collection, are considered visible.
*
* <p>
*
* @param session The <code>Session</code> object used to determine visibility
* @return a list of <code>User</code> objects visible to the <code>User</code> object contained
* by the <code>session</code> argument.
*/
public HsqlArrayList listVisibleUsers(Session session) {
HsqlArrayList list;
User user;
boolean isAdmin;
String sessionName;
String userName;
list = new HsqlArrayList();
isAdmin = session.isAdmin();
sessionName = session.getUsername();
if (userList == null || userList.size() == 0) {
return list;
}
for (int i = 0; i < userList.size(); i++) {
user = (User) userList.get(i);
if (user == null) {
continue;
}
userName = user.getName().getNameString();
if (isAdmin) {
list.add(user);
} else if (sessionName.equals(userName)) {
list.add(user);
}
}
return list;
}
public void readLobResults(
SessionInterface session, DataInputStream inputStream, RowInputBinary in)
throws IOException, HsqlException {
Result currentResult = this;
boolean hasLob = false;
setSession(session);
while (true) {
int addedResultMode = inputStream.readByte();
if (addedResultMode == ResultConstants.LARGE_OBJECT_OP) {
ResultLob resultLob = ResultLob.newLob(inputStream, false);
if (session instanceof Session) {
((Session) session).allocateResultLob(resultLob, inputStream);
} else {
currentResult.addLobResult(resultLob);
}
hasLob = true;
continue;
} else if (addedResultMode == ResultConstants.NONE) {
break;
} else {
throw Error.runtimeError(ErrorCode.U_S0500, "Result");
}
}
if (hasLob) {
((Session) session).registerResultLobs(currentResult);
}
}
public void run() {
try {
for (int i = sessionList.size() - 1; i >= 0; i--) {
Session session = (Session) sessionList.get(i);
if (session.isClosed()) {
synchronized (this) {
sessionList.remove(i);
}
continue;
}
boolean result = session.timeoutManager.checkTimeout();
/*
if (result) {
synchronized (this) {
sessionList.remove(i);
}
}
*/
}
} catch (Throwable e) {
// ignore exceptions
// may be InterruptedException or IOException
}
}
public boolean commitTransaction(Session session) {
if (session.abortTransaction) {
return false;
}
int limit = session.rowActionList.size();
Object[] list = session.rowActionList.getArray();
writeLock.lock();
try {
// new actionTimestamp used for commitTimestamp
session.actionTimestamp = nextChangeTimestamp();
session.transactionEndTimestamp = session.actionTimestamp;
endTransaction(session);
for (int i = 0; i < limit; i++) {
RowAction action = (RowAction) list[i];
action.commit(session);
}
persistCommit(session, list, limit);
int newLimit = session.rowActionList.size();
if (newLimit > limit) {
list = session.rowActionList.getArray();
mergeTransaction(session, list, limit, newLimit, session.actionTimestamp);
finaliseRows(session, list, limit, newLimit, true);
session.rowActionList.setSize(limit);
}
// session.actionTimestamp is the committed tx timestamp
if (getFirstLiveTransactionTimestamp() > session.actionTimestamp || session == lobSession) {
mergeTransaction(session, list, 0, limit, session.actionTimestamp);
finaliseRows(session, list, 0, limit, true);
} else {
list = session.rowActionList.toArray();
addToCommittedQueue(session, list);
}
endTransactionTPL(session);
} finally {
writeLock.unlock();
}
session.tempSet.clear();
return true;
}
public void beginTransaction(Session session) {
synchronized (liveTransactionTimestamps) {
session.actionTimestamp = nextChangeTimestamp();
session.transactionTimestamp = session.actionTimestamp;
session.isTransaction = true;
liveTransactionTimestamps.addLast(session.transactionTimestamp);
}
}
/**
* Executes an UPDATE statement. It is assumed that the argument is of the correct type.
*
* @param cs a CompiledStatement of type CompiledStatement.UPDATE
* @throws HsqlException if a database access error occurs
* @return the result of executing the statement
*/
private Result executeUpdateStatement(CompiledStatement cs) throws HsqlException {
Table table = cs.targetTable;
TableFilter filter = cs.tf;
int count = 0;
if (filter.findFirst()) {
int[] colmap = cs.columnMap; // column map
Expression[] colvalues = cs.columnValues;
Expression condition = cs.condition; // update condition
int len = colvalues.length;
HashMappedList rowset = new HashMappedList();
int size = table.getColumnCount();
int[] coltypes = table.getColumnTypes();
boolean success = false;
do {
if (condition == null || condition.test(session)) {
try {
Row row = filter.currentRow;
Object[] ni = table.getNewRow();
System.arraycopy(row.getData(), 0, ni, 0, size);
for (int i = 0; i < len; i++) {
int ci = colmap[i];
ni[ci] = colvalues[i].getValue(session, coltypes[ci]);
}
rowset.add(row, ni);
} catch (HsqlInternalException e) {
}
}
} while (filter.next());
session.beginNestedTransaction();
try {
count = table.update(session, rowset, colmap);
success = true;
} finally {
// update failed (constraint violation) or succeeded
session.endNestedTransaction(!success);
}
}
updateResult.iUpdateCount = count;
return updateResult;
}
public void rollback(Session session) {
session.abortTransaction = false;
session.actionTimestamp = nextChangeTimestamp();
rollbackPartial(session, 0, session.transactionTimestamp);
endTransaction(session);
try {
writeLock.lock();
endTransactionTPL(session);
} finally {
writeLock.unlock();
}
}
/**
* Drops the specified user-defined view or table from this Database object.
*
* <p>The process of dropping a table or view includes:
*
* <OL>
* <LI>checking that the specified Session's currently connected User has the right to perform
* this operation and refusing to proceed if not by throwing.
* <LI>checking for referential constraints that conflict with this operation and refusing to
* proceed if they exist by throwing.
* <LI>removing the specified Table from this Database object.
* <LI>removing any exported foreign keys Constraint objects held by any tables referenced by
* the table to be dropped. This is especially important so that the dropped Table ceases to
* be referenced, eventually allowing its full garbage collection.
* <LI>
* </OL>
*
* <p>
*
* @param name of the table or view to drop
* @param ifExists if true and if the Table to drop does not exist, fail silently, else throw
* @param isView true if the name argument refers to a View
* @param session the connected context in which to perform this operation
* @throws HsqlException if any of the checks listed above fail
*/
void dropTable(Session session, String name, boolean ifExists, boolean isView)
throws HsqlException {
Table toDrop = null;
int dropIndex = -1;
for (int i = 0; i < tTable.size(); i++) {
toDrop = (Table) tTable.get(i);
if (toDrop.equals(session, name) && isView == toDrop.isView()) {
dropIndex = i;
break;
} else {
toDrop = null;
}
}
if (dropIndex == -1) {
if (ifExists) {
return;
} else {
throw Trace.error(isView ? Trace.VIEW_NOT_FOUND : Trace.TABLE_NOT_FOUND, name);
}
}
if (!toDrop.isTemp()) {
session.checkDDLWrite();
}
if (isView) {
checkViewIsInView((View) toDrop);
} else {
checkTableIsReferenced(toDrop);
checkTableIsInView(toDrop.tableName.name);
}
tTable.remove(dropIndex);
removeExportedKeys(toDrop);
userManager.removeDbObject(toDrop.getName());
triggerNameList.removeOwner(toDrop.tableName);
indexNameList.removeOwner(toDrop.tableName);
constraintNameList.removeOwner(toDrop.tableName);
toDrop.dropTriggers();
toDrop.drop();
session.setScripting(!toDrop.isTemp());
session.commit();
}
protected void readExistingData(Session session) throws IOException, HsqlException {
for (; ; ) {
String s = readTableInit();
if (s == null) {
break;
}
String schema = session.getSchemaName(currentSchema);
Table t = db.schemaManager.getUserTable(session, s, schema);
int j = 0;
for (j = 0; ; j++) {
if (readRow(t) == false) {
break;
}
}
int checkCount = readTableTerm();
if (j != checkCount) {
throw Trace.error(
Trace.ERROR_IN_SCRIPT_FILE,
Trace.ERROR_IN_BINARY_SCRIPT_1,
new Object[] {s, new Integer(j), new Integer(checkCount)});
}
}
}
/** Instantiate this as a SET statement. */
StatementSet(
Session session,
Table table,
RangeVariable rangeVars[],
int[] updateColumnMap,
Expression[] colExpressions,
CompileContext compileContext) {
super(
StatementTypes.ASSIGNMENT,
StatementTypes.X_SQL_DATA_CHANGE,
session.getCurrentSchemaHsqlName());
this.operationType = TRIGGER_SET;
this.targetTable = table;
this.baseTable = targetTable.getBaseTable();
this.updateColumnMap = updateColumnMap;
this.updateExpressions = colExpressions;
this.updateCheckColumns = targetTable.getColumnCheckList(updateColumnMap);
this.targetRangeVariables = rangeVars;
isTransactionStatement = false;
setDatabseObjects(compileContext);
checkAccessRights(session);
}
public Result execute(Session session) {
Result result;
if (targetTable != null && session.isReadOnly() && !targetTable.isTemp()) {
HsqlException e = Error.error(ErrorCode.X_25006);
return Result.newErrorResult(e);
}
if (isExplain) {
return getExplainResult(session);
}
try {
if (subqueries.length > 0) {
materializeSubQueries(session);
}
result = getResult(session);
} catch (Throwable t) {
result = Result.newErrorResult(t, null);
result.getException().setStatementType(group, type);
}
session.sessionContext.clearStructures(this);
return result;
}
/** Initializes this connection. */
private void init() {
runnerThread = Thread.currentThread();
keepAlive = true;
try {
socket.setTcpNoDelay(true);
dataInput = new DataInputStream(socket.getInputStream());
dataOutput = new BufferedOutputStream(socket.getOutputStream());
Result resultIn = Result.read(rowIn, dataInput);
Result resultOut;
try {
int dbIndex = ArrayUtil.find(server.dbAlias, resultIn.subSubString);
dbID = server.dbID[dbIndex];
user = resultIn.getMainString();
password = resultIn.getSubString();
if (!server.isSilent()) {
server.printWithThread(mThread + ":trying to connect user " + user);
}
session =
DatabaseManager.newSession(dbID, resultIn.getMainString(), resultIn.getSubString());
resultOut = new Result(ResultConstants.UPDATECOUNT);
resultOut.databaseID = session.getDatabase().databaseID;
resultOut.sessionID = session.getId();
} catch (HsqlException e) {
session = null;
resultOut = new Result(e, null);
} catch (ArrayIndexOutOfBoundsException e) {
session = null;
resultOut = new Result(Trace.error(Trace.DATABASE_NOT_EXISTS), resultIn.subSubString);
}
Result.write(resultOut, rowOut, dataOutput);
return;
} catch (Exception e) {
server.printWithThread(mThread + ":couldn't connect " + user);
}
close();
}
public void run() {
try {
Session sysSession = sessionManager.newSysSession();
Statement checkpoint = ParserCommand.getAutoCheckpointStatement(Database.this);
sysSession.executeCompiledStatement(checkpoint, ValuePool.emptyObjectArray, 0);
sysSession.commit(false);
sysSession.close();
waiting = false;
} catch (Throwable e) {
// ignore exceptions
// may be InterruptedException or IOException
}
}
Node getRoot(Session session) {
if (isTemp) {
return session.getIndexRoot(indexName, onCommitPreserve);
} else {
return root;
}
}
void setRoot(Session session, Node node) {
if (isTemp) {
session.setIndexRoot(indexName, onCommitPreserve, node);
} else {
root = node;
}
}
// result
Result getDataResultHead(Result command, Result result, boolean isNetwork) {
int fetchSize = command.getFetchSize();
result.setResultId(session.actionTimestamp);
if (command.rsConcurrency == ResultConstants.CONCUR_READ_ONLY) {
result.setDataResultConcurrency(ResultConstants.CONCUR_READ_ONLY);
result.setDataResultHoldability(command.rsHoldability);
} else {
if (result.rsConcurrency == ResultConstants.CONCUR_READ_ONLY) {
result.setDataResultHoldability(command.rsHoldability);
// add warning for concurrency conflict
} else {
if (session.isAutoCommit()) {
result.setDataResultConcurrency(ResultConstants.CONCUR_READ_ONLY);
result.setDataResultHoldability(ResultConstants.HOLD_CURSORS_OVER_COMMIT);
} else {
result.setDataResultHoldability(ResultConstants.CLOSE_CURSORS_AT_COMMIT);
}
}
}
result.setDataResultScrollability(command.rsScrollability);
boolean hold = false;
boolean copy = false;
if (result.rsConcurrency == ResultConstants.CONCUR_UPDATABLE) {
hold = true;
}
if (isNetwork) {
if (fetchSize != 0 && result.getNavigator().getSize() > fetchSize) {
copy = true;
hold = true;
}
} else {
if (result.getNavigator().isDiskBased()) {
hold = true;
}
}
if (hold) {
if (resultMap == null) {
resultMap = new LongKeyHashMap();
}
resultMap.put(result.getResultId(), result);
}
if (copy) {
result = Result.newDataHeadResult(session, result, 0, fetchSize);
}
return result;
}
/** Initializes this connection. */
private void init() {
runnerThread = Thread.currentThread();
keepAlive = true;
try {
socket.setTcpNoDelay(true);
dataInput = new DataInputStream(new BufferedInputStream(socket.getInputStream()));
dataOutput = new BufferedOutputStream(socket.getOutputStream());
Result resultIn = Result.read(rowIn, dataInput);
Result resultOut;
try {
dbID = server.getDBID(resultIn.subSubString);
user = resultIn.getMainString();
password = resultIn.getSubString();
if (!server.isSilent()) {
server.printWithThread(mThread + ":trying to connect user " + user);
}
session =
DatabaseManager.newSession(dbID, resultIn.getMainString(), resultIn.getSubString());
resultOut = new Result(ResultConstants.UPDATECOUNT);
resultOut.databaseID = session.getDatabase().databaseID;
resultOut.sessionID = session.getId();
} catch (HsqlException e) {
session = null;
resultOut = new Result(e, null);
} catch (RuntimeException e) {
session = null;
resultOut = new Result(e, null);
}
Result.write(resultOut, rowOut, dataOutput);
return;
} catch (Exception e) {
server.printWithThread(mThread + ":couldn't connect " + user);
}
close();
}
public boolean prepareCommitActions(Session session) {
Object[] list = session.rowActionList.getArray();
int limit = session.rowActionList.size();
if (session.abortTransaction) {
// System.out.println("cascade fail " + session + " " + session.actionTimestamp);
return false;
}
try {
writeLock.lock();
for (int i = 0; i < limit; i++) {
RowAction rowact = (RowAction) list[i];
if (!rowact.canCommit(session, session.tempSet)) {
// System.out.println("commit conflicts " + session + " " +
// session.actionTimestamp);
return false;
}
}
session.actionTimestamp = nextChangeTimestamp();
for (int i = 0; i < limit; i++) {
RowAction action = (RowAction) list[i];
action.prepareCommit(session);
}
for (int i = 0; i < session.tempSet.size(); i++) {
Session current = (Session) session.tempSet.get(i);
current.abortTransaction = true;
}
return true;
} finally {
writeLock.unlock();
session.tempSet.clear();
}
}
public void beginTransaction(Session session) {
writeLock.lock();
try {
if (!session.isTransaction) {
session.actionTimestamp = nextChangeTimestamp();
session.transactionTimestamp = session.actionTimestamp;
session.isTransaction = true;
transactionCount++;
liveTransactionTimestamps.addLast(session.transactionTimestamp);
}
} finally {
writeLock.unlock();
}
}
/**
* Executes an INSERT_SELECT statement. It is assumed that the argument is of the correct type.
*
* @param cs a CompiledStatement of type CompiledStatement.INSERT_SELECT
* @throws HsqlException if a database access error occurs
* @return the result of executing the statement
*/
private Result executeInsertSelectStatement(CompiledStatement cs) throws HsqlException {
Table t = cs.targetTable;
Select s = cs.select;
int[] ct = t.getColumnTypes(); // column types
Result r = s.getResult(session.getMaxRows(), session);
Record rc = r.rRoot;
int[] cm = cs.columnMap; // column map
boolean[] ccl = cs.checkColumns; // column check list
int len = cm.length;
Object[] row;
int count;
boolean success = false;
session.beginNestedTransaction();
try {
while (rc != null) {
row = t.getNewRowData(session, ccl);
for (int i = 0; i < len; i++) {
int j = cm[i];
if (ct[j] != r.metaData.colType[i]) {
row[j] = Column.convertObject(rc.data[i], ct[j]);
} else {
row[j] = rc.data[i];
}
}
rc.data = row;
rc = rc.next;
}
count = t.insert(session, r);
success = true;
} finally {
session.endNestedTransaction(!success);
}
updateResult.iUpdateCount = count;
return updateResult;
}
/**
* The main SQL statement executor.
*
* <p>All requests to execute SQL statements against this Database object eventually go through
* this method.
*
* @param statement the SQL statement to execute
* @param session an object representing a connected user and a collection of session state
* attributes
* @return the result of executing the specified statement, in a form suitable for either wrapping
* in a local ResultSet object or for transmitting to a remote client via the native HSQLDB
* protocol
* @deprecated from 1.7.2; Session is now the HSQLDB execution hub
*/
Result execute(String statement, Session session) {
try {
Trace.check(session != null, Trace.ACCESS_IS_DENIED);
} catch (SQLException e) {
return new Result(e, statement);
}
return session.sqlExecuteDirect(statement);
}
/**
* Drops the index with the specified name from this database.
*
* @param indexname the name of the index to drop
* @param session the execution context
* @throws SQLException if the index does not exist, the session lacks the permission or the
* operation violates database integrity
*/
void dropIndex(String indexname, Session session) throws SQLException {
Table t = findUserTableForIndex(indexname, session);
if (t == null) {
throw Trace.error(Trace.INDEX_NOT_FOUND, indexname);
}
t.checkDropIndex(indexname, null);
// fredt@users 20020405 - patch 1.7.0 by fredt - drop index bug
// see Table.moveDefinition();
session.commit();
session.setScripting(!t.isTemp());
TableWorks tw = new TableWorks(t);
tw.dropIndex(indexname);
}
Result getWriteAccessResult(Session session) {
try {
if (targetTable != null && !targetTable.isTemp()) {
session.checkReadWrite();
}
} catch (HsqlException e) {
return Result.newErrorResult(e);
}
return null;
}
/** Drops a trigger with the specified name in the given context. */
void dropTrigger(Session session, String name) throws HsqlException {
boolean found = triggerNameList.containsName(name);
Trace.check(found, Trace.TRIGGER_NOT_FOUND, name);
HsqlName tableName = (HsqlName) triggerNameList.removeName(name);
Table t = this.findUserTable(session, tableName.name);
t.dropTrigger(name);
session.setScripting(!t.isTemp());
}
/** Drops from this Database any temporary tables owned by the specified Session. */
void dropTempTables(Session ownerSession) {
int i = tTable.size();
while (i-- > 0) {
Table toDrop = (Table) tTable.get(i);
if (toDrop.isTemp() && toDrop.getOwnerSessionId() != ownerSession.getId()) {
tTable.remove(i);
}
}
}
/**
* Executes a SELECT statement. It is assumed that the argument is of the correct type.
*
* @param cs a CompiledStatement of type CompiledStatement.SELECT
* @throws HsqlException if a database access error occurs
* @return the result of executing the statement
*/
private Result executeSelectStatement(CompiledStatement cs) throws HsqlException {
Select select = cs.select;
Result result;
if (select.sIntoTable != null) {
// session level user rights
session.checkDDLWrite();
if (session.getDatabase().findUserTable(session, select.sIntoTable.name) != null
|| session.getDatabase().dInfo.getSystemTable(session, select.sIntoTable.name) != null) {
throw Trace.error(Trace.TABLE_ALREADY_EXISTS, select.sIntoTable.name);
}
result = select.getResult(session.getMaxRows(), session);
result =
session.dbCommandInterpreter.processSelectInto(
result, select.sIntoTable, select.intoType);
session.getDatabase().setMetaDirty(false);
} else {
result = select.getResult(session.getMaxRows(), session);
}
return result;
}
void endTransactionTPL(Session session) {
int unlockedCount = 0;
unlockTablesTPL(session);
final int waitingCount = session.waitingSessions.size();
if (waitingCount == 0) {
return;
}
for (int i = 0; i < waitingCount; i++) {
Session current = (Session) session.waitingSessions.get(i);
current.tempUnlocked = false;
long count = current.latch.getCount();
if (count == 1) {
boolean canProceed = setWaitedSessionsTPL(current, current.currentStatement);
if (!canProceed) {
current.abortTransaction = true;
}
if (current.tempSet.isEmpty()) {
lockTablesTPL(current, current.currentStatement);
current.tempUnlocked = true;
unlockedCount++;
}
}
}
for (int i = 0; i < waitingCount; i++) {
Session current = (Session) session.waitingSessions.get(i);
if (!current.tempUnlocked) {
// this can introduce additional waits for the sessions
boolean canProceed = setWaitedSessionsTPL(current, current.currentStatement);
if (!canProceed) {
current.abortTransaction = true;
}
}
}
for (int i = 0; i < waitingCount; i++) {
Session current = (Session) session.waitingSessions.get(i);
setWaitingSessionTPL(current);
}
session.tempSet.clear();
session.waitingSessions.clear();
}
