Search code examples
sqlencryptionhsqldbblowfish

Decrypt Blowfish encrypted HSQLDB .script File


it's my first Question, so please don't be harsh if you're seeing any mistakes. I'm creating an embedded HSQLDB via a Client.

con = DriverManager.getConnection("jdbc:hsqldb:file:"
    + dataBaseName
    + ";crypt_key=604a6105889da65326bf35790a923932;crypt_type=blowfish;shutdown=true","sa", "");

It's encrypted with Blowfish. I only defined the Key. Now i want to decrypt the .script File with Notepad++ Extensions but it asks for an IV-Key and the Salt. I haven't defined these Arguments but i need them. Any Suggestions? Thanks in Advance


Solution

  • You cannot do it directly.

    Connect to the database via any client. Then use the command below for the name and location for saving the .script file in non-encrypted format.

     SCRIPT 'path/filename'