Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5676

Cannot connect to AES encrypted database with IBMJCECCA provider

    Details

    • Type: Bug
    • Status: Open
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: 10.5.3.0
    • Fix Version/s: None
    • Component/s: Services
    • Environment:
    • Urgency:
      Normal

      Description

      The install is created on a HFS file system. And we create DB using this command
      java -cp . -jar derbyrun.jar ij databaseAuth.sql
      and databaseAuth.sql content is given below.

      connect 'jdbc:derby: /HO4/test/testDb;create=true;dataEncryption=true;bootPassword=Password;encryptionAlgorithm=AES/CBC/NoPadding;';

      --------------------------------------------------------------------------------
      – CREATE TESTTABLE TABLE WITH PRIMARY KEY OF USERNAME
      – STEP 2
      --------------------------------------------------------------------------------
      CREATE TABLE TESTTABLE
      (
      USERNAME VARCHAR(30) NOT NULL,
      PASSWORD VARCHAR(30) NOT NULL,
      PRIMARY KEY (USERNAME)
      );

      --------------------------------------------------------------------------------
      – INSERT USER INTO TESTTABLE TABLE
      – STEP 3
      --------------------------------------------------------------------------------
      INSERT INTO TESTTABLE VALUES('<adminuser>', '<adminpass>');

      EXIT;

      Create was successful. But when we try to connect to DB again it fails to start with error.

        Attachments

        1. scripts.tar
          50 kB
          Ambili
        2. scriptinascii.zip
          7 kB
          Ambili
        3. derby.log
          22 kB
          Ambili
        4. db.tar
          1.75 MB
          Kathey Marsden
        5. db.tar
          3.49 MB
          Ambili
        6. db.pax.Z
          1.78 MB
          Ambili

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              ambili Ambili
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: