2 Replies Latest reply on Aug 19, 2010 12:05 PM by jschappet

    ERROR: operator does not exist: bigint = character varying

    jschappet

      Hey guys, I am working on jbpm 4.4 and Spring 3 Integration.  I currently have Spring & jbpm starting without errors.

       

       

      But when I try to kick off a simple process, I get the following error:

       

      Does anyone have any ideas?

       

       

       

       

      Aug 19, 2010 9:04:04 AM org.apache.catalina.core.StandardWrapperValve invoke
      SEVERE: Servlet.service() for servlet dispatcher threw exception
      org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying
          at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
          at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
          at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:430)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:346)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:250)
          at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
          at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
          at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
          at org.hibernate.loader.Loader.getResultSet(Loader.java:1778)
          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:2211)
          at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2095)
          at org.hibernate.loader.Loader.list(Loader.java:2090)
          at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:388)
          at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
          at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
          at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
          at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
          at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:804)
          at org.jbpm.pvm.internal.hibernate.DbSessionImpl.findProcessInstanceByIdIgnoreSuspended(DbSessionImpl.java:148)
          at org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessInstance(DbSessionImpl.java:185)
          at org.jbpm.pvm.internal.model.ExecutionImpl.end(ExecutionImpl.java:396)
          at org.jbpm.jpdl.internal.activity.EndActivity.execute(EndActivity.java:81)
          at org.jbpm.jpdl.internal.activity.EndActivity.execute(EndActivity.java:43)
          at org.jbpm.pvm.internal.model.op.ExecuteActivity.perform(ExecuteActivity.java:60)
          at org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperationSync(ExecutionImpl.java:672)
          at org.jbpm.pvm.internal.model.ExecutionImpl.performAtomicOperation(ExecutionImpl.java:632)
          at org.jbpm.pvm.internal.model.ExecutionImpl.start(ExecutionImpl.java:217)
          at org.jbpm.pvm.internal.cmd.StartProcessInstanceInLatestCmd.execute(StartProcessInstanceInLatestCmd.java:63)
          at org.jbpm.pvm.internal.cmd.StartProcessInstanceInLatestCmd.execute(StartProcessInstanceInLatestCmd.java:36)
          at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
          at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)
          at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
          at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
          at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
          at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
          at org.jbpm.pvm.internal.svc.ExecutionServiceImpl.startProcessInstanceByKey(ExecutionServiceImpl.java:67)
          at edu.uiowa.icts.controller.TestController.root(TestController.java:66)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
          at java.lang.reflect.Method.invoke(Method.java:597)
          at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.doInvokeMethod(HandlerMethodInvoker.java:710)
          at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:167)
          at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:414)
          at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:402)
          at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:771)
          at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:716)
          at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:647)
          at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:552)
          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:127)
          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:298)
          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
          at java.lang.Thread.run(Thread.java:637)

       

       

       

       

      Here is my Controller Class:

          ProcessEngine processEngine;
            
             @Autowired
             public void setProcessEngine(ProcessEngine processEngine){
                   this.processEngine = processEngine;
                }

       

              @RequestMapping(value = "/{templatepagename}.html")
              public ModelAndView root(ModelMap model, @PathVariable String templatepagename)
              {
                 
                  log.debug("In root..index");
                  model.addAttribute("templatepagename",templatepagename);
                 
                 
                  log.debug("Running Servlet: TestPage");
         
                 RepositoryService repositoryService = processEngine.getRepositoryService();
                 ExecutionService executionService = processEngine.getExecutionService();

       

               
                 String deploymentDbid = repositoryService.createDeployment()
                      .addResourceFromClasspath("superapp.jpdl.xml")
                      .deploy();
                
                 log.error("deploymentDbid: " + deploymentDbid);
                
                     
                 Map<String, Object> variables = new HashMap<String, Object>();
                 variables.put("content", "good");
                     
                 ProcessInstance processInstance = executionService.startProcessInstanceByKey("superapp");
                 
                  return new ModelAndView("Default",model);
                 
                 
              }