Revision history [back]

Hi kal, Thanks for your help. ^_^ I know it is hibernate concerned, I am sorry for taking your time looking at the codes not related to zk. But there is something related to zk. I have to say that the result is correct. The data in the database has been successfully presented on the page, but the error appears at the console window. I have added the configuration in the zk.xml, but I don't know if there is no need to use the transaction of hibernate in zk framework ? I don't know why the transaction has not been successfully started. I will mention it again that the data in the database has been successfully presented on the web page.

<listener>
    <description>Hibernate Open Session In View life-cycle</description>
    <listener-class>org.zkoss.zkplus.hibernate.OpenSessionInViewListener</listener-class>
</listener>

****the hibernate codes to get the data from the database is the following (just the same as the above)****

import java.util.Date; import java.util.List;

import org.hibernate.HibernateException; import org.hibernate.Session; import org.hibernate.Transaction; import org.zkoss.zkplus.hibernate.HibernateUtil;

public class SensorDAOImpl implements SensorDAO {

Session session; public SensorDAOImpl(){ _session = HibernateUtil.getSessionFactory().getCurrentSession(); } @SuppressWarnings("unchecked") @Override public List<sensor> find() { Transaction tr = null; _session = HibernateUtil.getSessionFactory().getCurrentSession(); List<sensor> result = null; try { tr = _session.beginTransaction(); result = this.session.createQuery("from Sensor").list(); tr.commit(); } catch (HibernateException e) { e.printStackTrace(); tr.rollback(); } return result; } public Session get_session() { return _session; }

public void set_session(Session session) { _session = session; } }

The following is the error:

************error information************

INFO: Server startup in 11368 ms Hibernate: select sensor0.id as id0, sensor0.sensorId as sensorId0, sensor0.time as time0, sensor0.position as position0 from sensors sensor0_ 02-Apr-2010 12:45:44 org.zkoss.zk.ui.util.Configuration invokeExecutionCleanups:845 SEVERE: Failed to invoke class org.zkoss.zkplus.hibernate.OpenSessionInViewListener org.hibernate.TransactionException: Transaction not successfully started at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:131) at org.zkoss.zkplus.hibernate.OpenSessionInViewListener.cleanup(OpenSessionInViewListener.java:65) at org.zkoss.zk.ui.util.Configuration.invokeExecutionCleanups(Configuration.java:842) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:449) at org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:299) at org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:229) at org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:165) at javax.servlet.http.HttpServlet.service(HttpServlet.java:617) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:849) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:454) at java.lang.Thread.run(Unknown Source)