SQL in Stored procedures not being picked up | Community
Skip to main content
lisa_burrow
Level 2
June 8, 2021

SQL in Stored procedures not being picked up

  • June 8, 2021
  • 1 reply
  • 961 views

Hi,

 

I have some SQL in a stored procedure that is selecting data from a database and then making that data available in a drop down list on my website.

 

I have made a change to this SQL but am unable to get my website to pick up my changes.

 

Is there something that I need to do to refresh/update to make the environment pick up the new changes?

 

I have run a Maven compile and deployed that to my environment but that didn't pick up my changes.

 

Thanks. Lisa.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

arunpatidar
Community Advisor
Community Advisor
June 8, 2021

Hi,

where are you checking this Author or Publish. Make sure the service response is not cached on dispatcher.

Arun Patidar
lisa_burrow
Level 2
June 9, 2021
Hi Arun, I am checking this in Publish. I have already cleared the dispatcher cache.