How to connect HSQL (file based) with my android a

Question

Hello I have a problem connecting my android app to HSQLDB.

First question:

Is there a specific android jar for HSQLDB that i should use or could I use any HSQL jar?

Second question:

If I can use the provided jar. How can I get the connection to work and what should I place in the Class.forName("") as I was getting a ClassNotFoundException error when using: Class.forName("org.hsqldb.jdbc.JDBCDriver") or Class.forName("org.hsqldb.jdbc.JDBCDriver").newInstance() ?

Thank you.

Answer 1

I have been able to establish a connection to an HSqlDB in Android 4.1.

Anyone who's looking to do this in Eclipse, make sure you have the hsqldb.jar in your libraries and make sure it's exported. All of this is in the Project > Java Build Path in Eclipse.

I'm able to make a connection and it has created a new set of database files. I'm using a file based db. Specifically I'm building a LibGDX game for Ouya, but it should work for any android project. The code that runs Hsql is in a completely different project from the Android project, so I needed to have it as a library for both, and to have it exported from the Android project.