Hi,
I would like to backup derby databes. But I get this error:
Derby DB backup will be executed.
*The local depo is empty. Cannot create archive.
*
I call the backup like this :
String query = CommonDbSqlStubs.backupDatabase;
con = getConnection();
stmt = new FsccPreparedStatement(con.prepareStatement("CALL
SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE(?, ?)"));
stmt.setString(1, tempDirectory);
stmt.setInteger(2, 1);
stmt.execUpdateAndCheck("database backup failed");
con.commit();
or :
String query = CommonDbSqlStubs.backupDatabase;
con = getConnection();
stmt = new FsccPreparedStatement(con.prepareStatement("CALL
SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)"));
stmt.setString(1, tempDirectory);
stmt.execUpdateAndCheck("database backup failed");
con.commit();
I could backuped database, but somthing happend and it is not working now.
I can not find the reason. If sombody know pleas let me know.
Thank you Peter