Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SQL in Stored procedures not being picked up

lisa_burrow
Level 2
Level 2

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.

2 Replies
Arun_Patidar
Community Advisor
Community Advisor

Hi,

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

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