Hi guys,

I am using Weblogic portal and Hibernate 2.1

I am writing a Java control in Weblogic portal (in the web directory) that makes a call to Hiberate to retrieve an object from the database. Here is the code :

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

I get back :

net.sf.hibernate.JDBCException: Could not execute query

Is this because I am specifying the entire classpath for the PolicyDim class when I should not be ? I have hibernate.show_sql=true in the properties file, but I dont see the sql being printed anywhere...where does it get printed ?

The reason I was giving the entire classpath was :

a) Cos all the examples in the hibernate doc show x.y formats in HQL, so I assumed that giving the entire classpath was necessary.

b) Since I am making calls to Hibernate classes from a different directory than where the class files reside, I thought I should be passing in the classpath.

Can someone tell me why the HQL is not working ?
Also, how do I see the sql that hibernate generates once I put hibernate.show_sql=true in my hibernate.properties file ?

Thanks,
Suman

No, check the cause exception in your stacktrace