Using SQL (JDBC) database in Android

Question

In an old Java application I have the following code to connect to a SQL database and use it for some queries:

private Connection dbConnection = null;
System.setProperty("derby.system.home", "C:\\");
Class.forName("org.apache.derby.jdbc.EmbeddedDriver");
String strUrl = "jdbc:derby:BOOKSDB";
dbConnection = DriverManager.getConnection(strUrl);
Statement stmt = dbConnection.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM BOOKS");

Is there any chance to use it on Android? The documentation say that it is possible in general, isn't it? But how can one use it?

Or would it be easier to change this part so that it uses SQLite instead? I think this is much work to do because with SQLite, you always have a cursor instead of a ResultSet and so on ...

antlersoft · Accepted Answer · 2012-03-02 23:40:41Z

1

You can use JDBC on android, provided you supply a JDBC driver that will run on Android. There is a open source pure-Java jdbc driver that should run on Android (although I haven't tried it myself). You will have to adapt the JDBC URL to connect to the sqlite db; that way you can use the local android database while making few changes to your data access code.

answered Mar 2, 2012 at 23:40

antlersoft

14.8k4 gold badges40 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

caw Over a year ago

Thank you very much! I ended up using SQLDroid.

Collectives™ on Stack Overflow

Using SQL (JDBC) database in Android

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related