Android Open Source - ormada H S Q L Dialect

• Back to Database/library  ↑

From Project

Back to project page ormada.

License

The source code is released under:

Copyright (c) 2012 Jesse Rosalia Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Sof...

Java Source Code

package org.ormada.hsql.dialect;
//from  www  .  ja va 2 s .  co  m
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import org.ormada.ORMDataSource;
import org.ormada.dialect.AStandardSQLDialect;
import org.ormada.model.ORMeta;

/**
 * An ORMada dialect for HyperSQL DB.
 * 
 * NOTE: currently only supports file based, in process DBs
 * @author Jesse Rosalia
 *
 */
public class HSQLDialect extends AStandardSQLDialect {

    private static int CURRENT_DIALECT_VERSION = 1;

  private String dbPath;
    private int    dbVersion;

  public HSQLDialect(String dbPath, int dbVersion) {
    this.dbPath    = dbPath;
    this.dbVersion = dbVersion;
  }

  @Override
  public void open(ORMDataSource orm) throws SQLException {

      //must be done before doing anything else
      orm.setUseORMeta(true);
      
    try {
      Class.forName("org.hsqldb.jdbc.JDBCDriver");
    } catch (Exception e) {
      throw new RuntimeException("ERROR: failed to load HSQLDB JDBC driver.", e);
    }

    Connection connection = DriverManager.getConnection("jdbc:hsqldb:file:"
        + this.dbPath, "SA", "");
    super.setConnection(connection);

    ORMeta meta = orm.getMetaData();
    if (meta == null) {
        orm.createAllTables(this.dbVersion);
    } else if (meta.getDbVersion() != this.dbVersion) {
        orm.upgradeAllTables(meta.getDbVersion(), this.dbVersion);
    }
  }
}

Java Source Code List

• Back to Database/library  ↑