Hibernate session.CreateQuery fails with tablename is not mapped

[Bindesh Nair]

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

Session session = sessionFactory.getCurrentSession();
Transaction tx = session.beginTransaction();
 
//error line
Query query = session.createQuery("from Authors"); 
//
List<Authors> result = (List<Authors>)       query.list();

Here is what the Authors.hbm.xml looks like

<hibernate-mapping>
    <class name="com.cprs.model.Authors" table="authors" schema="dbo" catalog="pubs">
        <id name="auId" type="string">
            <column name="au_id" length="11" />
            <generator class="assigned" />
        </id>
        <property name="auLname" type="string">
            <column name="au_lname" length="40" not-null="true" />
        </property>
        <property name="auFname" type="string">
            <column name="au_fname" length="20" not-null="true" />
        </property>
       
    </class>
</hibernate-mapping>

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]

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

Mark

[Bindesh Nair]

yes, since the following method works fine

public Authors findById(java.lang.String id) {
log.debug("getting Authors instance with id: " + id);
try {
Session session = sessionFactory.getCurrentSession();
session.beginTransaction();
Authors instance = (Authors) session.get(
"com.cprs.model.Authors", id);
if (instance == null) {
log.debug("get successful, no instance found");
} else {
log.debug("get successful, instance found");
}
return instance;
 
}

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

[Jaikiran Pai]

Try

session.createQuery("from com.cprs.model.Authors");

[Bindesh Nair]

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]

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]

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]

try CreateSQLQuery