Java - Hibernate calling a MySql Stored Procedure - Warning Message

Question

I have a Java project where I call a stored procedure using hibernate.

Here is sample code I am using

  public String findCloudName(Long cloudId) {
        LOG.info("Entered findCloudName Method - cloudId:{}", cloudId);

        String cloudName  = null;
        ProcedureCall  procedureCall = currentSession().createStoredProcedureCall("p_getCloudDetails");
        procedureCall.registerParameter( "cloudId", Long.class, ParameterMode.IN ).bindValue( cloudId );
        procedureCall.registerParameter( "cloudName", String.class, ParameterMode.OUT );

        ProcedureOutputs  outputs = procedureCall.getOutputs();

        cloudName = (String) outputs.getOutputParameterValue( "cloudName" );

        LOG.info("Exiting findCloudName Method - cloudName:{}", cloudName);
        return cloudName; 
    }

This works fine and results the expected results. However It leaves the following message in my logs

[WARN] [320]org.hibernate.procedure.internal.ProcedureCallImpl[prepareForNamedParameters]  - HHH000456: Named parameters are used for a callable statement, but database metadata indicates named parameters are not supported.

I was looking through websites and the source code of hibernate to try and figure out how to get rid of this warning

Any help is greatly appreciated

Cheers Damien

Master Mind · Accepted Answer · 2015-05-13 01:57:57Z

1

It's related to the correction of HHH-8740 :

In some cases, the database metadata is incorrect (i.e., says something is not supported, when it actually is supported). In this case it would be preferable to simply log a warning. If it turns out that named parameters really are not supported, then a SQLException will be thrown later when the named parameter is bound to the SQL statement.

So, the warning warn you from calling a method that queries metadata on named parameters.

answered May 13, 2015 at 1:57

Master Mind

3,0844 gold badges35 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

fouziya shaikh · Accepted Answer · 2023-07-06 16:42:12Z

0

    Session session=HibernateUtil.getSessionFactory().openSession();
    Transaction tx=session.beginTransaction();
    
    System.out.println("Enter Id:");
    int id=sc.nextInt();
    
    StoredProcedureQuery query=session.createStoredProcedureCall("Delete",Employee.class);
    query.registerStoredProcedureParameter("id", Integer.class, ParameterMode.IN);
    
    query.setParameter("id",sc.nextInt());
    query.executeUpdate();
    tx.commit();

answered Jul 6, 2023 at 16:42

fouziya shaikh

1

4 Comments

fouziya shaikh Over a year ago

org.hibernate.procedure.internal.ProcedureCallImpl prepareForNamedParameters WARN: HHH000456: Named parameters are used for a callable statement, but database metadata indicates named parameters are not supported. this error shows me

fouziya shaikh Over a year ago

DROP PROCEDURE IF EXISTS namednative_crud.Delete $$ CREATE PROCEDURE namednative_crud.Delete (IN eid int) BEGIN delete from Employee where id=eid; End

fouziya shaikh Over a year ago

this is the query i written and then shows above error

Community Over a year ago

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

Java - Hibernate calling a MySql Stored Procedure - Warning Message

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related