Derby
  1. Derby
  2. DERBY-5676

Cannot connect to AES encrypted database with IBMJCECCA provider

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Blocker 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.

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

        Activity

        No work has yet been logged on this issue.

          People

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

            Dates

            • Created:
              Updated:

              Development