I'm creating a Hibernate mapping for a view named foo_view in a PostgreSQL DB. The configuration is like this:

The DB is on a remote server and can only be accessed using a SSH tunnel. Normally, I will first create a SSH tunnel from my localhost to the DB host. Then I'll just psql my localhost.

One problem is: I'll have to do:



everytime in my psql shell to be able to access foo_view. I don't know where to set this runtime parameter in Hibernate. Can anyone shed some light on this?

Thanks.

Ok, I did my own research and the solution is actually quite simple. Solution: refer to the view/table by its full name (including schema name). Say if you have a view/table named "bar", first find out which schema it resides in by which actually tells you the full name of the table, like . This means table bar is in schema foo. In hibernate mapping file, refer to the table as foo.bar instead of just bar.