This week's book giveaway is in the JavaScript forum.
We're giving away four copies of JavaScript Promises Essentials and have Rami Sarieddine on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes Hibernate generating wrong query Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of JavaScript Promises Essentials this week in the JavaScript forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate generating wrong query" Watch "Hibernate generating wrong query" New topic
Author

Hibernate generating wrong query

Pranjal Swarup
Greenhorn

Joined: Dec 02, 2011
Posts: 2
Hi,

I am getting the following exception

org.hibernate.exception.SQLGrammarException: could not load an entity: [com.dao.Account#121]

Sql ssyntax generated is:

Hibernate:
select
account0_.employeeId as employeeId0_0_,
account0_.id as id0_0_,
account0_.firstname as firstname0_0_,
account0_.lastname as lastname0_0_,
account0_.type as type0_0_,
account0_.managerId as managerId0_0_
from
laps.user.account account0_
where
account0_.employeeId=?

problem is it appends a user between laps.account, user is another table that I excluded while generating DAOs, any idea?

thanks,
pranjal
Hebert Coelho
Ranch Hand

Joined: Jul 14, 2010
Posts: 754

Hello, Pranjal Swarup

Welcome to javaranch.

How are you doing your search in the database?


[uaiHebert.com] [Full WebApplication JSF EJB JPA JAAS with source code to download] One Table Per SubClass [Web/JSF]
Vijitha Kumara
Bartender

Joined: Mar 24, 2008
Posts: 3848

user is another table that I excluded while generating DAOs, any idea?

How you do this? And what mappings you have for this? You may need to tell more details (TellTheDetails).


SCJP 5 | SCWCD 5
[How to ask questions] [Twitter]
Pranjal Swarup
Greenhorn

Joined: Dec 02, 2011
Posts: 2
Thanks the problem has been resolved, it was mainly an error because I had set both database name and initial catalog field.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Hibernate generating wrong query