hybris direct sql query with commit ON is not having affect

Question

I'm trying to run direct SQL queries on Hybris Admin Console (HAC) with commit ON but it is not having an effect on the record.

UPDATE users SET p_email = 'test@sql.com' WHERE p_uid = 'testuser@test.com'

Is there anything I'm missing?

Answer 1

1) Verify the updated value using select query

SELECT p_email FROM users WHERE p_uid='testuser@test.com'

2) Clear the cache to get it reflected in the Model as well

Go to hac > monitoring > cache and click on Clear cache