When I run my HQL query and look in debug mode, The SQLException that I get says "Table or view does not exist"

Here is my code :

result = sess.find("from com.accidentfund.common.db.hibernate.PolicyDim as policy where policy.policyNumber = ?",
vo.getPolicyNum(),
Hibernate.STRING);

The mapping for PolcyDim.hbm.xml is :

<class
name="com.accidentfund.common.db.hibernate.PolicyDim"
table="POLICY_DIM"
>

<id
name="policyDimKey"
type="long"
column="POLICY_DIM_KEY"
>
<generator class="assigned" />
</id>

<property
name="policyNumber"
type="java.lang.String"
column="POLICY_NUMBER"
not-null="true"
length="8"
/>

......
......

The database that I am connecting to has multiple schemas ? Is this the reason why hibernate cannot find the table ? Is there a way to specify the schema name (do I even need to) ?

Also, pls let me know how I can see the SQL statements that Hibernate generates (I have set show_sql=true in the props file). Should it be printing to the console ? If so, I dont see any SQL in the console...

Thanks,
S

How do you think that anyone except you will be able to answer that, especially as you don't even mention which database you're using?



Both on the hibernate-mapping and class level, yes. see

http://www.hibernate.org/hib_docs/reference/html/or-mapping.html#or-mapping-s1-2



Yes, it should be printing to the console. Depending on your app server, if any, console output may be redirected to some log file.

suman wrote:

The database that I am connecting to has multiple schemas ?


How do you think that anyone except you will be able to answer that, especially as you don't even mention which database you're using?

--- That was a typo...it wasnt meant to be posed as a question but a statement. The database does have multiple schemas.

The database is Oracle by the way.