Derby/JavaDB vs SQLiteJDBC

java sqlite derby javadb sqlitejdbc
Tom Brito picture Tom Brito · Apr 26, 2010 · Viewed 12.3k times · Source

I found a lot of comparisions here, but not this one; So, what is best in each one?

Answer

mgv picture mgv · Apr 26, 2010

There's a full comparison at SQLite's site.

SQLite is much more restricted, as it only supports a small subset of SQL92, whereas Derby (now JavaDB) has full support of SQL92 and SQL99.

Related questions

SQLite in Android How to update a specific row

I've been trying to update a specific row for a while now, and it seems that there are two ways to do this. From what I've read and tried, you can just use the: execSQL(String sql) method or the: …

Read More
Java and SQLite

I'm attracted to the neatness that a single file database provides. What driver/connector library is out there to connect and use SQLite with Java. I've discovered a wrapper library, http://www.ch-werner.de/javasqlite, but are there other more …

Read More
Most simple code to populate JTable from ResultSet

I googled the whole day and no luck. I call getnPrintAllData() method after pressing OK button. So the code is: public class DatabaseSQLiteConnection { Connection conn = null; PreparedStatement statement = null; ResultSet res = null; public DatabaseSQLiteConnection(){ try{ Class.forName("org.sqlite.JDBC"); …

Read More