Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.

SQL in Stored procedures not being picked up

Avatar

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

Avatar

Community Advisor

Hi,

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



Arun Patidar

Avatar

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