/**
* Method declaration
*
* @param compact
* @throws SQLException
*/
void close(boolean compact) throws SQLException {
if (Trace.TRACE) {
Trace.trace();
}
if (bReadOnly) {
return;
}
// no more scripting
closeScript();
// create '.script.new' (for this the cache may be still required)
writeScript(compact);
// flush the cache (important: after writing the script)
if (cCache != null) {
cCache.flush();
}
closeAllTextCaches(compact);
// create '.backup.new' using the '.data'
backup();
// we have the new files
pProperties.setProperty("modified", "yes-new-files");
pProperties.save();
// old files can be removed and new files renamed
renameNewToCurrent(sFileScript);
renameNewToCurrent(sFileBackup);
// now its done completely
pProperties.setProperty("modified", "no");
pProperties.setProperty("version", jdbcDriver.VERSION);
pProperties.setProperty("hsqldb.compatible_version", "1.7.0");
pProperties.save();
pProperties.close();
if (compact) {
// stop the runner thread of this process (just for security)
stop();
// delete the .data so then a new file is created
(new File(sFileCache)).delete();
(new File(sFileBackup)).delete();
// tony_lai@users 20020820
// The database re-open and close has been moved to
// Database#close(int closemode) for saving memory usage.
}
}
/**
* Method declaration
*
* @throws SQLException
*/
void checkpoint(boolean defrag) throws SQLException {
if (defrag) {
ArrayList rootsArray = cCache.defrag();
for (int i = 0; i < rootsArray.size(); i++) {
int[] roots = (int[]) rootsArray.get(i);
if (roots != null) {
Trace.printSystemOut(org.hsqldb.lib.StringUtil.getList(roots, " ", ""));
}
}
DataFileDefrag2.updateTableIndexRoots(dDatabase.getTables(), rootsArray);
}
close(false);
pProperties.setProperty("modified", "yes");
pProperties.save();
if (cCache != null) {
cCache.open(false);
}
reopenAllTextCaches();
openScript();
}
private void create() throws SQLException {
if (Trace.TRACE) {
Trace.trace(sName);
}
pProperties.setProperty("version", jdbcDriver.VERSION);
pProperties.setProperty("sql.strict_fk", true);
pProperties.save();
}
/** Creates file with defaults if it didn't exist. Returns false if file already existed. */
public boolean createFile() throws SQLException {
if (checkFileExists()) {
return false;
}
setProperty("version", jdbcDriver.VERSION);
setProperty("sql.strict_fk", true);
save();
return true;
}
/**
* check by trying to delete the properties file this will not work if some application has the
* file open this is why the properties file is kept open when running ;-) todo: check if this
* works in all operating systems
*
* @return true if file is open
* @exception java.sql.SQLException
*/
protected boolean isFileOpen() throws java.sql.SQLException {
close();
if (Trace.TRACE) {
Trace.trace();
}
if ((new File(fileName + ".properties")).delete() == false) {
return true;
}
// the file was deleted, so recreate it now
save();
return false;
}
/**
* When opening a database, the hsqldb.compatible_version property is used to determine if this
* version of the engine is equal to or greater than the earliest version of the engine capable of
* opening that database.
*
* <p>
*
* @return
* @throws SQLException
*/
boolean open() throws SQLException {
if (Trace.TRACE) {
Trace.trace();
}
if (!pProperties.checkFileExists()) {
create();
open();
// this is a new database
return true;
}
// todo: some parts are not necessary for ready-only access
pProperties.load();
sFileScript = sName + ".script";
sFileCache = sName + ".data";
sFileBackup = sName + ".backup";
scriptChecker = new File(sFileScript);
// tony_lai@users 20020820
// Allows the user to modify log size from the properties file.
iLogSize = pProperties.getIntegerProperty("hsqldb.log_size", iLogSize);
String version = pProperties.getProperty("hsqldb.compatible_version");
// fredt@users 20020428 - patch 1.7.0 by fredt
int check = version.substring(0, 5).compareTo(jdbcDriver.VERSION);
Trace.check(check <= 0, Trace.WRONG_DATABASE_FILE_VERSION);
// save the current version
pProperties.setProperty("hsqldb.version", jdbcDriver.VERSION);
if (pProperties.isPropertyTrue("readonly")) {
bReadOnly = true;
dDatabase.setReadOnly();
if (cCache != null) {
cCache.open(true);
}
reopenAllTextCaches();
runScript();
return false;
}
boolean needbackup = false;
String state = pProperties.getProperty("modified");
if (state.equals("yes-new-files")) {
renameNewToCurrent(sFileScript);
renameNewToCurrent(sFileBackup);
} else if (state.equals("yes")) {
if (isAlreadyOpen()) {
throw Trace.error(Trace.DATABASE_ALREADY_IN_USE);
}
// recovering after a crash (or forgot to close correctly)
restoreBackup();
needbackup = true;
}
pProperties.setProperty("modified", "yes");
pProperties.save();
if (cCache != null) {
cCache.open(false);
}
reopenAllTextCaches();
runScript();
if (needbackup) {
close(false);
pProperties.setProperty("modified", "yes");
pProperties.save();
if (cCache != null) {
cCache.open(false);
}
reopenAllTextCaches();
}
openScript();
// this is an existing database
return false;
}