Android Example RDC - Simple way to create your own back-end database

Remote Database Connector (RDC) is a middleware web server that allows you to easily connect your Android app to any type of remote database server.
Usually you will use it with a database server (MySQL, DB2, etc...).

However you can also use RDC without a database server. Instead you can use a SQLite database file. In that case the database server is not needed.

This is done with sqlite-jdbc driver. This is an open source project that provides a JDBC driver for SQLite databases.

You can download the driver here (sqlite-jdbc-3.7.2.jar): https://bitbucket.org/xerial/sqlite-jdbc/downloads

Configuration:

1. Copy the jar file to the jdbc_driver folder.
2. Set the following lines in config.properties (change the path to your database file):
   
   DriverClass=org.sqlite.JDBC
   JdbcUrl=jdbc:sqlite:C:/temp/test.db
3. SQLite doesn't support concurrent writings. So it is better to limit the connection pool to a single connection. This means that if there are multiple requests at parallel they will wait for the previous transaction to complete.
   To limit the connection pool you need to edit c3p0.properties and add:
   
   c3p0.minPoolSize=1
   c3p0.maxPoolSize=1

You can use a tool such as SQLite Expert to open the database and administrate it: http://www.sqliteexpert.com/download.html

 

[Erel]

There is no reason to use RDC (1). You should use the latest version which is jRDC2. If you encounter any error then please start a new thread.

 

[vecino]

Hello, does RDC work with "ElevateDB"?
http://www.elevatesoft.com/

 

[Erel]

It works with any database engine that has a JDBC driver. You should check whether they provide such a driver.

This thread is locked. New projects should use jRDC2 (https://www.b4x.com/search?query=jRDC2).