Hi,

I'm new with Hibernate and I wonder if there are any plugin-interfaces,
so that I can manipulate SELECT/UPDATE/INSERT-statement-generation ?

I need to do this because I want to use a SQL-function-call for certain fields (in the statement).

So for example instead of a generated:

SELECT name FROM secretusers ORDER BY name

... I want to have this:

SELECT decrypt(name) FROM secretusers ORDER BY decrypt(name)

The decrypt() function is a stored-procedure which does what its name implies. Never mind the performance-degradation or using other encryption-strategies... that's just the way it is with a legacy database I need to use with hibernate.

Is this possible ?
Or can I just rename these certain fields in the Hibernate-mapping so that the table-column name is "decrypt(name)" instead of "name" ?
Does this mapping-name yield unexpected behaviour with Hibernate's internal (caching-, collection-, etc.)mechanisms ?

J

http://forum.hibernate.org/viewtopic.php?t=925295

I think this forum-post is dealing with the same issue.

Use the formula attribute of <property> to do this.

It /is/ possible to customize SQL generation, but only by using a custom persister, which is a bit of a PIA.