• Categorias
  • Recente
  • Tags
  • Popular
Collapse

Erro na função SQL Atualização

Agendado Fixado Trancado Movido Fluxos
2 Posts 2 Posters 473 Visualizações
    • Mais Antigo para Mais Recente
    • Mais Recente para Mais Antigo
    • Mais Votados
Responder
  • Responder como tópico
Entre para responder
Este tópico foi deletado. Apenas usuários com privilégios de moderação de tópico podem vê-lo.
  • A Offline
    A Offline
    Aimberê
    wrote on última edição por
    #1

    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 Resposta Última resposta
    0
  • DiegoJCD Offline
    DiegoJCD Offline
    DiegoJC
    wrote on última edição por
    #2

    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 Resposta Última resposta
    0

  • Login
  • Não tem uma conta? Cadastrar
  • Login or register to search.
  • Primeiro post
    Último post
0
  • Categorias
  • Recente
  • Tags
  • Popular
  • Login
  • Não tem uma conta? Cadastrar
  • Login or register to search.