Hyland Community
Help
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Error running VacationRequest in explorer - after Submit -

activiti-admin
Champ in-the-making
Champ in-the-making

‎06-15-2010 06:29 AM

Strange characters in sql query!

===========================
  at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
        at org.h2.message.DbException.get(DbException.java:167)
        at org.h2.message.DbException.get(DbException.java:144)
        at org.h2.message.DbException.getSyntaxError(DbException.java:179)
        at org.h2.command.Parser.getSyntaxError(Parser.java:474)
        at org.h2.command.Parser.parsePrepared(Parser.java:433)
        at org.h2.command.Parser.parse(Parser.java:278)
        at org.h2.command.Parser.parse(Parser.java:254)
        at org.h2.command.Parser.prepareCommand(Parser.java:222)
        at org.h2.engine.Session.prepareLocal(Session.java:420)
        at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
        at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
        at java.lang.Thread.run(Unknown Source)

        at org.springframework.extensions.webscripts.AbstractWebScript.createSta
tusException(AbstractWebScript.java:731)
        at org.springframework.extensions.webscripts.DeclarativeWebScript.execut
e(DeclarativeWebScript.java:167)
        at org.springframework.extensions.webscripts.PresentationContainer.execu
teScript(PresentationContainer.java:69)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScri
pt(AbstractRuntime.java:307)
        at org.springframework.extensions.webscripts.AbstractRuntime.executeScri
pt(AbstractRuntime.java:178)
        at org.springframework.extensions.webscripts.servlet.WebScriptServlet.se
rvice(WebScriptServlet.java:116)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:191)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
:852)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
ss(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:48
9)
        at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.ibatis.exceptions.IbatisException:
