Uninstall File - Aster Client

This command removes the file or SQL-MapReduce function from Aster Database.

UNINSTALL FILE 'filename' from schema  schemaname

This is an example:

public void testUninstall() {
String stmt1 = "UNINSTALL file  'abc.txt' from schema uploadfile  ;";
String stmt2 = "UNINSTALL file  'odbcng.zip' from schema uploadfile  ;";
String stmt3 = "UNINSTALL file  'odbcng.tar.gz'   ;";
try {
conn_.setAutoCommit(false);
Statement s = conn_.createStatement();
s.executeUpdate(stmt1);
s.executeUpdate(stmt2);
s.executeUpdate(stmt3);
conn_.commit();
s.close();
} catch (Exception e) {
try {
conn_.rollback();
} catch (SQLException e1) {
e1.printStackTrace();
}
fail(e.getMessage());
}
}