1

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

call SPGetChart (idNumber, nameChart);
Helio Bentzen
  • 485
  • 2
  • 9
  • 23

2 Answers2

2

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();
Yogendra Singh
  • 32,067
  • 6
  • 59
  • 71
  • I'm using an another approach, look this: http://jsfiddle.net/2TZA2/ I dont have a session or a getSession. In the DataSource I cannot found a "createSQLQuery" How should to be changed this file? – Helio Bentzen Nov 05 '12 at 20:09
  • @HelioBentzen: I see that you have `getEntityManager`. I updated the answer to use the same. – Yogendra Singh Nov 05 '12 at 20:16
  • I need make some tests to say it, but dont was error. Thanks. I'll say here when I finish. – Helio Bentzen Nov 06 '12 at 01:37
2

I know this is a old question but for those that find this now, the EntityManager class now has support for stored procedures now. 

StoredProcedureQuery query = getEntityManager().createStoredProcedureQuery("SPGetChart");

query.registerStoredProcedureParameter(1, Integer.class, ParameterMode.IN);
query.registerStoredProcedureParameter(2, String.class, ParameterMode.IN);

query.setParameter(1, idValue);
query.setParameter(2, nameChart);
query.execute();
The Code Pimp
  • 2,116
  • 1
  • 17
  • 16