javamysqlhibernategenericdao

What's the best way to calling a Stored Procedure using Hibernate in a Generic DAO?

I'm using MySql and my query to call is like:

call SPGetChart (idNumber, nameChart);
Solution

  • Using EntityManager

       Query query=getEntityManager().
                           createNativeQuery("BEGIN SPGetChart(:id, :name); END;");
   query.setParameter("id", idValue);
   query.setParameter("name", nameChart);

   query.executeUpdate();

    Using connection through EntityManager:

       Connection con = ((SessionImpl) getEntityManager().getDelegate()).connection();
   CallableStatement callableStatement = cc.prepareCall("{call SPGetChart (?,?)}");

   callableStatement.setInt(1, idValue);
   callableStatement.setString(2, nameChart);
   callableStatement.execute();

    Using Session:

    Query query = session.createSQLQuery("CALL SPGetChart (:id, :name)")
               .setParameter("id", idValue)
                   .setParameter("name", nameChart);
query.executeUpdate();