@Test
	public void update() throws SQLException {
		this.entityManager.getTransaction().begin();
		Foobar foobar = new Foobar();
		Calendar hlp = Calendar.getInstance();
		// So this is now 2013-10-15 at Midnight CEST…
		hlp.set(2013, 10-1, 15, 0, 0, 0);
		foobar.setRefDate(hlp);
		foobar.setTakenOn(Calendar.getInstance());
		this.entityManager.persist(foobar);		
		this.entityManager.getTransaction().commit();
		final int id = foobar.getId();

		final DateFormat sf = new SimpleDateFormat("yyyy-MM-dd");
		
		Session session = entityManager.unwrap(Session.class);
		session.doWork(new Work() {			
			@Override
			public void execute(Connection connection) throws SQLException {
				ResultSet rs = connection.createStatement().executeQuery("Select ref_date from foobars where id = " + id);
				rs.next();
				Date date = rs.getDate(1);
				Assert.assertEquals("2013-10-15", sf.format(date));
				System.out.println(date);				
			}
		});		
	}