backuprestore.out

来自「derby database source code.good for you.」· OUT 代码 · 共 128 行

OUT
128 行
字号 
ij> --CASE: Tests backup/restore with jar files stored inside the databasecreate table x (x double precision, y int);0 rows inserted/updated/deletedij> insert into x values (1,1),(10,1),(20,1);3 rows inserted/updated/deletedij> call sqlj.install_jar('extin/brtestjar.jar', 'aggjar', 0);0 rows inserted/updated/deletedij> call SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.database.classpath', 'APP.aggjar');0 rows inserted/updated/deletedij> create function dv(P1 INT) RETURNS INT NO SQL external name 'dbytesting.CodeInAJar.doubleMe' language java parameter style java;0 rows inserted/updated/deletedij> select cast (dv(x) as dec(5,2)) from x;1       --------2.00    20.00   40.00   ij> ----take a backup.call SYSCS_UTIL.SYSCS_BACKUP_DATABASE('extinout/mybackup');0 rows inserted/updated/deletedij> connect 'jdbc:derby:wombat;shutdown=true';ERROR 08006: Database 'wombat' shutdown.ij> disconnect;ij> ---restore a databasesconnect 'jdbc:derby:wombat;restoreFrom=extinout/mybackup/wombat';ij> select cast (dv(x) as dec(5,2)) from x;1       --------2.00    20.00   40.00   ij> connect 'jdbc:derby:wombat;shutdown=true';ERROR 08006: Database 'wombat' shutdown.ij> disconnect;ij> ---create a new database from backup.connect 'jdbc:derby:wombatnew;createFrom=extinout/mybackup/wombat';ij> select cast (dv(x) as dec(5,2)) from x;1       --------2.00    20.00   40.00   ij> connect 'jdbc:derby:wombatnew;shutdown=true';ERROR 08006: Database 'wombatnew' shutdown.ij> disconnect;ij> connect 'jdbc:derby:wombat';ij> select cast (dv(x) as dec(5,2)) from x;1       --------2.00    20.00   40.00   ij> call SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE('extinout/mybackup', 1);0 rows inserted/updated/deletedij> insert into x values (1,1),(10,1),(20,1);3 rows inserted/updated/deletedij> insert into x values (1,1),(10,1),(20,1);3 rows inserted/updated/deletedij> insert into x values (1,1),(10,1),(20,1);3 rows inserted/updated/deletedij> insert into x values (1,1),(10,1),(20,1);3 rows inserted/updated/deletedij> select cast (dv(x) as dec(5,2)) from x;1       --------2.00    20.00   40.00   2.00    20.00   40.00   2.00    20.00   40.00   2.00    20.00   40.00   2.00    20.00   40.00   ij> connect 'jdbc:derby:wombat;shutdown=true';ERROR 08006: Database 'wombat' shutdown.ij> disconnect;ij> ---perform a rollforward recoveryconnect 'jdbc:derby:wombat;rollForwardRecoveryFrom=extinout/mybackup/wombat';ij> select * from x;X                     |Y          ----------------------------------1.0                   |1          10.0                  |1          20.0                  |1          1.0                   |1          10.0                  |1          20.0                  |1          1.0                   |1          10.0                  |1          20.0                  |1          1.0                   |1          10.0                  |1          20.0                  |1          1.0                   |1          10.0                  |1          20.0                  |1          ij> select cast (dv(x) as dec(5,2)) from x;1       --------2.00    20.00   40.00   2.00    20.00   40.00   2.00    20.00   40.00   2.00    20.00   40.00   2.00    20.00   40.00   ij> insert into x values (1,1),(10,1),(20,1);3 rows inserted/updated/deletedij> connect 'jdbc:derby:wombat;shutdown=true';ERROR 08006: Database 'wombat' shutdown.ij> disconnect;ij>

backuprestore.out - 源码说明

本页面展示了「derby database source code.good for you.」中的 backuprestore.out 源码文件，采用 OUT 编程语言编写，共 128 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与database相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?