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

Hibernate version:3

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:Oracle 8i

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Is it possible to use an unmapped table in my query for example:

String q = "select tran from PolicyTransaction tran " +
"where tran.key.contractNumber " +
"not in (SELECT CHDRNUM FROM PTRNPF_SYNC)";
Query query = session.createSQLQuery(q);

table PTRNPF_SYNC is not mapped and I don't want to include it as part of our data model, but I want this select to take into account what contracts it contains - what is the best way to achieve this behaviour?

Hello,

Yes, you can use any table if you use createSQLQuery(..)
The table must not be matched in this case.

For HQL however (createQuery(..)), it would not be possible.

Urs