@Override public String getDeleteRowSql() { if (deleteRowSql == null) { deleteRowSql = String.format("DELETE FROM %s WHERE %s = cast(? as %s)", getTableName(), config.idColumnName(), config.idColumnType()); } return deleteRowSql; }
@Override public String getDeleteRowSql() { if (deleteRowSql == null) { deleteRowSql = String.format("DELETE FROM %s WHERE %s = convert(%s,?)", getTableName(), config.idColumnName(), config.idColumnType()); } return deleteRowSql; }
@Override public String getSelectMultipleRowSql(int numberOfParams) { String selectCriteria = config.idColumnName() + " = convert(" + config.idColumnType() + ",?)"; return getSelectMultipleRowSql(numberOfParams, selectCriteria); }
@Override public String getSelectMultipleRowSql(int numberOfParams) { String selectCriteria = config.idColumnName() + " = cast(? as " + config.idColumnType() + ")"; return getSelectMultipleRowSql(numberOfParams, selectCriteria); }
@Override public String getSelectIdRowSql() { if (selectIdRowSql == null) { selectIdRowSql = String.format("SELECT %s FROM %s WHERE %s = cast(? as %s)", config.idColumnName(), getTableName(), config.idColumnName(), config.idColumnType()); } return selectIdRowSql; }
@Override public String getSelectIdRowSql() { if (selectIdRowSql == null) { selectIdRowSql = String.format("SELECT %s FROM %s WHERE %s = convert(%s,?)", config.idColumnName(), getTableName(), config.idColumnName(), config.idColumnType()); } return selectIdRowSql; }
@Override public String getUpdateRowSql() { if (updateRowSql == null) { updateRowSql = String.format("UPDATE %s SET %s = ? , %s = ? WHERE %s = cast(? as %s)", getTableName(), config.dataColumnName(), config.timestampColumnName(), config.idColumnName(), config.idColumnType()); } return updateRowSql; }
@Override public String getSelectRowSql() { if (selectRowSql == null) { selectRowSql = String.format("SELECT %s, %s FROM %s WHERE %s = cast(? as %s)", config.idColumnName(), config.dataColumnName(), getTableName(), config.idColumnName(), config.idColumnType()); } return selectRowSql; }
@Override public String getSelectRowSql() { if (selectRowSql == null) { selectRowSql = String.format("SELECT %s, %s FROM %s WHERE %s = convert(%s,?)", config.idColumnName(), config.dataColumnName(), getTableName(), config.idColumnName(), config.idColumnType()); } return selectRowSql; }
@Override public String getUpdateRowSql() { if (updateRowSql == null) { updateRowSql = String.format("UPDATE %s SET %s = ? , %s = ? WHERE %s = convert(%s,?)", getTableName(), config.dataColumnName(), config.timestampColumnName(), config.idColumnName(), config.idColumnType()); } return updateRowSql; }
public void createTable(Connection conn) throws PersistenceException { if (cacheName == null || cacheName.trim().length() == 0) throw new PersistenceException("cacheName needed in order to create table"); String ddl; if (metaData.isSegmentedDisabled()) { ddl = String.format("CREATE TABLE %1$s (%2$s %3$s NOT NULL, %4$s %5$s NOT NULL, %6$s %7$s NOT NULL, PRIMARY KEY (%2$s))", getTableName(), config.idColumnName(), config.idColumnType(), config.dataColumnName(), config.dataColumnType(), config.timestampColumnName(), config.timestampColumnType()); } else { ddl = String.format("CREATE TABLE %1$s (%2$s %3$s NOT NULL, %4$s %5$s NOT NULL, %6$s %7$s NOT NULL, %8$s %9$s NOT NULL, PRIMARY KEY (%2$s))", getTableName(), config.idColumnName(), config.idColumnType(), config.dataColumnName(), config.dataColumnType(), config.timestampColumnName(), config.timestampColumnType(), config.segmentColumnName(), config.segmentColumnType()); } if (log.isTraceEnabled()) { log.tracef("Creating table with following DDL: '%s'.", ddl); } executeUpdateSql(conn, ddl); }
assert store.table().tableNamePrefix().equals("STRINGS_"); assert store.table().idColumnName().equals("id"); assert store.table().idColumnType().equals("VARCHAR"); assert store.table().dataColumnName().equals("datum"); assert store.table().dataColumnType().equals("BINARY"); assert store2.table().tableNamePrefix().equals("STRINGS_"); assert store2.table().idColumnName().equals("id"); assert store2.table().idColumnType().equals("VARCHAR"); assert store2.table().dataColumnName().equals("datum"); assert store2.table().dataColumnType().equals("BINARY");