DM-A-SQLConnector

DM-A-SQLConnector is a JDBC driver for Android's sqlite database (android.database.sqlite.SQLiteDatabase) originally conceived by Kristian Lein-Mathisen with the project name ASQLConnector.

DM-A-SQLConnector lets you access your app's database through JDBC. Android ships with the necessary interfaces needed to use JDBC drivers, but it does not officially ship with a driver for its built-in SQLite database engine. When porting code from other projects, you can conveniently replace the JDBC url to jdbc:asqlconnector to access an SQLite database on Android.

How to use it ?

Download with Gradle :

• Adapt into your build.gradle file, the next code (minimum Java version is 11) :

     ...
     dependencies {
         ...
         api(group:'fr.distrimind.oss.asqlconnector', name: 'DM-A-SQLConnector', version: '1.0.3-STABLE')
         //optional : under Android 
         implementation(group:'fr.distrimind.oss.flexilogxml.android', name: 'DM-FlexiLogXML-Android', version: '2.2.0-STABLE')
         ...
     }
     ...
  

• Libraries are available on Maven Central. You can check signatures of dependencies with this public GPG key. You can also use the next repository :

      ...
      repositories {
          ...
          maven {
                  url "https://artifactory.distri-mind.fr/ui/native/gradle-release/"
          }
          ...
      }
      ...
  

To know what is the last uploaded version, please refer to versions available here : this repository

Download with Maven :

• Adapt into your pom.xml file, the next code (minimum Java version is 11) :

      ...
      <project>
          ...
          <dependencies>
              ...
              <dependency>
                  <groupId>fr.distrimind.oss.asqlconnector</groupId>
                  <artifactId>DM-A-SQLConnector</artifactId>
                  <version>1.0.3-STABLE</version>
              </dependency>  
              <-- optional : under Android -->
              <dependency>
                  <groupId>fr.distrimind.oss.flexilogxml.android</groupId>
                  <artifactId>DM-FlexiLogXML-Android</artifactId>
                  <version>2.2.0-STABLE</version>
              </dependency>
              ...
          </dependencies>
          ...
      </project>
      ...
  

• Libraries are available on Maven Central. You can check signatures of dependencies with this public GPG key. You can also use the next repository :

      ...
      <repositories>
          ...
          <repository>
              <id>DistriMind-Public</id>
              <url>https://artifactory.distri-mind.fr/ui/native/gradle-release/</url>
          </repository>
          ...
      </repositories>
      ...		
  

To know what last version has been uploaded, please refer to versions available into this repository

Usage

Here is a minimal example of an Android Activity implemented in Java with DM-A-SQLConnector.

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.Driver;
import java.sql.SQLException;
import fr.distrimind.oss.flexilogxml.common.ReflectionTools;

public class MainActivity extends AppCompatActivity {

    private Connection connection;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        try {
            DriverManager.registerDriver((Driver) ReflectionTools.getClassLoader().loadClass("fr.distrimind.oss.asqlconnector.ASQLConnectorDriver").getConstructor().newInstance());
        } catch (Exception e) {
            throw new RuntimeException("Failed to register ASQLConnectorDriver");
        }
        String jdbcUrl = "jdbc:asqlconnector:" + "/data/data/" + getPackageName() + "/my-database.db";
        try {
            this.connection = DriverManager.getConnection(jdbcUrl);
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

    @Override
    public void onDestroy() {
        if (connection != null) {
            try {
                connection.close();
            } catch (SQLException e) {
                throw new RuntimeException(e);
            }
        }
        super.onDestroy();
    }
}

Debug output

You can turn on resultset dumps like this

fr.distrimind.oss.asqlconnector.ASQLConnectorResultSet.dump = true;

License

This code is free software: you can redistribute it and/or modify it under the terms of the MIT License