This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
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 Introducing JavaFX 8 Programming this week in the JavaFX 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: 17275
    
    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 - iOS Apps
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
 
It's not a secret anymore!