1 21 22 package org.apache.derbyTesting.functionTests.tests.store; 23 24 import java.sql.Connection ; 25 import java.sql.SQLException ; 26 import java.sql.Statement ; 27 28 import org.apache.derby.tools.ij; 29 30 39 40 public class RecoveryAfterBackupSetup 41 { 42 43 public static void main(String [] argv) throws Throwable 44 { 45 try { 46 ij.getPropertyArg(argv); 47 Connection conn = ij.startJBMS(); 48 conn.setAutoCommit(true); 49 50 System.out.println("Connection has been opened."); 51 Statement s = conn.createStatement(); 52 try { s.execute("DROP TABLE t1"); 54 } catch (SQLException e) { 55 if (e.getSQLState().equals("42Y55")) { 56 } else { 58 throw e; 59 } 60 } 61 62 System.out.println("Creating table and inserting two records."); 63 s.execute("CREATE TABLE t1(a INT)"); 64 s.execute("INSERT INTO t1 VALUES(0)"); 65 s.execute("INSERT INTO t1 VALUES(1)"); 66 67 System.out.println("Performing backup..."); 68 s.execute("CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE('extinout/mybackup', 0)"); 69 System.out.println("Backup completed. Test finished."); 70 } catch (SQLException sqle) { 71 org.apache.derby.tools.JDBCDisplayUtil.ShowSQLException(System.out, 72 sqle); 73 sqle.printStackTrace(System.out); 74 } 75 } 76 } 77 | Popular Tags |