Manifest-Version: 1.0
Bundle-ManifestVersion: 2
Bundle-Name: Sqlite jdbc connector
Bundle-SymbolicName: demo.sqlite.fragment
Bundle-Version: 3.8.10.1
Fragment-Host: org.eclipse.scout.rt.server (I've also tried using system.bundle here but it doesn't make a difference)
Bundle-RequiredExecutionEnvironment: JavaSE-1.7
Bundle-ClassPath: lib/sqlite-jdbc-3.8.10.1.jar

public class SqliteSqlService extends AbstractSqlService {

  @Override
  protected String getConfiguredJdbcDriverName() {
    return "org.sqlite.JDBC";
  }

  @Override
  protected String getConfiguredJdbcMappingName() {
    return "jdbc:sqlite:D:\\\\workspaces\\\\demo\\\\database\\\\sqlite.db3";
  }
}

public class AbstractSqliteSqlService extends AbstractSqlService {

	  @Override
	  protected String getConfiguredJdbcDriverName() {
	    return "org.sqlite.JDBC";
	  }

	  @Override
	  protected String getConfiguredJdbcMappingName() {
	    return "jdbc:sqlite:[file]";
	  }

	  @Override
	  protected Class<? extends ISqlStyle> getConfiguredSqlStyle() {
	    return SqliteSqlStyle.class;
	  }

}

public class SqliteSqlStyle extends AbstractSqlStyle {
  private static final long serialVersionUID = 1L;

  @Override
  public String getConcatOp() {
    return "||";
  }

  @Override
  public String getLikeWildcard() {
    return "%";
  }

  @Override
  protected int getMaxListSize() {
    return MAX_LIST_SIZE;
  }

  @Override
  public boolean isLargeString(String s) {
    return (s.length() > MAX_SQL_STRING_LENGTH);
  }

  @Override
  public boolean isBlobEnabled() {
    return true;
  }

  @Override
  public boolean isClobEnabled() {
    return true;
  }

  @Override
  public void testConnection(Connection conn) throws SQLException {
    Statement testStatement = null;
    try {
      testStatement = conn.createStatement();
      testStatement.execute("SELECT 1");
    }
    finally {
      if (testStatement != null) {
        try {
          testStatement.close();
        }
        catch (Throwable t) {
        }
      }
    }
  }

}