java - sqlite-jdbc for SQLite v2.X -


we having lot of sqlite databases (of version 2.x) in cent os linux servers. there need read database content using java , operations on it.

i couldn't find sqlite jdbc compatible sqlite v2.x version.

if try use latest jars available here (http://mvnrepository.com/artifact/org.xerial/sqlite-jdbc), got error,

error :[sqlite_notadb] file opened not database file (file encrypted or not database) 

where can find jdbc driver jar sqlite v2.x or there other work around ?

to convert database file sqlite 2 sqlite 3, can use command-line shells of both versions dump database sql commands, , recreate it:

sqlite db2.sqlite .dump | sqlite3 db3.sqlite 

there no sqlite 2 driver modern language (except perl , php).


Comments

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

delphi - Indy UDP Read Contents of Adata -

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -