@Deployment
public static WebArchive createDeployment() {
    WebArchive war = ShrinkWrap.create(WebArchive.class)
                               .addPackage("org.javaee7.jpa.storedprocedure")
                               .addAsResource("META-INF/persistence.xml")
                               .addAsResource("META-INF/create.sql")
                               .addAsResource("META-INF/drop.sql")
                               .addAsResource("META-INF/load.sql");
    System.out.println(war.toString(true));
    return war;
}

@Test
public void testStoredProcedure() throws Exception {
    List<Movie> movies = movieBean.listMovies();
    assertFalse(movies.isEmpty());

    //movieBean.executeStoredProcedure();
}