Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.2.2

Mapping documents:
N/A

Code between sessionFactory.openSession() and session.close():
N/A

Full stack trace of any exception that occurs:
N/A

Name and version of the database you are using:
Oracle 10.2.0.3

The generated SQL (show_sql=true):
SELECT ASDR_BO.SEQ_ORDER_ID.nextval from DUAL;

SELECT order_id FROM ADSR_SD.SDS_ORDER;

Debug level Hibernate log excerpt:


Problems with Session and transaction handling?

Read this: http://hibernate.org/42.html

Hi,

I have problem that our system is required to access tables across different schemas, thus, we have create public synonym and a new user that can access all tables. However, Hibernate parse and execute SQL with schema name and would determine wrong schema.

So, can tell Hibernate don't attach schema name to all tables, index and sequence when parse the HQL and execute.

Thanks and regards,

Franco