• Home
• io.ebean
• ebean-platform-hana
• 14.1.0
• source code
• HanaPlatform.java

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

io.ebean.platform.hana.HanaPlatform Maven / Gradle / Ivy

package io.ebean.platform.hana;

import io.ebean.Query;
import io.ebean.Query.LockWait;
import io.ebean.annotation.PersistBatch;
import io.ebean.annotation.Platform;
import io.ebean.config.PlatformConfig;
import io.ebean.config.dbplatform.*;

public class HanaPlatform extends DatabasePlatform {

  public HanaPlatform() {
    this.platform = Platform.HANA;
    this.sqlLimiter = new LimitOffsetSqlLimiter();
    this.persistBatchOnCascade = PersistBatch.NONE;
    this.supportsResultSetConcurrencyModeUpdatable = false;
    this.historySupport = new HanaHistorySupport();
    this.basicSqlLimiter = new HanaBasicSqlLimiter();

    this.likeClauseRaw = "like ?";
    this.maxConstraintNameLength = 127;
    this.maxTableNameLength = 127;

    this.dbDefaultValue.setNow("current_timestamp");

    this.exceptionTranslator = new SqlErrorCodes().addAcquireLock("131", "133", "146")
      .addDataIntegrity("130", "429", "461", "462").addDuplicateKey("144", "301", "349").build();

    this.dbIdentity.setIdType(IdType.IDENTITY);
    this.dbIdentity.setSelectLastInsertedIdTemplate("select current_identity_value() from sys.dummy");
    this.dbIdentity.setSupportsGetGeneratedKeys(false);
    this.dbIdentity.setSupportsIdentity(true);

    this.dbTypeMap.put(DbType.BIGINT, new DbPlatformType("bigint", false));
    this.dbTypeMap.put(DbType.BINARY, new DbPlatformType("varbinary", 255));
    this.dbTypeMap.put(DbType.BIT, new DbPlatformType("smallint", false));

    this.dbTypeMap.put(DbType.CHAR, new DbPlatformType("nvarchar", 255));

    this.dbTypeMap.put(DbType.INTEGER, new DbPlatformType("integer", false));
    this.dbTypeMap.put(DbType.JSONVARCHAR, new DbPlatformType("nvarchar", 255));
    this.dbTypeMap.put(DbType.LINESTRING, new DbPlatformType("st_geometry"));
    this.dbTypeMap.put(DbType.LONGVARBINARY, new DbPlatformType("blob", false));
    this.dbTypeMap.put(DbType.LONGVARCHAR, new DbPlatformType("nclob", false));
    this.dbTypeMap.put(DbType.MULTILINESTRING, new DbPlatformType("st_geometry"));
    this.dbTypeMap.put(DbType.MULTIPOINT, new DbPlatformType("st_geometry"));
    this.dbTypeMap.put(DbType.MULTIPOLYGON, new DbPlatformType("st_geometry"));
    this.dbTypeMap.put(DbType.POINT, new DbPlatformType("st_point"));
    this.dbTypeMap.put(DbType.POLYGON, new DbPlatformType("st_geometry"));
    this.dbTypeMap.put(DbType.SMALLINT, new DbPlatformType("smallint", false));
    this.dbTypeMap.put(DbType.TINYINT, new DbPlatformType("smallint", false));
    this.dbTypeMap.put(DbType.UUID, new DbPlatformType("varchar", 40));

    DbPlatformType nclob = new DbPlatformType("nclob", false);
    dbTypeMap.put(DbType.VARCHAR, new DbPlatformType("nvarchar", 255, 5000, nclob));
    this.dbTypeMap.put(DbType.CLOB, nclob);

    DbPlatformType blob = new DbPlatformType("blob", false);
    this.dbTypeMap.put(DbType.VARBINARY, new DbPlatformType("varbinary", 255, 5000, blob));
    this.dbTypeMap.put(DbType.BLOB, blob);
  }

  @Override
  protected void addGeoTypes(int srid) {
    this.dbTypeMap.put(DbType.LINESTRING, new DbPlatformType("st_geometry(" + srid + ")", false));
    this.dbTypeMap.put(DbType.MULTILINESTRING, new DbPlatformType("st_geometry(" + srid + ")", false));
    this.dbTypeMap.put(DbType.MULTIPOINT, new DbPlatformType("st_geometry(" + srid + ")", false));
    this.dbTypeMap.put(DbType.MULTIPOLYGON, new DbPlatformType("st_geometry(" + srid + ")", false));
    this.dbTypeMap.put(DbType.POINT, new DbPlatformType("st_point(" + srid + ")", false));
    this.dbTypeMap.put(DbType.POLYGON, new DbPlatformType("st_geometry(" + srid + ")", false));
  }

  @Override
  protected String withForUpdate(String sql, LockWait lockWait, Query.LockType lockType) {
    switch (lockWait) {
      case WAIT:
        return sql + " for update";
      case NOWAIT:
        return sql + " for update nowait";
      case SKIPLOCKED:
        return sql + " for update ignore locked";
      default:
        throw new IllegalArgumentException("Unknown update mode: " + lockWait);
    }
  }

  @Override
  protected void configure(PlatformConfig config, boolean allQuotedIdentifiers) {
    super.configure(config, allQuotedIdentifiers);
    if (config.getDbUuid().useBinary()) {
      this.dbTypeMap.put(DbType.UUID, new DbPlatformType("varbinary", 16));
    } else {
      this.dbTypeMap.put(DbType.UUID, new DbPlatformType("varchar", 40));
    }
  }

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