Example usage for org.hibernate.dialect Dialect getCreateTableString

Introduction

In this page you can find the example usage for org.hibernate.dialect Dialect getCreateTableString.

Prototype

public String getCreateTableString() 

Source Link

Document

Command used to create a table.

Usage

From source file:com.redprairie.moca.server.db.TU_JDBCAdapter.java

License:Open Source License

private void createTableAndInsert(DBType dbType, Connection connection, long insertCount) throws SQLException {
    DialectFactoryImpl dialectFactory = new DialectFactoryImpl();
    dialectFactory.setClassLoaderService(new ClassLoaderServiceImpl());

    Dialect dialect;
    switch (dbType) {
    case MSSQL:/*from   w  ww.j a va  2  s .  c om*/
        dialect = dialectFactory.buildDialect(
                Collections.singletonMap(AvailableSettings.DIALECT, UnicodeSQLServerDialect.class.getName()),
                null);
        break;
    case ORACLE:
        dialect = dialectFactory.buildDialect(
                Collections.singletonMap(AvailableSettings.DIALECT, Oracle10gDialect.class.getName()), null);
        break;
    case H2:
        dialect = dialectFactory.buildDialect(
                Collections.singletonMap(AvailableSettings.DIALECT, H2Dialect.class.getName()), null);
        break;
    default:
        throw new RuntimeException("There was no database supplied!");
    }
    StringBuilder tableCreate = new StringBuilder().append(dialect.getCreateTableString()).append(' ')
            .append(TABLENAME).append(" ( name ").append(dialect.getTypeName(Types.INTEGER)).append(" )");

    Statement stmt = connection.createStatement();
    try {
        stmt.execute(tableCreate.toString());
    } finally {
        stmt.close();
    }

    PreparedStatement pstmt = connection.prepareStatement("INSERT INTO QueryLimitTable (name) VALUES(?)");

    try {
        for (long i = 0; i < insertCount; i++) {
            pstmt.setLong(1, i);
            pstmt.addBatch();
        }

        pstmt.executeBatch();
    } finally {
        pstmt.close();
    }
}

---

From source file:de.innovationgate.webgate.api.mysql.GaleraClusterTableGenerator.java

License:Open Source License

@Override
public String[] sqlCreateStrings(Dialect dialect) throws HibernateException {
    return new String[] { new StringBuilder().append(dialect.getCreateTableString()).append(' ')
            .append(tableName).append(" ( ").append(segmentColumnName).append(' ')
            .append(dialect.getTypeName(Types.VARCHAR, segmentValueLength, 0, 0)).append(" not null ")
            .append(",  ").append(valueColumnName).append(' ').append(dialect.getTypeName(Types.BIGINT))
            .append(", primary key ( ").append(segmentColumnName).append(" ) ) ").toString() };
}

---

From source file:net.e6tech.elements.persist.hibernate.ModifiedTableGenerator.java

License:Apache License

@Override
public String[] sqlCreateStrings(Dialect dialect) throws HibernateException {
    return new String[] { dialect.getCreateTableString() + ' ' + renderedTableName + " ( " + segmentColumnName
            + ' ' + dialect.getTypeName(Types.VARCHAR, segmentValueLength, 0, 0) + " not null " + ", "
            + valueColumnName + ' ' + dialect.getTypeName(Types.BIGINT) + ", primary key ( " + segmentColumnName
            + " ) )" + dialect.getTableTypeString() };
}

---

From source file:org.opentaps.foundation.entity.hibernate.OpentapsIdentifierGenerator.java

License:Open Source License

/**
 * The SQL required to create the underlying database objects.
 *
 * @param dialect The dialect against which to generate the create command(s)
 * @return The create sql//from   w  ww .  j av a 2  s  .c om
 * @throws HibernateException problem creating the sql
 */
public String[] sqlCreateStrings(Dialect dialect) throws HibernateException {
    // build create table ddl sql with specific dialect
    return new String[] { new StringBuffer().append(dialect.getCreateTableString()).append(' ')
            .append(SEQUENCE_TABLE_NAME).append(" (").append(SEQUENCE_TYPE_COLUMN).append(' ')
            .append(dialect.getTypeName(Types.VARCHAR, SEQUENCE_MAX_LENGTH, 0, 0)).append(" not null ")
            .append(",  ").append(SEQUENCE_VALUE_COLUMN).append(' ').append(dialect.getTypeName(Types.BIGINT))
            .append(", primary key (").append(SEQUENCE_TYPE_COLUMN).append(")) ").toString() };
}

---