// topic
Topic topic = new TopicImpl();
topic.setTitle("my title");
// create a message idem to the one in the database
Message message = new MessageImpl();
message.setBoard(board);
message.setTopic(topic);
message.setPostedBy(user);
// to test Date
SimpleDateFormat dateFormat = new SimpleDateFormat("dd/mm/yyyy hh:mm");
Date date = dateFormat.parse("01/01/2001 13:24");
message.setPostedDate(date);
message.setContent("super movie! great work");
message.setPersistanceVersion(1);
messageMapper.addOrUpdate(message);
// check
String query = "select * from MESSAGE where CONTENT='super movie! great work'";