/**
* Flushes and closes all opened files.
*
* @throws SecurityException
* if a security manager exists and it determines that the
* caller does not have the required permissions to control this
* handler; required permissions include
* {@code LogPermission("control")},
* {@code FilePermission("write")} etc.
*/
public override void close()
{
// release locks
base.close();
allLocks.remove(fileName);
try {
java.nio.channels.FileChannel channel = lockJ.channel();
lockJ.release();
channel.close();
java.io.File file = new java.io.File(fileName + LCK_EXT);
file.delete();
} catch (java.io.IOException e) {
// ignore
}
}
/*
* Delete a file in the data directory
*/
public static void delFile(String fname) //throws NullPointerException, IOException
{
java.io.File f = new java.io.File(fname);
// only delete a file that exists
//
if (f.exists())
{
// try the delete. If it fails, complain
//
if (!f.delete())
{
throw new java.io.IOException("Could not delete: " + f.getAbsolutePath() + ".");
}
}
}
static java.util.Properties loadFilePrefsImpl(java.io.File file)
{
Properties result = new Properties();
if (!file.exists())
{
file.getParentFile().mkdirs();
return(result);
}
if (file.canRead())
{
java.io.InputStream inJ = null;
java.nio.channels.FileLock lockJ = null;
try {
java.io.FileInputStream istream = new java.io.FileInputStream(file);
inJ = new java.io.BufferedInputStream(istream);
java.nio.channels.FileChannel channel = istream.getChannel();
lockJ = channel.lockJ(0L, java.lang.Long.MAX_VALUE, true);
org.w3c.dom.Document doc = builder.parse(inJ);
org.w3c.dom.NodeList entries = org.apache.xpath.XPathAPI.selectNodeList(doc
.getDocumentElement(), "entry"); //$NON-NLS-1$
int length = entries.getLength();
for (int i = 0; i < length; i++)
{
org.w3c.dom.Element node = (org.w3c.dom.Element)entries.item(i);
String key = node.getAttribute("key"); //$NON-NLS-1$
String value = node.getAttribute("value"); //$NON-NLS-1$
result.setProperty(key, value);
}
return(result);
} catch (java.io.IOException e) {
} catch (org.xml.sax.SAXException e) {
} catch (javax.xml.transform.TransformerException e) {
// transform shouldn't fail for xpath call
throw new java.lang.AssertionError(e);
} finally {
releaseQuietly(lockJ);
closeQuietly(inJ);
}
}
else
{
file.delete();
}
return(result);
}
public static void delFile(String dataDir, String fname)
{//throws NullPointerException, IOException {
java.io.File f = new java.io.File(dataDir + java.io.File.separator + fname);
// only delete a file that exists
//
if (f.exists())
{
// try the delete. If it fails, complain
//
if (!f.delete())
{
throw new java.io.IOException("Could not delete file: " +
dataDir + "/" + fname + ".");
}
}
}
/**
* Flushes and closes all opened files.
*
* @throws SecurityException
* if a security manager exists and it determines that the
* caller does not have the required permissions to control this
* handler; required permissions include
* {@code LogPermission("control")},
* {@code FilePermission("write")} etc.
*/
public override void close()
{
// release locks
base.close();
allLocks.remove(fileName);
try {
java.nio.channels.FileChannel channel = lockJ.channel();
lockJ.release();
channel.close();
java.io.File file = new java.io.File(fileName + LCK_EXT);
file.delete();
} catch (java.io.IOException e) {
// ignore
}
}
/**
*
* Deletes Columns from tableName, given a vector of
* column definition (tsColumn) arrays.<br>
*
* ALTER TABLE table DROP [ COLUMN ] column { RESTRICT | CASCADE }
*
* @param tableName the name of the table
* @param v a Vector containing arrays of column definitions.
* @see tinySQL#AlterTableDropCol
*
*/
internal override void AlterTableDropCol(String tableName, java.util.Vector <Object> v)
{//throws IOException, tinySQLException {
// rename the file ...
String fullpath = dataDir + java.io.File.separator + tableName + DBFFileTable.dbfExtension;
String tmppath = dataDir + java.io.File.separator + tableName + "-tmp" + DBFFileTable.dbfExtension;
if (Utils.renameFile(fullpath, tmppath) == false)
{
throw new TinySQLException("ALTER TABLE DROP COL error in renaming " + fullpath);
}
try
{
// open the old file ...
java.io.RandomAccessFile ftbl_tmp = new java.io.RandomAccessFile(tmppath, "r");
// read the first 32 bytes ...
DBFHeader dbfHeader_tmp = new DBFHeader(ftbl_tmp);
// read the column info ...
java.util.Vector <Object> coldef_list = new java.util.Vector <Object>(dbfHeader_tmp.numFields - v.size());
int locn = 0; // offset of the current column
nextCol : for (int i = 1; i <= dbfHeader_tmp.numFields; i++)
{
TsColumn coldef = readColdef(ftbl_tmp, tableName, i, locn);
// remove the DROP columns from the existing cols ...
for (int jj = 0; jj < v.size(); jj++)
{
String colName = (String)v.elementAt(jj);
if (coldef.name.equals(colName))
{
Utils.log("Dropping " + colName);
goto nextCol;
}
}
locn += coldef.size; // increment locn by the length of this field.
// Utils.log("Recycling " + coldef.name);
coldef_list.addElement(coldef);
}
// create the new table ...
CreateTable(tableName, coldef_list);
// copy the data from old to new
// opening new created dBase file ...
java.io.RandomAccessFile ftbl = new java.io.RandomAccessFile(fullpath, "rw");
ftbl.seek(ftbl.length()); // go to end of file
int numRec = 0;
for (int iRec = 1; iRec <= dbfHeader_tmp.numRecords; iRec++)
{
if (DBFFileTable.isDeleted(ftbl_tmp, dbfHeader_tmp, iRec) == true)
{
continue;
}
numRec++;
ftbl.write(DBFFileTable.RECORD_IS_NOT_DELETED); // write flag
// Read the whole column into the table's cache
String column = DBFFileTable._GetCol(ftbl_tmp, dbfHeader_tmp, iRec);
for (int iCol = 0; iCol < coldef_list.size(); iCol++) // write columns
{
TsColumn coldef = (TsColumn)coldef_list.elementAt(iCol);
// Extract column values from cache
String value = DBFFileTable.getColumn(coldef, column);
java.lang.SystemJ.outJ.println("From cache column value" + value);
value = Utils.forceToSize(value, coldef.size, " "); // enforce the correct column length
byte[] b = value.getBytes(Utils.encode); // transform to byte and write to file
ftbl.write(b);
}
}
ftbl_tmp.close();
// remove temp file
java.io.File f = new java.io.File(tmppath);
if (f.exists())
{
f.delete();
}
DBFHeader.writeNumRecords(ftbl, numRec);
ftbl.close();
}
catch (Exception e)
{
throw new TinySQLException(e.getMessage());
}
}
