We have an Oracle instance called ELER. There are two database schemas called TEMS and PEMS (one for testing and one for production). If we´re using TEMS and PEMS as users name in the -ds.xml configuration file the correct database schema is selected. However, TEMS and PEMS are the admistrative users and we want to use some other more restrictive users for normal access. But if we do this, hibernate complains about not finding the tables. I did search for possibilities to define the database schema name in the persistance.xml file, but didn´t find any references. Maybe some can help.
|