Navigation

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Erro na função SQL Atualização

    Fluxos
    2
    2
    84
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A
      Aimberê last edited by

      Galera quando vou fazer uma atualização na tabela dá o seguinte erro.

      wfr.exceptions.WFRCompileException: java.lang.Exception: C:\Program Files (x86)\Softwell Solutions\Maker Studio\Webrun Studio\tomcat\webapps\webrunstudio\src\wfr\com\systems\system_sgr\rules\SgrDesvinculaRecursoVagaServidor.java:98: error: ';' expected
      VARIABLE[4] = "UPDATE GO_104_DISPONIBILIDADE_VAGA SET STA_DISPONIBILIDADE = ? WHERE NUM_DISPONIBILIDADE = ?", 2,
      ^
      C:\Program Files (x86)\Softwell Solutions\Maker Studio\Webrun Studio\tomcat\webapps\webrunstudio\src\wfr\com\systems\system_sgr\rules\SgrDesvinculaRecursoVagaServidor.java:99: error: ';' expected
      VariantPool.get("D"),
      ^
      C:\Program Files (x86)\Softwell Solutions\Maker Studio\Webrun Studio\tomcat\webapps\webrunstudio\src\wfr\com\systems\system_sgr\rules\SgrDesvinculaRecursoVagaServidor.java💯 error: not a statement
      VARIABLE[2];
      ^
      3 errors

      at wfr.util.Functions.compileFile(SourceFile:3743)
      at wfr.util.Functions.compileFile(SourceFile:3699)
      at wfr.util.Functions.compileFile(SourceFile:3676)
      at wfr.rules.RulesClassLoader.compile(SourceFile:151)
      at wfr.rules.WFRRuleManager.create(SourceFile:402)
      at wfr.rules.WFRRuleManager.getRuleClass(SourceFile:118)
      at wfr.web.actions.ExecuteRuleAction.execute(SourceFile:170)
      at wfr.web.Action.doAction(SourceFile:127)
      at wfr.web.Controller.process(SourceFile:138)
      at wfr.web.Controller.doPost(SourceFile:74)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
      at wfr.web.ContextFilter.doFilter(SourceFile:111)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
      at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)
      at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
      at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
      at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798)
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1441)
      at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      at java.lang.Thread.run(Unknown Source)
      Caused by: java.lang.Exception: C:\Program Files (x86)\Softwell Solutions\Maker Studio\Webrun Studio\tomcat\webapps\webrunstudio\src\wfr\com\systems\system_sgr\rules\SgrDesvinculaRecursoVagaServidor.java:98: error: ';' expected
      VARIABLE[4] = "UPDATE GO_104_DISPONIBILIDADE_VAGA SET STA_DISPONIBILIDADE = ? WHERE NUM_DISPONIBILIDADE = ?", 2,
      ^
      C:\Program Files (x86)\Softwell Solutions\Maker Studio\Webrun Studio\tomcat\webapps\webrunstudio\src\wfr\com\systems\system_sgr\rules\SgrDesvinculaRecursoVagaServidor.java:99: error: ';' expected
      VariantPool.get("D"),
      ^
      C:\Program Files (x86)\Softwell Solutions\Maker Studio\Webrun Studio\tomcat\webapps\webrunstudio\src\wfr\com\systems\system_sgr\rules\SgrDesvinculaRecursoVagaServidor.java💯 error: not a statement
      VARIABLE[2];
      ^
      3 errors

      at wfr.util.Functions.compileFile(SourceFile:3735)
      ... 36 more

      Causa:
      java.lang.Exception: C:\Program Files (x86)\Softwell Solutions\Maker Studio\Webrun Studio\tomcat\webapps\webrunstudio\src\wfr\com\systems\system_sgr\rules\SgrDesvinculaRecursoVagaServidor.java:98: error: ';' expected
      VARIABLE[4] = "UPDATE GO_104_DISPONIBILIDADE_VAGA SET STA_DISPONIBILIDADE = ? WHERE NUM_DISPONIBILIDADE = ?", 2,
      ^
      C:\Program Files (x86)\Softwell Solutions\Maker Studio\Webrun Studio\tomcat\webapps\webrunstudio\src\wfr\com\systems\system_sgr\rules\SgrDesvinculaRecursoVagaServidor.java:99: error: ';' expected
      VariantPool.get("D"),
      ^
      C:\Program Files (x86)\Softwell Solutions\Maker Studio\Webrun Studio\tomcat\webapps\webrunstudio\src\wfr\com\systems\system_sgr\rules\SgrDesvinculaRecursoVagaServidor.java💯 error: not a statement
      VARIABLE[2];
      ^
      3 errors

      at wfr.util.Functions.compileFile(SourceFile:3735)
      at wfr.util.Functions.compileFile(SourceFile:3699)
      at wfr.util.Functions.compileFile(SourceFile:3676)
      at wfr.rules.RulesClassLoader.compile(SourceFile:151)
      at wfr.rules.WFRRuleManager.create(SourceFile:402)
      at wfr.rules.WFRRuleManager.getRuleClass(SourceFile:118)
      at wfr.web.actions.ExecuteRuleAction.execute(SourceFile:170)
      at wfr.web.Action.doAction(SourceFile:127)
      at wfr.web.Controller.process(SourceFile:138)
      at wfr.web.Controller.doPost(SourceFile:74)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
      at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
      at wfr.web.ContextFilter.doFilter(SourceFile:111)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)
      at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:624)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341)
      at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:783)
      at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
      at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798)
      at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1441)
      at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      at java.lang.Thread.run(Unknown Source)

      alguém sabe o que pode ser?

      1 Reply Last reply Reply Quote 0
      • DiegoJC
        DiegoJC last edited by

        Pela mensagem de erro, fala que esta falando que falta um ; (ponto e virgula).

        Consegue por o print da função que faz esse update??

        O ";" geralmente é colocado no final da instrução SQL, tenta colocar no final da sua instrução pra ver se passa!

        1 Reply Last reply Reply Quote 0
        • First post
          Last post