deleting entries from table

[Former Member]

HI guys,

please tell me how to delete table/model entries using sql in hybris.

I used the command "delete from Policy" It shows the message "2 rows effected" but when i run the command "select * from Policy" its actually showing the data.

[Former Member]

Hi Ankit, The application server caches the data from the DB in memory. Whenever you use the application in order to remove data (APIs, ImpEx), the application makes sure that cache entries are invalidated, so that whenever the data is requested again, the data is fetched from the DB and renewed in the cache.

Since you bypass the application server (using native sql), the application server is not aware of cache invalidations and for that reason shows you outdated data. You can either clear the cache manually (as suggested by ) or restart the server.

Obviously it is not recommended to bypass the application server unless you know what you're doing 🙂

Cheers, Tobias

[Former Member]

Try clearing the cache in HAC>Monitoring>Cache It might help.