Simple native SQL

[S Setty]

Can you help me to find what i am doing wrong.
I can't seem to get this working.

Query simpleQuery = session.createSQLQuery("select LEGACY_ACCT_IN as legacyIndicator FROM DB2.ACCOUNT_DETAILS WHERE ACCESS_MEDIUM_NO = :acctNum").addEntity(SimpleVO.class);

simpleQuery.setString("acctNum", "4889");

List lst = simpleQuery.list();

Exception data: org.hibernate.MappingException: Unknown entity: common.stmt.business.domain.SimpleVO

Thanks
Santosh

[Jimmy Clark]

Have you declared the SimpleVO class in the Hibernate configuration file?

[S Setty]

Thanks for replying.

No i do not have anything in the hibernate config file. I was thinking addEntity method will register.

Do you have an example or syntax handy?

Appreciate your help.

Thanks
Santosh

[Jimmy Clark]

This is very important. Below is an example.

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration 
     PUBLIC
     "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
     "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
...        
<property name="hibernate.connection.driver_class">
net.sourceforge.jtds.jdbc.Driver
</property>
...
<property name="jta.UserTransaction ">
java:comp/UserTransaction
</property>
...
<mapping resource="common/stmt/business/domain/SimpleVO.hbm.xml"/>
...        
</session-factory>
</hibernate-configuration>