create sqlcipher database on sd-card

[gseebacher]

hi,
i'm using openhelper to create sqlite databases. now i want to move to sqlcipher to encrypt my databases.
when i try to create a database on the sd-card i get an error "sqlite returned: error code = 14, msg = cannot open file at line ..."
creation of internal db works fine.
i have added the WRITE_EXTERNAL_STORAGE - permission to the manifest file.

seems that the onCreate does not get fired.
do you have any idea what is going wrong?
thanks in advance.

[developernotes]

Hi gseebacher,

Are you using SQLiteDatabase.openOrCreateDatabase(...);? What path are you using? Also, have you checked to see if your SD Card is mounted?

[gseebacher]

hi Nick,

thank you very much for your response. in the meantime i managed to get it
working. :-)
do you know by chance if the encryption libraries also work when i want to
create a encrypted sqlite db in windows using jdeveloper?

thanks, ciao
gerhard

2012/11/19 Nick Parker [email protected]

Hi gseebacher,

Are you using SQLiteDatabase.openOrCreateDatabase(...);? What path are
you using? Also, have you checked to see if your SD Card is mounted?

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/67#issuecomment-10518448.

[developernotes]

Hi gseebacher,

The SQLCipher for Android binaries require the Android runtime to exist, even with the new x86 build of the binaries. So this is not something that would work.

[gseebacher]

thanks Nick!

2012/11/19 Nick Parker [email protected]

Hi gseebacher,

The SQLCipher for Android binaries require the Android runtime to exist,
even with the new x86 build of the binaries. So this is not something that
would work.

—
Reply to this email directly or view it on GitHubhttps://github.com//issues/67#issuecomment-10526323.

[pligor]

Let me share a solution that worked for all android versions and is based upon this stackoverflow answer: http://stackoverflow.com/a/9168969/720484

Written in Scala:

/**
 * Useful to save the database in SD card
 * @param absoluteDirectoryPath the directory under which an sqlite database will be created
 */
class DatabaseContext(val absoluteDirectoryPath: String,
                      val password: String)(implicit val context: Context) extends ContextWrapper(context) {
  private val dbExtension = Some(".db");

  override def getDatabasePath(name: String): File = {
    val dbPath: String = absoluteDirectoryPath + File.separator + {
      if (dbExtension.isDefined && !name.endsWith(dbExtension.get)) name + dbExtension.get;
      else name;
    };

    val result = new File(dbPath);

    val parentFile = result.getParentFile;
    if (parentFile.exists) {
      //nop
    } else {
      parentFile.mkdirs;
    }

    result;
  }

  /*override def openOrCreateDatabase(name: String, mode: Int, factory: CursorFactory) = {
    //if something wrong with the database consider setting the factory argument to null in the line below
    SQLiteDatabase.openOrCreateDatabase(getDatabasePath(name), password, factory);
  }*/
}