wood burning stoves 2.0*
The moose likes Object Relational Mapping and the fly likes Hibernate session.CreateQuery fails with tablename is not mapped Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate session.CreateQuery fails with tablename is not mapped" Watch "Hibernate session.CreateQuery fails with tablename is not mapped" New topic
Author

Hibernate session.CreateQuery fails with tablename is not mapped

Bindesh Nair
Greenhorn

Joined: Oct 09, 2007
Posts: 12
Hello Everyone

I am facing an issue with Hibernate mapping.

I have the following code that tries to get all the Authors from the sql server table using the MS JDBC Driver.

The code snippet looks like this




Here is what the Authors.hbm.xml looks like



I get the following error in Eclipse "Authors is not mapped [from Authors]"
I am using Eclipse 3.3.0 along with Hibernate Tool 3.2.0 cr1.

Am i missing something ?

Thanks for looking into this
[ December 02, 2007: Message edited by: Bindesh Vijayan ]
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17259
    
    6

Is you hibernate.cfg.xml in the base of your classpath?

Mark


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Bindesh Nair
Greenhorn

Joined: Oct 09, 2007
Posts: 12
yes, since the following method works fine


It only fails when i try session.createQuery("from Authors");
Jaikiran Pai
Marshal

Joined: Jul 20, 2005
Posts: 10266
    
168

Try



[My Blog] [JavaRanch Journal]
Bindesh Nair
Greenhorn

Joined: Oct 09, 2007
Posts: 12
Thanks, but I already tried that and it failed too.

I think I will agree with Mark, it has something to do with improper classpath. Perhaps it could be that I am depending on Eclipse inbuilt compilation option and so unable to give correct classpath for the Hibernate Tool. And hence, it might be complaining about it.

I will write my own build script and set the classpath and see how it goes.

Thanks once again.
[ December 03, 2007: Message edited by: Bindesh Vijayan ]
Mark Spritzler
ranger
Sheriff

Joined: Feb 05, 2001
Posts: 17259
    
    6

I was just about to post what Jaikiran posted. using the fully qualified class name. Since you did that in the code that you said works.

But I am still in agreement with myself that this seems to be more an eclipse configuration thing that Hibernate. And I don't know Eclipse to really help out more.

Mark
m plutowski
Greenhorn

Joined: Jan 18, 2008
Posts: 1
This may not be your problem but JPA/Hibernate threw a similar run-time error for me, and I was able to correct it. When I moved a shared package (the database layer) to its own project, it compiled correctly but JPA/Hibernate threw this same type of error at run-time. When I moved the package source back to where it was previously (within the main project) it worked again. I think that the persistence.xml local to the main project didn't know about the classes that were in the other project (the one to which I moved the package that contained the source mapping the class to the database for the class referenced in the exception). I'm experimenting with putting all code that accesses Hibernate into the database package, so that the main project need not reference Hibernate at all, and then making another attempt at moving the package to its own project. If this isn't helpful to you, perhaps it at least gets my own experience out there into the ether in case it might help someone.
sol solu
Greenhorn

Joined: Jan 15, 2012
Posts: 1
try CreateSQLQuery
Fran Castanno
Greenhorn

Joined: Feb 12, 2013
Posts: 1
My web app had the same behavior and I solved by adding antlr library.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Hibernate session.CreateQuery fails with tablename is not mapped