private final void setSqlStrings() {
String idWhereClause = JdbcUtil.getIDWhereClause(extendedSessionIdSupported);
String idColumns = JdbcUtil.getIDColumns(extendedSessionIdSupported);
String idPlaceholders = JdbcUtil.getIDPlaceholders(extendedSessionIdSupported);
SQL_UPDATE_SEQNUMS =
"UPDATE "
+ sessionTableName
+ " SET incoming_seqnum=?, "
+ "outgoing_seqnum=? WHERE "
+ idWhereClause;
SQL_INSERT_SESSION =
"INSERT INTO "
+ sessionTableName
+ " ("
+ idColumns
+ ", creation_time,incoming_seqnum, outgoing_seqnum) VALUES ("
+ idPlaceholders
+ ",?,?,?)";
SQL_GET_SEQNUMS =
"SELECT creation_time, incoming_seqnum, outgoing_seqnum FROM "
+ sessionTableName
+ " WHERE "
+ idWhereClause;
SQL_UPDATE_MESSAGE =
"UPDATE "
+ messageTableName
+ " SET message=? "
+ "WHERE "
+ idWhereClause
+ " and msgseqnum=?";
SQL_INSERT_MESSAGE =
"INSERT INTO "
+ messageTableName
+ " ("
+ idColumns
+ ", msgseqnum,message) VALUES ("
+ idPlaceholders
+ ",?,?)";
SQL_GET_MESSAGES =
"SELECT message FROM "
+ messageTableName
+ " WHERE "
+ idWhereClause
+ " and msgseqnum>=? and msgseqnum<=? "
+ "ORDER BY msgseqnum";
SQL_UPDATE_SESSION =
"UPDATE "
+ sessionTableName
+ " SET creation_time=?, "
+ "incoming_seqnum=?, outgoing_seqnum=? "
+ "WHERE "
+ idWhereClause;
SQL_DELETE_MESSAGES = "DELETE FROM " + messageTableName + " WHERE " + idWhereClause;
}
