I want to open an encrypted MS ACCESS (.accdb) database in Squirrel SQL Client Version 4.5.1. I tried this doc:
I could create the CryptCodecOpener.class but when I try to connect I get the following Error:
XXXX: JDBC Driver class not found class java.lang.ClassNotFoundException: CryptCodecOpener
Here is the code:
import java.io.File;
import java.io.IOException;
import net.ucanaccess.jdbc.JackcessOpenerInterface;
import com.healthmarketscience.jackcess.crypt.CryptCodecProvider;
import com.healthmarketscience.jackcess.Database;
import com.healthmarketscience.jackcess.DatabaseBuilder;
public class CryptCodecOpener implements JackcessOpenerInterface {
@Override
public Database open(File fl,String pwd) throws IOException {
DatabaseBuilder dbd =new DatabaseBuilder(fl);
dbd.setCodecProvider(new CryptCodecProvider(pwd));
dbd.setAutoSync(true); // Notice that the parameter setting autosync=true is recommended with UCanAccess for performance reasons
dbd.setReadOnly(false);
return dbd.open();
}
}
Where should the class file be?