/** * Initialize any platform-specific operators */ @Override protected void initializePlatformOperators() { super.initializePlatformOperators(); // Derby does not support DECIMAL, but does have a DOUBLE function. addOperator(ExpressionOperator.simpleFunction(ExpressionOperator.ToNumber, "DOUBLE")); addOperator(extractOperator()); }
/** * Used for stored procedure defs. */ @Override public String getProcedureBeginString() { return getBatchBeginString(); }
/** * Used for stored procedure defs. */ @Override public String getProcedureEndString() { return getBatchEndString(); }
writer.write(" SET "); String tempTableName = getTempTableForTable(table).getQualifiedNameDelimited(this); boolean isFirst = true; Iterator itFields = assignedFields.iterator(); writer.write(" FROM "); writer.write(tempTableName); writeAutoJoinWhereClause(writer, null, tableName, pkFields, this); writer.write(")"); writer.write(" FROM "); writer.write(tempTableName); writeAutoJoinWhereClause(writer, null, tableName, pkFields, this); writer.write(")");
DerbyPlatform dp = new DerbyPlatform(); dp.setDelimitedIdentifierModeOn(true); Database dbs = new Database(); DerbyModelReader dmr = new DerbyModelReader(dp); Database test = dmr.getDatabase(conn, "MyDBTest"); DerbyBuilder db = new DerbyBuilder(dp); String testSqlDerby = dp.getCreateTablesSql(test, true, true); System.out.println(testSqlDerby); System.out.println("\n\n\n\n"); MySql50Platform mp = new MySql50Platform(); mp.setDelimitedIdentifierModeOn(true); MySqlBuilder mb = new MySqlBuilder(mp); String testSqlMysql = mp.getCreateTablesSql(test, true, true); System.out.println(testSqlMysql);
public void useDerby() { if (getPlatform().isDerby()) { return; } DatabasePlatform newPlatform = new DerbyPlatform(); getPlatform().copyInto(newPlatform); setPlatform(newPlatform); }
/** * Initialize any platform-specific operators */ protected void initializePlatformOperators() { super.initializePlatformOperators(); // Derby does not support DECIMAL, but does have a DOUBLE function. addOperator(ExpressionOperator.simpleFunction(ExpressionOperator.ToNumber, "DOUBLE")); }
if (!(shouldUseRownumFiltering()) || (!(max > 0) && !(firstRow > 0))) { call.setFields(statement.printSQL(printer)); statement.appendForUpdateClause(printer);
writer.write(" SET "); String tempTableName = getTempTableForTable(table).getQualifiedNameDelimited(this); boolean isFirst = true; Iterator itFields = assignedFields.iterator(); writer.write(" FROM "); writer.write(tempTableName); writeAutoJoinWhereClause(writer, null, tableName, pkFields, this); writer.write(")"); writer.write(" FROM "); writer.write(tempTableName); writeAutoJoinWhereClause(writer, null, tableName, pkFields, this); writer.write(")");
public void useDerby() { if (getPlatform().isDerby()) { return; } DatabasePlatform newPlatform = new DerbyPlatform(); getPlatform().copyInto(newPlatform); setPlatform(newPlatform); }
if (!(shouldUseRownumFiltering()) || (!(max > 0) && !(firstRow > 0))) { call.setFields(statement.printSQL(printer)); statement.appendForUpdateClause(printer);
writer.write(" SET "); String tempTableName = getTempTableForTable(table).getQualifiedNameDelimited(this); boolean isFirst = true; Iterator itFields = assignedFields.iterator(); writer.write(" FROM "); writer.write(tempTableName); writeAutoJoinWhereClause(writer, null, tableName, pkFields, this); writer.write(")"); writer.write(" FROM "); writer.write(tempTableName); writeAutoJoinWhereClause(writer, null, tableName, pkFields, this); writer.write(")");
/** * Initialize any platform-specific operators */ @Override protected void initializePlatformOperators() { super.initializePlatformOperators(); // Derby does not support DECIMAL, but does have a DOUBLE function. addOperator(ExpressionOperator.simpleFunction(ExpressionOperator.ToNumber, "DOUBLE")); addOperator(extractOperator()); }
public void useDerby() { if (getPlatform().isDerby()) { return; } DatabasePlatform newPlatform = new DerbyPlatform(); getPlatform().copyInto(newPlatform); setPlatform(newPlatform); }
/** * Used for stored procedure defs. */ @Override public String getProcedureBeginString() { return getBatchBeginString(); }
/** * Used for stored procedure defs. */ public String getProcedureEndString() { return getBatchEndString(); }
/** * Used for stored procedure defs. */ public String getProcedureBeginString() { return getBatchBeginString(); }
/** * Used for stored procedure defs. */ @Override public String getProcedureEndString() { return getBatchEndString(); }