### Error querying database.  Cause: org.h2.jdbc.JdbcSQLException: Syntax error
in SQL statement "┬
  • á ┬áSELECT DISTINCT(T.*)
    • ┬á ┬á
        FROM ACT_TASK T

          INNER JOIN ACT_TASKINVOLVEMENT I ON I.TASK_ID_ = T.ID_

         WHERE  T.ASSIGNEE_ IS NULL
            AND I.TYPE_ = 'candidate'
            AND
            (



                I.GROUP_ID_ IN
                (
                  ?
                )

            )

       ORDER BY ID_
      "; SQL statement:
       select distinct(T.*)
       
        from ACT_TASK T

          inner join ACT_TASKINVOLVEMENT I on I.TASK_ID_ = T.ID_

         WHERE  T.ASSIGNEE_ is null
            and I.TYPE_ = 'candidate'
            and
            (



                I.GROUP_ID_ IN
                (
                  ?
                )

            )

       order by ID_
      [42000-132]
            at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
            at org.h2.message.DbException.get(DbException.java:167)
            at org.h2.message.DbException.get(DbException.java:144)
            at org.h2.message.DbException.getSyntaxError(DbException.java:179)
            at org.h2.command.Parser.getSyntaxError(Parser.java:474)
            at org.h2.command.Parser.parsePrepared(Parser.java:433)
            at org.h2.command.Parser.parse(Parser.java:278)
            at org.h2.command.Parser.parse(Parser.java:254)
            at org.h2.command.Parser.prepareCommand(Parser.java:222)
            at org.h2.engine.Session.prepareLocal(Session.java:420)
            at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
            at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
            at java.lang.Thread.run(Unknown Source)

    ### The error may exist in org/activiti/db/ibatis/task.mapping.xml
    ### The error may involve org.activiti.persistence.dynamicSelectTask
    ### The error occurred while executing a query
    ### SQL: ┬á ┬áselect distinct(T.*)  ┬á ┬á        from ACT_TASK T             inn
    er join ACT_TASKINVOLVEMENT I on I.TASK_ID_ = T.ID_            WHERE  T.ASSIGNEE
    _ is null         and I.TYPE_ = 'candidate'         and          (
                                     I.GROUP_ID_ IN             (               ?
              )                    )       ┬á ┬áorder by ID_  ┬á
    ### Cause: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "┬
  • á ┬á
    • SELECT DISTINCT(T.*)
       
        FROM ACT_TASK T

          INNER JOIN ACT_TASKINVOLVEMENT I ON I.TASK_ID_ = T.ID_

         WHERE  T.ASSIGNEE_ IS NULL
            AND I.TYPE_ = 'candidate'
            AND
            (



                I.GROUP_ID_ IN
                (
                  ?
                )

            )

       ORDER BY ID_
      "; SQL statement:
       select distinct(T.*)
       
        from ACT_TASK T

          inner join ACT_TASKINVOLVEMENT I on I.TASK_ID_ = T.ID_

         WHERE  T.ASSIGNEE_ is null
            and I.TYPE_ = 'candidate'
            and
            (



                I.GROUP_ID_ IN
                (
                  ?
                )

            )

       order by ID_
      [42000-132]
            at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
            at org.h2.message.DbException.get(DbException.java:167)
            at org.h2.message.DbException.get(DbException.java:144)
            at org.h2.message.DbException.getSyntaxError(DbException.java:179)
            at org.h2.command.Parser.getSyntaxError(Parser.java:474)
            at org.h2.command.Parser.parsePrepared(Parser.java:433)
            at org.h2.command.Parser.parse(Parser.java:278)
            at org.h2.command.Parser.parse(Parser.java:254)
            at org.h2.command.Parser.prepareCommand(Parser.java:222)
            at org.h2.engine.Session.prepareLocal(Session.java:420)
            at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
            at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
            at java.lang.Thread.run(Unknown Source)

            at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(Exception
    Factory.java:8)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(Defau
    ltSqlSession.java:61)
            at org.activiti.impl.persistence.IbatisPersistenceSession.dynamicFindTas
    ks(IbatisPersistenceSession.java:406)
            at org.activiti.impl.task.TaskQueryImpl.executeList(TaskQueryImpl.java:8
    1)
            at org.activiti.impl.query.AbstractListQuery$2.execute(AbstractListQuery
    .java:63)
            at org.activiti.impl.query.AbstractListQuery$2.execute(AbstractListQuery
    .java:60)
            at org.activiti.impl.interceptor.CommandExecutorImpl.execute(CommandExec
    utorImpl.java:26)
            at org.activiti.impl.interceptor.CommandContextInterceptor.execute(Comma
    ndContextInterceptor.java:49)
            at org.activiti.impl.query.AbstractListQuery.paginatedList(AbstractListQ
    uery.java:60)
            at org.activiti.rest.api.tasks.TasksGet.executeWebScript(TasksGet.java:5
    9)
            at org.activiti.rest.util.ActivitiWebScript.executeImpl(ActivitiWebScrip
    t.java:68)
            at org.springframework.extensions.webscripts.DeclarativeWebScript.execut
    e(DeclarativeWebScript.java:64)
            … 17 more
    Caused by: org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "┬
  • á ┬á
    • SELECT DISTINCT(T.*)
       
        FROM ACT_TASK T

          INNER JOIN ACT_TASKINVOLVEMENT I ON I.TASK_ID_ = T.ID_

         WHERE  T.ASSIGNEE_ IS NULL
            AND I.TYPE_ = 'candidate'
            AND
            (



                I.GROUP_ID_ IN
                (
                  ?
                )

            )

       ORDER BY ID_
      "; SQL statement:
       select distinct(T.*)
       
        from ACT_TASK T

          inner join ACT_TASKINVOLVEMENT I on I.TASK_ID_ = T.ID_

         WHERE  T.ASSIGNEE_ is null
            and I.TYPE_ = 'candidate'
            and
            (



                I.GROUP_ID_ IN
                (
                  ?
                )

            )

       order by ID_
      [42000-132]
            at org.h2.message.DbException.getJdbcSQLException(DbException.java:316)
            at org.h2.message.DbException.get(DbException.java:167)
            at org.h2.message.DbException.get(DbException.java:144)
            at org.h2.message.DbException.getSyntaxError(DbException.java:179)
            at org.h2.command.Parser.getSyntaxError(Parser.java:474)
            at org.h2.command.Parser.parsePrepared(Parser.java:433)
            at org.h2.command.Parser.parse(Parser.java:278)
            at org.h2.command.Parser.parse(Parser.java:254)
            at org.h2.command.Parser.prepareCommand(Parser.java:222)
            at org.h2.engine.Session.prepareLocal(Session.java:420)
            at org.h2.server.TcpServerThread.process(TcpServerThread.java:224)
            at org.h2.server.TcpServerThread.run(TcpServerThread.java:135)
            at java.lang.Thread.run(Unknown Source)

            at org.h2.engine.SessionRemote.done(SessionRemote.java:505)
            at org.h2.command.CommandRemote.prepare(CommandRemote.java:70)
            at org.h2.command.CommandRemote.<init>(CommandRemote.java:48)
            at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:401)
            at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1070)
            at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:7
    1)
            at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:233)
            at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
    sorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:597)
            at org.apache.ibatis.datasource.pooled.PooledConnection.invoke(PooledCon
    nection.java:225)
            at $Proxy5.prepareStatement(Unknown Source)
            at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
    sorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:597)
            at org.apache.ibatis.logging.jdbc.ConnectionLogger.invoke(ConnectionLogg
    er.java:35)
            at $Proxy5.prepareStatement(Unknown Source)
            at org.apache.ibatis.executor.statement.PreparedStatementHandler.instant
    iateStatement(PreparedStatementHandler.java:50)
            at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(Bas
    eStatementHandler.java:64)
            at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(
    RoutingStatementHandler.java:39)
            at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExec
    utor.java:55)
            at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java
    :40)
            at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:94)
            at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java
    :72)
            at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(Defau
    ltSqlSession.java:59)
            … 27 more
    Labels:
    0 Kudos
    1 REPLY 1

    activiti-admin
    Champ in-the-making
    Champ in-the-making

    ‎06-15-2010 06:59 AM

    If you run tomcat you can add this to the catalina.bat at the 4 %_EXECJAVA%-lines (pretty much the last ones) like this

    %_EXECJAVA% %JAVA_OPTS% … -Dfile.encoding=UTF-8 …
    0 Kudos
    Getting started

    Tags

    Find what you came for

    We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.

    Copyright © 2025 Khoros, LLC