public String getDeleteRowSql() { if (deleteRowSql == null) { switch (getDialect()) { case SYBASE: deleteRowSql = "DELETE FROM " + getTableName() + " WHERE " + config.idColumnName() + " = convert(" + config.idColumnType() + "," + "?)"; break; case POSTGRES: deleteRowSql = "DELETE FROM " + getTableName() + " WHERE " + config.idColumnName() + " = cast(? as " + config.idColumnType() + ")"; break; default: deleteRowSql = "DELETE FROM " + getTableName() + " WHERE " + config.idColumnName() + " = ?"; break; } } return deleteRowSql; }
public String getSelectRowSql() { if (selectRowSql == null) { switch (getDialect()) { case SYBASE: selectRowSql = "SELECT " + config.idColumnName() + ", " + config.dataColumnName() + " FROM " + getTableName() + " WHERE " + config.idColumnName() + " = convert(" + config.idColumnType() + "," + "?)"; break; case POSTGRES: selectRowSql = "SELECT " + config.idColumnName() + ", " + config.dataColumnName() + " FROM " + getTableName() + " WHERE " + config.idColumnName() + " = cast(? as " + config.idColumnType() + ")"; break; default: selectRowSql = "SELECT " + config.idColumnName() + ", " + config.dataColumnName() + " FROM " + getTableName() + " WHERE " + config.idColumnName() + " = ?"; break; } } return selectRowSql; }
public String getUpdateRowSql() { if (updateRowSql == null) { switch (getDialect()) { case SYBASE: updateRowSql = "UPDATE " + getTableName() + " SET " + config.dataColumnName() + " = ? , " + config.timestampColumnName() + "=? WHERE " + config.idColumnName() + " = convert(" + config.idColumnType() + "," + "?)"; break; case POSTGRES: updateRowSql = "UPDATE " + getTableName() + " SET " + config.dataColumnName() + " = ? , " + config.timestampColumnName() + "=? WHERE " + config.idColumnName() + " = cast(? as " + config.idColumnType() + ")"; break; default: updateRowSql = "UPDATE " + getTableName() + " SET " + config.dataColumnName() + " = ? , " + config.timestampColumnName() + "=? WHERE " + config.idColumnName() + " = ?"; break; } } return updateRowSql; }
public void createTable(Connection conn) throws PersistenceException { // removed CONSTRAINT clause as this causes problems with some databases, like Informix. assertMandatoryElementsPresent(); String createTableDdl = "CREATE TABLE " + getTableName() + "(" + config.idColumnName() + " " + config.idColumnType() + " NOT NULL, " + config.dataColumnName() + " " + config.dataColumnType() + ", " + config.timestampColumnName() + " " + config.timestampColumnType() + ", PRIMARY KEY (" + config.idColumnName() + "))"; if (trace) { log.tracef("Creating table with following DDL: '%s'.", createTableDdl); } executeUpdateSql(conn, createTableDdl); }