I want to create mysql view for two tables which are in different schema using hibernate. I am using entity_mode as dynamic-map, so all my operations are based on Map.
I have two different hibernate session objects of the two schemas, Now I want to generate View for the two tables each from one schema. I am using MySQL, java.
Is this possible in hibernate? If yes then how can I achieve this?