File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
Author

problen in native sql query execution

Rajan Nath
Greenhorn

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
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17249
    
    6

Shwo us your query and actual table structure.

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

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
 
I agree. Here's the link: http://aspose.com/file-tools
 
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