Hi I use jbpm3.2.1 mysql 5.0.1 I configurated mysql jbpm successfuly.I can deploy process but when I try to start process on jbos server I have this error anonymous wrote : | 2008-08-11 10:51:52,353 ERROR [org.hibernate.util.JDBCExceptionReporter] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?ns0_.ID_ as ID1_20_, process?ns0_.VERSION_ as VERSION2_20_, process?ns0_.KEY_ a' at line 1 | 2008-08-11 10:51:52,368 ERROR [STDERR] org.hibernate.exception.SQLGrammarException: could not execute query | at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67) | at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) | at org.hibernate.loader.Loader.doList(Loader.java:2148) | at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) | at org.hibernate.loader.Loader.list(Loader.java:2024) | at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:392) | at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:333) | at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172) | at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1114) | at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) | at org.jbpm.db.GraphSession.findProcessInstances(GraphSession.java:360) | at org.jbpm.jsf.core.action.ListProcessInstancesActionListener.handleAction(ListProcessInstancesActionListener.java:48) | at org.jbpm.jsf.core.impl.JbpmActionListenerWrapper.processAction(JbpmActionListenerWrapper.java:82) | at javax.faces.event.ActionEvent.processListener(ActionEvent.java:77) | at javax.faces.component.UIComponentBase.broadcast(UIComponentBase.java:758) | at javax.faces.component.UICommand.broadcast(UICommand.java:368) | at org.jboss.gravel.action.handler.ResponseActionsHandler.onComponentPopulated(ResponseActionsHandler.java:24) | at com.sun.facelets.tag.jsf.ComponentHandler.apply(ComponentHandler.java:180) | at com.sun.facelets.tag.CompositeFaceletHandler.apply(CompositeFaceletHandler.java:47) | at com.sun.facelets.tag.ui.DefineHandler.apply(DefineHandler.java:58) | at com.sun.facelets.tag.ui.CompositionHandler.apply(CompositionHandler.java:128) | at com.sun.facelets.impl.DefaultFaceletContext$TemplateManager.apply(DefaultFaceletContext.java:306) | at com.sun.facelets.impl.DefaultFaceletContext.includeDefinition(DefaultFaceletContext.java:279) | at com.sun.facelets.tag.ui.InsertHandler.apply(InsertHandler.java:68) | at com.sun.facelets.tag.CompositeFaceletHandler.apply(CompositeFaceletHandler.java:47) | at com.sun.facelets.compiler.NamespaceHandler.apply(NamespaceHandler.java:49) | at com.sun.facelets.tag.CompositeFaceletHandler.apply(CompositeFaceletHandler.java:47) | at com.sun.facelets.compiler.EncodingHandler.apply(EncodingHandler.java:25) | at com.sun.facelets.impl.DefaultFacelet.include(DefaultFacelet.java:248) | at com.sun.facelets.impl.DefaultFacelet.include(DefaultFacelet.java:294) | at com.sun.facelets.impl.DefaultFacelet.include(DefaultFacelet.java:273) | at com.sun.facelets.impl.DefaultFaceletContext.includeFacelet(DefaultFaceletContext.java:143) | at com.sun.facelets.tag.ui.CompositionHandler.apply(CompositionHandler.java:113) | at com.sun.facelets.compiler.NamespaceHandler.apply(NamespaceHandler.java:49) | at com.sun.facelets.compiler.EncodingHandler.apply(EncodingHandler.java:25) | at com.sun.facelets.impl.DefaultFacelet.include(DefaultFacelet.java:248) | at com.sun.facelets.impl.DefaultFacelet.include(DefaultFacelet.java:294) | at com.sun.facelets.impl.DefaultFacelet.include(DefaultFacelet.java:273) | at com.sun.facelets.impl.DefaultFaceletContext.includeFacelet(DefaultFaceletContext.java:143) | at com.sun.facelets.tag.ui.CompositionHandler.apply(CompositionHandler.java:113) | at com.sun.facelets.compiler.NamespaceHandler.apply(NamespaceHandler.java:49) | at com.sun.facelets.compiler.EncodingHandler.apply(EncodingHandler.java:25) | at com.sun.facelets.impl.DefaultFacelet.apply(DefaultFacelet.java:95) | at com.sun.facelets.FaceletViewHandler.buildView(FaceletViewHandler.java:503) | at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:546) | at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:178) | at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:106) | at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:248) | at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:144) | at javax.faces.webapp.FacesServlet.service(FacesServlet.java:245) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) | at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) | at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) | at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) | at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) | at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) | at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:175) | at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524) | at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:74) | at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) | at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) | at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) | at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) | at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) | at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) | at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) | at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112) | at java.lang.Thread.run(Thread.java:810) | Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?ns0_.ID_ as ID1_20_, process?ns0_.VERSION_ as VERSION2_20_, process?ns0_.KEY_ a' at line 1 | at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936) | at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870) | at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573) | at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665) | at com.mysql.jdbc.Connection.execSQL(Connection.java:3176) | at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1153) | at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1266) | at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236) | at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186) | at org.hibernate.loader.Loader.getResultSet(Loader.java:1669) | at org.hibernate.loader.Loader.doQuery(Loader.java:662) | at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224) | at org.hibernate.loader.Loader.doList(Loader.java:2145) | ... 66 more | 2008-08-11 10:51:52,368 ERROR [org.jbpm.db.GraphSession] org.hibernate.exception.SQLGrammarException: could not execute query can anybody explan what is problem?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4169792#4169792 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4169792 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
