registerColumnType( Types.BIT, "TINYINT" ); registerColumnType( Types.BIGINT, "BIGINT" ); registerColumnType( Types.SMALLINT, "SMALLINT" ); registerColumnType( Types.TINYINT, "TINYINT" ); registerColumnType( Types.INTEGER, "INTEGER" ); registerColumnType( Types.CHAR, "CHAR(1)" ); registerColumnType( Types.VARCHAR, "VARCHAR($l)" ); registerColumnType( Types.FLOAT, "FLOAT" ); registerColumnType( Types.DOUBLE, "DOUBLE" ); registerColumnType( Types.DATE, "DATE" ); registerColumnType( Types.TIME, "TIME" ); registerColumnType( Types.TIMESTAMP, "TIMESTAMP" ); registerColumnType( Types.VARBINARY, "VARBINARY($l)" ); registerColumnType( Types.NUMERIC, "DECIMAL($p, $s)" ); registerColumnType( Types.BLOB, "VARBINARY(4000000)" ); registerColumnType( Types.CLOB, "VARCHAR(4000000)" ); getDefaultProperties().setProperty( Environment.USE_STREAMS_FOR_BINARY, "true" ); getDefaultProperties().setProperty( Environment.STATEMENT_BATCH_SIZE, DEFAULT_BATCH_SIZE ); registerFunction( "lower", new StandardSQLFunction( "lower" ) ); registerFunction( "upper", new StandardSQLFunction( "upper" ) ); registerFunction( "rtrim", new StandardSQLFunction( "rtrim" ) ); registerFunction( "concat", new StandardSQLFunction( "concat", StandardBasicTypes.STRING ) ); registerFunction( "mod", new StandardSQLFunction( "mod" ) ); registerFunction( "to_char", new StandardSQLFunction( "to_char", StandardBasicTypes.STRING ) ); registerFunction( "to_date", new StandardSQLFunction( "to_date", StandardBasicTypes.TIMESTAMP ) ); registerFunction( "sysdate", new NoArgSQLFunction( "sysdate", StandardBasicTypes.TIMESTAMP, false ) ); registerFunction( "getdate", new NoArgSQLFunction( "getdate", StandardBasicTypes.TIMESTAMP, false ) );
@Override public LimitHandler getLimitHandler() { if ( isLegacyLimitHandlerBehaviorEnabled() ) { return LegacyFirstLimitHandler.INSTANCE; } return FirstLimitHandler.INSTANCE; }
/** * Constructs a TimesTenDialect */ public TimesTenDialect() { super(); registerColumnType( Types.BIT, "TINYINT" ); registerColumnType( Types.BIGINT, "BIGINT" ); registerColumnType( Types.SMALLINT, "SMALLINT" ); registerColumnType( Types.TINYINT, "TINYINT" ); registerColumnType( Types.INTEGER, "INTEGER" ); registerColumnType( Types.CHAR, "CHAR(1)" ); registerColumnType( Types.VARCHAR, "VARCHAR($l)" ); registerColumnType( Types.FLOAT, "FLOAT" ); registerColumnType( Types.DOUBLE, "DOUBLE" ); registerColumnType( Types.DATE, "DATE" ); registerColumnType( Types.TIME, "TIME" ); registerColumnType( Types.TIMESTAMP, "TIMESTAMP" ); registerColumnType( Types.VARBINARY, "VARBINARY($l)" ); registerColumnType( Types.NUMERIC, "DECIMAL($p, $s)" ); // TimesTen has no BLOB/CLOB support, but these types may be suitable // for some applications. The length is limited to 4 million bytes. registerColumnType( Types.BLOB, "VARBINARY(4000000)" ); registerColumnType( Types.CLOB, "VARCHAR(4000000)" ); getDefaultProperties().setProperty( Environment.USE_STREAMS_FOR_BINARY, "true" ); getDefaultProperties().setProperty( Environment.STATEMENT_BATCH_SIZE, DEFAULT_BATCH_SIZE ); }
public String getLimitString(String querySelect, int offset, int limit) { if ( offset > 0 ) { throw new UnsupportedOperationException( "TimesTen does not support offset" ); } return new StringBuffer( querySelect.length()+8 ) .append(querySelect) .insert( getAfterSelectInsertPoint(querySelect), " first " + limit ) .toString(); }
private IdTableSupport generateIdTableSupport() { return new StandardIdTableSupport( generateIdTableExporter() ) { @Override protected String determineIdTableName(String baseName) { final String name = super.determineIdTableName( baseName ); return name.length() > 30 ? name.substring( 1, 30 ) : name; } }; }
public String getLimitString(String querySelect, int offset, int limit) { if (offset>0) throw new UnsupportedOperationException("sql server has no offset"); return new StringBuffer( querySelect.length()+8 ) .append(querySelect) .insert( getAfterSelectInsertPoint(querySelect), " first " + limit ) .toString(); } }
public TimesTenDialect() { super(); registerColumnType( Types.BIT, "TINYINT" ); registerColumnType( Types.BIGINT, "BIGINT" ); registerColumnType( Types.SMALLINT, "SMALLINT" ); registerColumnType( Types.TINYINT, "TINYINT" ); registerColumnType( Types.INTEGER, "INTEGER" ); registerColumnType( Types.CHAR, "CHAR(1)" ); registerColumnType( Types.VARCHAR, "VARCHAR($l)" ); registerColumnType( Types.FLOAT, "FLOAT" ); registerColumnType( Types.DOUBLE, "DOUBLE" ); registerColumnType( Types.DATE, "DATE" ); registerColumnType( Types.TIME, "TIME" ); registerColumnType( Types.TIMESTAMP, "TIMESTAMP" ); registerColumnType( Types.VARBINARY, "VARBINARY($l)" ); registerColumnType( Types.NUMERIC, "DECIMAL($p, $s)" ); registerColumnType( Types.BLOB, "VARBINARY(4000000)" ); registerColumnType( Types.CLOB, "VARCHAR(4000000)" ); getDefaultProperties().setProperty(Environment.USE_STREAMS_FOR_BINARY, "true"); getDefaultProperties().setProperty(Environment.STATEMENT_BATCH_SIZE, DEFAULT_BATCH_SIZE); registerFunction( "lower", new StandardSQLFunction("lower") ); registerFunction( "upper", new StandardSQLFunction("upper") ); registerFunction( "rtrim", new StandardSQLFunction("rtrim") ); registerFunction( "concat", new StandardSQLFunction("concat", Hibernate.STRING) ); registerFunction( "mod", new StandardSQLFunction("mod") ); registerFunction( "to_char", new StandardSQLFunction("to_char",Hibernate.STRING) ); registerFunction( "to_date", new StandardSQLFunction("to_date",Hibernate.TIMESTAMP) ); registerFunction( "sysdate", new NoArgSQLFunction("sysdate", Hibernate.TIMESTAMP, false) );
@Override public LimitHandler getLimitHandler() { if ( isLegacyLimitHandlerBehaviorEnabled() ) { return LegacyFirstLimitHandler.INSTANCE; } return FirstLimitHandler.INSTANCE; }
public TimesTenDialect() { super(); registerColumnType( Types.BIT, "TINYINT" ); registerColumnType( Types.BIGINT, "BIGINT" ); registerColumnType( Types.SMALLINT, "SMALLINT" ); registerColumnType( Types.TINYINT, "TINYINT" ); registerColumnType( Types.INTEGER, "INTEGER" ); registerColumnType( Types.CHAR, "CHAR(1)" ); registerColumnType( Types.VARCHAR, "VARCHAR($l)" ); registerColumnType( Types.FLOAT, "FLOAT" ); registerColumnType( Types.DOUBLE, "DOUBLE" ); registerColumnType( Types.DATE, "DATE" ); registerColumnType( Types.TIME, "TIME" ); registerColumnType( Types.TIMESTAMP, "TIMESTAMP" ); registerColumnType( Types.VARBINARY, "VARBINARY($l)" ); registerColumnType( Types.NUMERIC, "DECIMAL($p, $s)" ); registerColumnType( Types.BLOB, "VARBINARY(4000000)" ); registerColumnType( Types.CLOB, "VARCHAR(4000000)" ); getDefaultProperties().setProperty(Environment.USE_STREAMS_FOR_BINARY, "true"); getDefaultProperties().setProperty(Environment.STATEMENT_BATCH_SIZE, DEFAULT_BATCH_SIZE); registerFunction( "lower", new StandardSQLFunction("lower") ); registerFunction( "upper", new StandardSQLFunction("upper") ); registerFunction( "rtrim", new StandardSQLFunction("rtrim") ); registerFunction( "concat", new StandardSQLFunction("concat", Hibernate.STRING) ); registerFunction( "mod", new StandardSQLFunction("mod") ); registerFunction( "to_char", new StandardSQLFunction("to_char",Hibernate.STRING) ); registerFunction( "to_date", new StandardSQLFunction("to_date",Hibernate.TIMESTAMP) ); registerFunction( "sysdate", new NoArgSQLFunction("sysdate", Hibernate.DATE, false) );
public TimesTenDialect() { super(); registerColumnType( Types.BIT, "TINYINT" ); registerColumnType( Types.BIGINT, "BIGINT" ); registerColumnType( Types.SMALLINT, "SMALLINT" ); registerColumnType( Types.TINYINT, "TINYINT" ); registerColumnType( Types.INTEGER, "INTEGER" ); registerColumnType( Types.CHAR, "CHAR(1)" ); registerColumnType( Types.VARCHAR, "VARCHAR($l)" ); registerColumnType( Types.FLOAT, "FLOAT" ); registerColumnType( Types.DOUBLE, "DOUBLE" ); registerColumnType( Types.DATE, "DATE" ); registerColumnType( Types.TIME, "TIME" ); registerColumnType( Types.TIMESTAMP, "TIMESTAMP" ); registerColumnType( Types.VARBINARY, "VARBINARY($l)" ); registerColumnType( Types.NUMERIC, "DECIMAL($p, $s)" ); registerColumnType( Types.BLOB, "VARBINARY(4000000)" ); registerColumnType( Types.CLOB, "VARCHAR(4000000)" ); getDefaultProperties().setProperty(Environment.USE_STREAMS_FOR_BINARY, "true"); getDefaultProperties().setProperty(Environment.STATEMENT_BATCH_SIZE, DEFAULT_BATCH_SIZE); registerFunction( "lower", new StandardSQLFunction("lower") ); registerFunction( "upper", new StandardSQLFunction("upper") ); registerFunction( "rtrim", new StandardSQLFunction("rtrim") ); registerFunction( "concat", new StandardSQLFunction("concat", StandardBasicTypes.STRING) ); registerFunction( "mod", new StandardSQLFunction("mod") ); registerFunction( "to_char", new StandardSQLFunction("to_char",StandardBasicTypes.STRING) ); registerFunction( "to_date", new StandardSQLFunction("to_date",StandardBasicTypes.TIMESTAMP) ); registerFunction( "sysdate", new NoArgSQLFunction("sysdate", StandardBasicTypes.TIMESTAMP, false) );
public TimesTenDialect() { super(); registerColumnType( Types.BIT, "TINYINT" ); registerColumnType( Types.BIGINT, "BIGINT" ); registerColumnType( Types.SMALLINT, "SMALLINT" ); registerColumnType( Types.TINYINT, "TINYINT" ); registerColumnType( Types.INTEGER, "INTEGER" ); registerColumnType( Types.CHAR, "CHAR(1)" ); registerColumnType( Types.VARCHAR, "VARCHAR($l)" ); registerColumnType( Types.FLOAT, "FLOAT" ); registerColumnType( Types.DOUBLE, "DOUBLE" ); registerColumnType( Types.DATE, "DATE" ); registerColumnType( Types.TIME, "TIME" ); registerColumnType( Types.TIMESTAMP, "TIMESTAMP" ); registerColumnType( Types.VARBINARY, "VARBINARY($l)" ); registerColumnType( Types.NUMERIC, "DECIMAL($p, $s)" ); registerColumnType( Types.BLOB, "VARBINARY(4000000)" ); registerColumnType( Types.CLOB, "VARCHAR(4000000)" ); getDefaultProperties().setProperty(Environment.USE_STREAMS_FOR_BINARY, "true"); getDefaultProperties().setProperty(Environment.STATEMENT_BATCH_SIZE, DEFAULT_BATCH_SIZE); registerFunction( "lower", new StandardSQLFunction("lower") ); registerFunction( "upper", new StandardSQLFunction("upper") ); registerFunction( "rtrim", new StandardSQLFunction("rtrim") ); registerFunction( "concat", new StandardSQLFunction("concat", StandardBasicTypes.STRING) ); registerFunction( "mod", new StandardSQLFunction("mod") ); registerFunction( "to_char", new StandardSQLFunction("to_char",StandardBasicTypes.STRING) ); registerFunction( "to_date", new StandardSQLFunction("to_date",StandardBasicTypes.TIMESTAMP) ); registerFunction( "sysdate", new NoArgSQLFunction("sysdate", StandardBasicTypes.TIMESTAMP, false) );