Can somebody please tell me how to create an association for two tables that need to be joined like substr(table1.field1,4,10) = table2.field1
How can I define that association in Hibernate..?
posted 11 years ago
Have you tried putting your substr stuff in as a formula in your mapping to materialize a column and then join on that? It'd obviously be much better if something that you're using as a foreign key was a separate column. It seems like getting the association going is just the start of the issues.