The whole sqlite/JDBC driver stuff is a little dubious, so take care (sqlite only has a few underlying types, it emulates other types, then JBDC translates on top of that). I managed to insert values via literals in JDBC that I couldn't then read out. So beware. 😉