Integration tests and DAO/JPA

Hi every one,
i want to know if some one have experience in creating Integration tests for the DB and could provide some help, advice or examples.
My problem i want to test if my daos are working correct.
that the data access code creates the correct database queries and database returns the correct query results.