aspose file tools
The moose likes Object Relational Mapping and the fly likes Hibernate generating wrong query Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Reply 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: 3670

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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Hibernate generating wrong query
 
Similar Threads
Hibernate POJO class grtter method
Data is not properly export in the XML file
Hibernate Many to ManyMapping
need help in updating data using hibernate hql
Hibernate 3: java.sql.SQLException: Field 'passwordConfirmation' doesn't have a default value