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

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

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.

Avatar

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