CODEWITHSUNDEEP
javamysqlstored-procedures
Jack BeNimble
Jack BeNimble

Reputation: 36713

mysql stored procedure call works manually, but not from java

I'm calling a mysql stored procedure from Java like this:

public void deleteMyProduct(final String country, final String someId) throws EntityDoesNotExistException {
        getHibernateTemplate().execute(new HibernateCallback() {

            public Object doInHibernate(final Session session) {
                session.clear();    
                Connection con = session.connection();
                try {
                    CallableStatement cst = con.prepareCall("{call deleteProduct( ?, ? )}");
                    cst.setString(1 , country);
                    cst.setString(2 , someId);
                    cst.execute();
                    cst.close();    
                }
                catch(SQLException e){
                    logger.error("Error deleting product, someId:  "+ someId, e);
                }
                return null;
            }
        });

It's not successfully deleting the product; however when I run it manually, it does. Any idea what the problem could be?

p.s. the stored procedure is pretty large and contains identifiable info, so I'm not at liberty to post it. However, it's been in production for a while and only recently just stopped working.

Upvotes: 0

Views: 191

Answers (1)

atastrumf
atastrumf

Reputation: 181

  1. Are you sure the code is getting executed?
  2. Are variables country and someId actually correct?
  3. What does the SQLException say?
  4. Do get a successful connection - Connection con = session.connection();?
  5. Are you passing the right types of variables(should you send Int instead of String)?

Upvotes: 1

Related Questions