Hi Everybody,
I am new to hibernate.
Building a login Application.
I am getting an exception like table(users) is not mapped,
I have given my mapping and DAO code below.
Can any body tell me what mistake i am doing.


Thanks,
Vijay.




Hibernate version:3.0

Mapping documents:

<hibernate-mapping>

<class
name= "intranetnetsoft.hibernate.LoginPojo" table="users" >


<id
name="id"
type="java.lang.Integer"
column="id"
>
<generator class="assigned" />
</id>

<property
name="userid"
type="java.lang.String"
column="username"
not-null="true"

/>

<property
name="password"
type="java.lang.String"
column="password"
not-null="true"

/>
<property
name="role"
type="java.lang.String"
column="role"
not-null="true"

/>
<property
name="department"
type="java.lang.String"
column="department"
not-null="true"

/>
<property
name="address"
type="java.lang.String"
column="address"
not-null="true"

/>
<property
name="contactnumber"
type="java.lang.String"
column="contactnumber"
not-null="true"

/>
<property
name="mobilenumber"
type="java.lang.String"
column="mobilenumber"
not-null="true"

/>
<property
name="email"
type="java.lang.String"
column="email"
not-null="true"

/>

</class>
</hibernate-mapping>


Code between sessionFactory.openSession() and session.close():



Session session = null;
SessionFactory sessionFactory = new Configuration().configure(
"hibernate.cfg.xml").buildSessionFactory();
session = sessionFactory.openSession();
try {

// Preparing SQL query

System.out.println("Retrieving Records");

// Transaction Initialization
Transaction tx = null;
tx = session.beginTransaction();

// Calling and executing SQL Query
List query = session.createQuery(" from users user where user.username ='" +loginpojo.getUserid()+"' and user.password ='" +loginpojo.getPassword()+"' ").list();

tx.commit();



Full stack trace of any exception that occurs:
org.hibernate.hql.ast.QuerySyntaxException: users is not mapped [ from users user where user.username ='admin' and user.password ='admin' ]
at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:158)
at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:87)
at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:70)
at org.hibernate.hql.ast.HqlSqlWalker.createFromElement(HqlSqlWalker.java:255)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:3056)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2945)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:688)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:544)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:281)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:229)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:228)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:160)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:111)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:77)
at org.hibernate.engine.query.HQLQueryPlan.<init>(HQLQueryPlan.java:56)
at org.hibernate.engine.query.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:72)
at org.hibernate.impl.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:133)
at org.hibernate.impl.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:112)
at org.hibernate.impl.SessionImpl.createQuery(SessionImpl.java:1623)
at intranetnetsoft.dao.LoginDAO.checkLogin(LoginDAO.java:43)
at intranetnetsoft.bd.LoginBD.checkLogin(LoginBD.java:14)
at intranetnetsoft.actions.AuthenticationAction.execute(AuthenticationAction.java:76)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:195)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:564)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:828)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:700)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:584)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Unknown Source)


Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:


Problems with Mapping

Read this: http://hibernate.org/42.html