| ij> -- |
| -- Licensed to the Apache Software Foundation (ASF) under one or more |
| -- contributor license agreements. See the NOTICE file distributed with |
| -- this work for additional information regarding copyright ownership. |
| -- The ASF licenses this file to You under the Apache License, Version 2.0 |
| -- (the "License"); you may not use this file except in compliance with |
| -- the License. You may obtain a copy of the License at |
| -- |
| -- http://www.apache.org/licenses/LICENSE-2.0 |
| -- |
| -- Unless required by applicable law or agreed to in writing, software |
| -- distributed under the License is distributed on an "AS IS" BASIS, |
| -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. |
| -- See the License for the specific language governing permissions and |
| -- limitations under the License. |
| -- |
| -- Test cases to test booting of encrypted databases using encryptionKey |
| -- when using jar, classpath subprotocol. |
| -------------------------------------------------------------------- |
| -- Case: create encrypted database using encryptionKey, jar it up and then test |
| -- using the jar protocol. |
| -- create encrypted database. |
| connect 'jdbc:derby:encdb;create=true;dataEncryption=true;encryptionAlgorithm=DES/CBC/NoPadding;encryptionKey=6162636465666768'; |
| ij> create table t1(a int ) ; |
| 0 rows inserted/updated/deleted |
| ij> insert into t1 values(1) ; |
| 1 row inserted/updated/deleted |
| ij> insert into t1 values(2) ; |
| 1 row inserted/updated/deleted |
| ij> insert into t1 values(3) ; |
| 1 row inserted/updated/deleted |
| ij> insert into t1 values(4) ; |
| 1 row inserted/updated/deleted |
| ij> insert into t1 values(5) ; |
| 1 row inserted/updated/deleted |
| ij> connect 'jdbc:derby:encdb;shutdown=true'; |
| ERROR 08006: Database 'encdb' shutdown. |
| ij> -- now create archive of encrypted database. |
| connect 'jdbc:derby:wombat;create=true'; |
| ij(CONNECTION1)> create procedure CREATEARCHIVE(jarName VARCHAR(20), path VARCHAR(20), dbName VARCHAR(20)) |
| LANGUAGE JAVA PARAMETER STYLE JAVA |
| NO SQL |
| EXTERNAL NAME 'org.apache.derbyTesting.functionTests.tests.lang.dbjarUtil.createArchive'; |
| 0 rows inserted/updated/deleted |
| ij(CONNECTION1)> -- archive the encdb and put in ina.jar with dbname as db1 and ina2.jar as db2. |
| call CREATEARCHIVE('ina.jar', 'encdb', 'db1'); |
| 0 rows inserted/updated/deleted |
| ij(CONNECTION1)> call CREATEARCHIVE('ina2.jar','encdb','db2'); |
| 0 rows inserted/updated/deleted |
| ij(CONNECTION1)> disconnect; |
| ij> -- now that we have the database in a jar file, |
| -- test using the jar protocol to connect to the db1 that is in ina.jar |
| -- Should pass: ( DERBY-1373) |
| connect 'jdbc:derby:jar:(ina.jar)db1;encryptionAlgorithm=DES/CBC/NoPadding;encryptionKey=6162636465666768' AS DB1; |
| ij(DB1)> select * from t1 order by a; |
| A |
| ----------- |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| ij(DB1)> connect 'jdbc:derby:;shutdown=true'; |
| ERROR XJ015: Derby system shutdown. |
| ij(DB1)> -- NEGATIVE CASE: Test with wrong encryption key. This should fail. |
| connect 'jdbc:derby:jar:(ina.jar)db1;encryptionAlgorithm=DES/CBC/NoPadding;encryptionKey=6162636465666760' AS DB1; |
| ERROR XJ040: Failed to start database 'jar:(ina.jar)db1' with class loader XXXX, see the next exception for details. |
| ERROR XBCXK: The given encryption key does not match the encryption key used when creating the database. Please ensure that you are using the correct encryption key and try again. |
| ij(DB1)> disconnect; |
| ij> -- test reading a database from a jar file and loading |
| -- classes etc. from the jars within the database. |
| -- first using the jar protocol and then the classpath option. |
| connect 'jdbc:derby:jar:(ina.jar)db1;encryptionAlgorithm=DES/CBC/NoPadding;encryptionKey=6162636465666768' AS DB1; |
| ij(DB1)> connect 'jdbc:derby:;shutdown=true'; |
| ERROR XJ015: Derby system shutdown. |
| ij(DB1)> -- connect to database in jar file using classpath subprotocol. |
| -- should fail as it is not on the classpath yet. |
| connect 'jdbc:derby:classpath:db2;encryptionAlgorithm=DES/CBC/NoPadding;encryptionKey=6162636465666768' AS DB2CL; |
| ERROR XJ004: Database 'classpath:db2' not found. |
| ij(DB1)> -- create a class loader for this current thread |
| connect 'jdbc:derby:encdb;dataEncryption=true;encryptionAlgorithm=DES/CBC/NoPadding;encryptionKey=6162636465666768'; |
| ij(CONNECTION1)> create procedure setDBContextClassLoader(JARNAME VARCHAR(20)) |
| LANGUAGE JAVA PARAMETER STYLE JAVA |
| NO SQL |
| EXTERNAL NAME 'org.apache.derbyTesting.functionTests.tests.lang.dbjarUtil.setDBContextClassLoader'; |
| 0 rows inserted/updated/deleted |
| ij(CONNECTION1)> call setDBContextClassLoader('ina2.jar'); |
| 0 rows inserted/updated/deleted |
| ij(CONNECTION1)> disconnect; |
| ij> -- connect using classpath option with correct encryption key. |
| connect 'jdbc:derby:classpath:db2;encryptionAlgorithm=DES/CBC/NoPadding;encryptionKey=6162636465666768' AS DB2CL; |
| ij(DB2CL)> select * from t1 order by a; |
| A |
| ----------- |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
| ij(DB2CL)> connect 'jdbc:derby:;shutdown=true'; |
| ERROR XJ015: Derby system shutdown. |
| ij(DB2CL)> -- try with wrong encryption key, this should fail. |
| connect 'jdbc:derby:classpath:db2;encryptionAlgorithm=DES/CBC/NoPadding;encryptionKey=6162636465666760' AS DB2CL; |
| ERROR XJ040: Failed to start database 'classpath:db2' with class loader XXXX, see the next exception for details. |
| ERROR XBCXK: The given encryption key does not match the encryption key used when creating the database. Please ensure that you are using the correct encryption key and try again. |
| ij(DB2CL)> exit; |