Problem mapping pojo with view using hibernate

[Varun Nayudu]

hi guys,

I am getting the following hibernate mapping exception

building session factory
Initial SessionFactory creation failed.org.hibernate.MappingException: entity class not found: his1.User.TableData
StandardWrapperValve[Persistent Faces Servlet]: PWC1406: Servlet.service() for servlet Persistent Faces Servlet threw exception
java.lang.NoClassDefFoundError: Could not initialize class his1.NewHibernateUtil
at his1.Home.Page1.prerender(Page1.java:153)
at com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.prerender(ViewHandlerImpl.java:735)
at com.sun.rave.web.ui.appbase.faces.ViewHandlerImpl.renderView(ViewHandlerImpl.java:260)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106)
at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:251)
at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144)
at com.icesoft.faces.webapp.http.core.JsfLifecycleExecutor.apply(JsfLifecycleExecutor.java:18)
at com.icesoft.faces.context.View$2$1.respond(View.java:41)
at com.icesoft.faces.webapp.http.servlet.GlassFishAdaptingServlet$GlassFishRequestResponse.respondWith(GlassFishAdaptingServlet.java:159)
at com.icesoft.faces.context.View$2.serve(View.java:48)
at com.icesoft.faces.context.View.servePage(View.java:130)
at com.icesoft.faces.webapp.http.core.SingleViewServer.service(SingleViewServer.java:51)
at com.icesoft.faces.webapp.http.common.standard.PathDispatcherServer.service(PathDispatcherServer.java:24)
at com.icesoft.faces.webapp.http.servlet.MainSessionBoundServlet.service(MainSessionBoundServlet.java:160)
at com.icesoft.faces.webapp.http.servlet.SessionDispatcher$1.service(SessionDispatcher.java:38)
at com.icesoft.faces.webapp.http.servlet.GlassFishAdaptingServlet.service(GlassFishAdaptingServlet.java:60)
at com.icesoft.faces.webapp.http.servlet.EnvironmentAdaptingServlet.service(EnvironmentAdaptingServlet.java:63)
at com.icesoft.faces.webapp.http.servlet.SessionDispatcher.service(SessionDispatcher.java:55)
at com.icesoft.faces.webapp.http.servlet.PathDispatcher.service(PathDispatcher.java:23)
at com.icesoft.faces.webapp.http.servlet.MainServlet.service(MainServlet.java:91)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
at org.apache.catalina.core.ApplicationFilterChain.servletService(ApplicationFilterChain.java:411)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:290)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:271)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:202)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:94)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:206)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:150)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:632)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:577)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:571)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:1080)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:272)
at com.sun.enterprise.web.connector.grizzly.DefaultProcessorTask.invokeAdapter(DefaultProcessorTask.java:637)
at com.sun.enterprise.web.connector.grizzly.comet.CometEngine.executeServlet(CometEngine.java:547)
at com.sun.enterprise.web.connector.grizzly.comet.CometEngine.handle(CometEngine.java:299)
at com.sun.enterprise.web.connector.grizzly.comet.CometAsyncFilter.doFilter(CometAsyncFilter.java:87)
at com.sun.enterprise.web.connector.grizzly.async.DefaultAsyncExecutor.invokeFilters(DefaultAsyncExecutor.java:175)
at com.sun.enterprise.web.connector.grizzly.async.DefaultAsyncExecutor.interrupt(DefaultAsyncExecutor.java:153)
at com.sun.enterprise.web.connector.grizzly.async.AsyncProcessorTask.doTask(AsyncProcessorTask.java:92)
at com.sun.enterprise.web.connector.grizzly.TaskBase.run(TaskBase.java:265)
at com.sun.enterprise.web.connector.grizzly.ssl.SSLWorkerThread.run(SSLWorkerThread.java:106)

I am using netbeans ide and am trying to map a pojo with a view which i created in MySql. The pojo is a below

public class TableData implements Serializable {
private String userid;
private String passworda;
private Integer primaryGpId;
//private Integer roleid;
// private Integer groupid;
private String groupname;
public String getUserid() {
return userid;
}
public void setUserid(String userid) {
this.userid = userid;
}
public String getPassworda() {
return passworda;
}
public void setPassworda(String passworda) {
this.passworda = passworda;
}
public String getGroupname() {
return groupname;
}
public void setGroupname(String groupname) {
this.groupname = groupname;
}
public Integer getPrimaryGpId() {
return primaryGpId;
}
public void setPrimaryGpId(Integer primaryGpId) {
this.primaryGpId = primaryGpId;
}
public List<TableData> tabledata1() { System.out.println("----List<tabledata> tabledata1()----");
Transaction tx = null;
Session session=null;
String sql="from his1.User.TableData";
List<TableData> list = null;
try{
session = NewHibernateUtil.getSessionFactory().getCurrentSession();
tx = session.beginTransaction();
Query q = session.createQuery(sql);
list = (List<TableData>)q.list();
Iterator<TableData> it = list.iterator();
TableData t = null;
while(it.hasNext()){
t = it.next();
System.out.println(t.getGroupname());
}
}catch(Exception e){
if (tx!=null) tx.rollback();
e.printStackTrace();
}finally{
NewHibernateUtil.getSessionFactory().close();
}
return list;
}
}

And its hibernate mapping file is as follows:

<hibernate-mapping>
<class catalog="his1" name="his1.User.TableData" table="Usertabledata">
<id name="userid" type="string">
<column name="USERID"/>
<generator class="assigned"/>
</id>
<property name="passworda" type="string">
<column name="PASSWORDA" />
</property>
<property name="primaryGpId" type="java.lang.Integer">
<column name="PRIMARY_GP_ID"/>
</property>
<property name="groupname" type="string">
<column name="GROUPNAME" />
</property>
</class>
</hibernate-mapping>

And the hibernate configuration file is as follows

<hibernate-configuration>
<session-factory>
<property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
<property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="hibernate.connection.url">jdbc:mysql://localhost:3306/his1</property>
<property name="hibernate.connection.username">his1</property>
<property name="hibernate.connection.password">his1</property>
<property name="hibernate.show_sql">true</property>
<property name="hibernate.current_session_context_class">thread</property>
<mapping resource="his1/Registration/PatientSearch.hbm.xml"/>
<mapping class="his1.loginModule.LnUserDisplayLinks" file="" jar="" package="his1.loginModule" resource="his1/loginModule/LnUserDisplayLinks.hbm.xml"/>
<mapping class="his1.loginModule.LnUserHomePage" file="" jar="" package="his1.loginModule" resource="his1/loginModule/LnUserHomePage.hbm.xml"/>
<mapping resource="his1/User/LnMGroups.hbm.xml"/>
<mapping resource="his1/User/LnMUsers.hbm.xml"/>
<mapping resource="his1/User/LnUserGroupHistory.hbm.xml"/>
<mapping resource="his1/User/LnUserGroup.hbm.xml"/>
<mapping resource="his1/User/LnMUsersHistory.hbm.xml"/>
<mapping resource="his1/User/TableData.hbm.xml"/>
</session-factory>
</hibernate-configuration>

The View which i am trying to map is named 'Usertabledata'

When i user the netbeans hql Query analyser with session: hibernate.cfg , i am able to see the result properly but when i run the app i get the above exception

[Paul Sturrock]

 

java.lang.NoClassDefFoundError: Could not initialize class his1.NewHibernateUtil

his1.NewHibernateUtil is not on your classpath