File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes problen in native sql query execution Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "problen in native sql query execution" Watch "problen in native sql query execution" New topic

problen in native sql query execution

Rajan Nath

Joined: Nov 27, 2007
Posts: 22
I am trying to execute one simple sql query consists of two sub query, in database the query executes well but in hbm it is giving error.
like org.hibernate.exception.SQLGrammarException: could not execute query
Caused by: java.sql.SQLException: [IBM][SQLServer JDBC Driver]Invalid column name: clazz_
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17249

Shwo us your query and actual table structure.

It is looking for a field called clazz_ in your table. Is there such a column?


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
I agree. Here's the link:
subject: problen in native sql query execution
Similar Threads
Getting java.sql.SQLException. Why?
Hibernate not deleting rows
Can we execute sql query with outer join in hibernate
Difference between execute, executeQuery, executeUpdate
Prepared Vs Callable statements