SQLCipher and SQLiteJDBC

[Ralf H.]

Hello,

first of all I want to thank Stephen Lombardo for publishing
SQLCipher. Two weeks ago I found an article about it on the web. It
was exactly that what I was looking for. We wanted to have a encrypted
database that we could use for an iPhone application. This SQLite
database is created on a JBoss application server. So we needed a JDBC
driver for creating this database. Fortunately there is also an open-
source JDBC driver named SQLiteJDBC published by David Crawshaw
available on github. So I could build my own JDBC driver that can
write encrypted databases.

thanks
Ralf

[Stephen Lombardo]

Hi Ralf,

I can confirm this is possible, as I ran through this same exercise a few months ago testing the JDBC driver build with SQLCipher for a project. In fact, it only required some minor changes to the Makefile to get working. I just pushed my changes up to a github fork, in case it would help accelerate your work.

http://github.com/sjlombardo/sqlitejdbc

Here is the diff:

http://github.com/sjlombardo/sqlitejdbc/commit/2aaa45fa08649b0a3500789ab149fbce7ac4dcf9

Basically, these changes replace the default amalgamation source with that of sqlcipher and add some compile time flags and linker options to enable the build. 

Good luck!

Cheers,

Stephen