ZK « Query « JPA Q&A

1. hibernate query zkoss.org

public Event findFirstByDate(Date theDate) { Event result = null ; Query query =_session.createQuery("from Event where time > ? order by time asc limit 1" ) ; query.setDate( 1, theDate ) ; List results = query.list() ; if ( results != null && results.size() > 0 ) result = results.get(0) ; return result ; }

2. how to get values from database to listbox with jpa query zkoss.org

3. Hibernate example failing, can't find each.date??? zkoss.org

4. ZK paging & Hibernate zkoss.org

Orignial message at: https://sourceforge.net/forum/message.php?msg_id=4020334 By: andigre How do did you try? I do it that way with 475 rows at the moment and it seems fast. The ZUL page contains the grid with header only, the rows will be added dynamically.

5. Specific Hibernate Query zkoss.org

Orignial message at: https://sourceforge.net/forum/message.php?msg_id=4977461 By: brendan4linux Hi, For some reason on a specific hibernate facade method (wrapped in an event listener), I get the following error when trying to save an object: 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 :100) at org.zkoss.zkplus.hibernate.OpenSessionInViewListener.cleanup(OpenSess ionInViewListener.java:65) at org.zkoss.zk.ui.util.Configuration.invokeExecutionCleanups(Configurat ion.java:899) at org.zkoss.zk.ui.impl.UiEngineImpl.execUpdate(UiEngineImpl.java:815) at org.zkoss.zk.au.http.DHtmlUpdateServlet.process(DHtmlUpdateServlet.ja va:407) at org.zkoss.zk.au.http.DHtmlUpdateServlet.doGet(DHtmlUpdateServlet.java :293) at ...

6. org.hibernate.exception.JDBCConnectionException: could not execute query zkoss.org

*** SOLVED *** What can cause this error ? org.hibernate.exception.JDBCConnectionException: could not execute query org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:97) org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) org.hibernate.loader.Loader.doList(Loader.java:2231) org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2125) org.hibernate.loader.Loader.list(Loader.java:2120) org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:361) org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) org.hibernate.impl.SessionImpl.list(SessionImpl.java:1148) org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) groupes.GroupeDAO.findAllJustSigle(GroupeDAO.java:37) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) java.lang.reflect.Method.invoke(Unknown Source) bsh.Reflect.invokeMethod(Unknown Source) bsh.Reflect.invokeObjectMethod(Unknown Source) bsh.Name.invokeMethod(Unknown Source) bsh.BSHMethodInvocation.eval(Unknown Source) bsh.BSHPrimaryExpression.eval(Unknown Source) bsh.BSHPrimaryExpression.eval(Unknown Source) bsh.BSHAssignment.eval(Unknown Source) bsh.BSHBlock.evalBlock(Unknown Source) bsh.BSHBlock.eval(Unknown Source) bsh.BshMethod.invokeImpl(Unknown Source) bsh.BshMethod.invoke(Unknown Source) bsh.BshMethod.invoke(Unknown Source) bsh.Name.invokeLocalMethod(Unknown Source) bsh.Name.invokeMethod(Unknown Source) ...