API tools faq
paste
Advertisement
guiness333

Untitled

guiness333
Nov 20th, 2019
545
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 150.88 KB | None | 0 0
raw download clone embed print report
  1.  
  2. webjump-nb013@DESKTOP-B5H8TRR MINGW64 ~/Documents/TCC/jorge-teste-java/sys_mesario-0.0.1
  3. $ java -jar sys_mesario-0.0.1.jar                                                                                       SLF4J: Class path contains multiple SLF4J bindings.
  4. SLF4J: Found binding in [jar:file:/C:/Users/webjump-nb013/Documents/TCC/jorge-teste-java/sys_mesario-0.0.1/lib/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  5. SLF4J: Found binding in [jar:file:/C:/Users/webjump-nb013/Documents/TCC/jorge-teste-java/sys_mesario-0.0.1/lib/log4j-slf4j-impl-2.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]
  6. SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
  7. SLF4J: Actual binding is of type [ch.qos.logback.classic.util.ContextSelectorStaticBinder]
  8.  
  9.   .   ____          _            __ _ _
  10.  /\\ / ___'_ __ _ _(_)_ __  __ _ \ \ \ \
  11. ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
  12.  \\/  ___)| |_)| | | | | || (_| |  ) ) ) )
  13.   '  |____| .__|_| |_|_| |_\__, | / / / /
  14. =========|_|==============|___/=/_/_/_/
  15. :: Spring Boot ::        (v2.1.6.RELEASE)
  16.  
  17. 2019-11-20 19:36:25.887  INFO 14464 --- [           main] c.b.s.presentation.api.Application       : Starting Application v0.0.1 on DESKTOP-B5H8TRR with PID 14464 (C:\Users\webjump-nb013\Documents\TCC\jorge-teste-java\sys_mesario-0.0.1\sys_mesario-0.0.1.jar started by webjump-nb013 in C:\Users\webjump-nb013\Documents\TCC\jorge-teste-java\sys_mesario-0.0.1)
  18. 2019-11-20 19:36:25.890  INFO 14464 --- [           main] c.b.s.presentation.api.Application       : No active profile set, falling back to default profiles: default
  19. 2019-11-20 19:36:27.746  INFO 14464 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat initialized with port(s): 8080 (http)
  20. 2019-11-20 19:36:27.785  INFO 14464 --- [           main] o.apache.catalina.core.StandardService   : Starting service [Tomcat]
  21. 2019-11-20 19:36:27.786  INFO 14464 --- [           main] org.apache.catalina.core.StandardEngine  : Starting Servlet engine: [Apache Tomcat/9.0.21]
  22. 2019-11-20 19:36:28.254  INFO 14464 --- [           main] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring embedded WebApplicationContext
  23. 2019-11-20 19:36:28.255  INFO 14464 --- [           main] o.s.web.context.ContextLoader            : Root WebApplicationContext: initialization completed in 2307 ms
  24. 2019-11-20 19:36:28.596  INFO 14464 --- [           main] o.s.s.concurrent.ThreadPoolTaskExecutor  : Initializing ExecutorService 'applicationTaskExecutor'
  25. 2019-11-20 19:36:28.946  INFO 14464 --- [           main] o.s.b.w.embedded.tomcat.TomcatWebServer  : Tomcat started on port(s): 8080 (http) with context path ''
  26. 2019-11-20 19:36:28.952  INFO 14464 --- [           main] c.b.s.presentation.api.Application       : Started Application in 3.491 seconds (JVM running for 8.27)
  27. 2019-11-20 19:37:07.463  INFO 14464 --- [nio-8080-exec-1] o.a.c.c.C.[Tomcat].[localhost].[/]       : Initializing Spring DispatcherServlet 'dispatcherServlet'
  28. 2019-11-20 19:37:07.494  INFO 14464 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet        : Initializing Servlet 'dispatcherServlet'
  29. 2019-11-20 19:37:07.509  INFO 14464 --- [nio-8080-exec-1] o.s.web.servlet.DispatcherServlet        : Completed initialization in 10 ms
  30. 2019-11-20 19:37:07.768  INFO 14464 --- [nio-8080-exec-1] c.b.sys_mesario.logger.Logger            : ###### Recebido POST para iniciar urna de endereco: 1
  31. 2019-11-20 19:37:07.776  INFO 14464 --- [nio-8080-exec-1] c.b.sys_mesario.logger.Logger            : ###### Tentando cadastrar urna de endereco: 1
  32. 2019-11-20 19:37:07.781  INFO 14464 --- [nio-8080-exec-1] c.b.sys_mesario.logger.Logger            : ###### Pesquisando urna por endereco: 1
  33. 2019-11-20 19:37:08.962  INFO 14464 --- [nio-8080-exec-1] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  34. 2019-11-20 19:37:08.991  INFO 14464 --- [nio-8080-exec-1] c.b.sys_mesario.logger.Logger            : ###### Nenhuma urna encontrada para o endereco: 1
  35. 2019-11-20 19:37:08.993  INFO 14464 --- [nio-8080-exec-1] c.b.sys_mesario.logger.Logger            : ###### Urna de endereco 1 nao existia e sera adicionada
  36. 2019-11-20 19:37:08.995  INFO 14464 --- [nio-8080-exec-1] c.b.sys_mesario.logger.Logger            : ###### Estado da urna de endereco: 1 mudou de estado INACTIVE/ACTIVE
  37. 2019-11-20 19:37:08.996  INFO 14464 --- [nio-8080-exec-1] c.b.sys_mesario.logger.Logger            : ###### Urna removida das inativas: 1
  38. 2019-11-20 19:37:08.997  INFO 14464 --- [nio-8080-exec-1] c.b.sys_mesario.logger.Logger            : ###### Urna adicionada as ativas: 1
  39. 2019-11-20 19:37:09.005  INFO 14464 --- [nio-8080-exec-1] c.b.sys_mesario.logger.Logger            : ###### Agendando limite de tempo para a urna responder
  40. 2019-11-20 19:37:09.059  INFO 14464 --- [nio-8080-exec-1] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  41. 2019-11-20 19:37:09.070  INFO 14464 --- [nio-8080-exec-1] c.b.sys_mesario.logger.Logger            : ###### Nova urna gravada: Endereco da urna: 1, Estado da urna: INACTIVE
  42. 2019-11-20 19:37:36.928  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Recebida requisicao para autenticar usuario: 45598364859
  43. 2019-11-20 19:37:36.931  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Iniciando autentcacao do usuario por cpf: 45598364859
  44. 2019-11-20 19:37:36.989  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  45. 2019-11-20 19:37:36.995  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Encontrado usuario: CPF: 45598364859, Nome: walber martin
  46. 2019-11-20 19:37:36.996  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Tentando autenticar usuario: CPF: 45598364859, Nome: walber martin
  47. Scan your finger
  48. Matching finger: left pinky, FAR achieved: 0,00000.
  49. 2019-11-20 19:37:40.023  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Verificando se o usuario 45598364859 esta votando
  50. 2019-11-20 19:37:40.024  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Usuario 45598364859 nÒo esta votando
  51. 2019-11-20 19:37:40.096  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  52. 2019-11-20 19:37:40.097  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Verificando se o usuario 45598364859 ja votou
  53. 2019-11-20 19:37:40.101  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### O usuario 45598364859 ainda nao votou
  54. 2019-11-20 19:37:40.102  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Endereco da urna ativa devolvida: 1
  55. 2019-11-20 19:37:40.103  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Quantidade de urnas ativas: 1
  56. 2019-11-20 19:37:40.109  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Procurando eleicao atualmente ativa
  57. 2019-11-20 19:37:40.171  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  58. 2019-11-20 19:37:40.176  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Eleicao nao existia e sera criada...
  59. 2019-11-20 19:37:40.179  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Guardando eleicao de id: 52423341-5a21-4c91-bd19-7d304c62f8d4
  60. 2019-11-20 19:37:40.239  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  61. 2019-11-20 19:37:40.250  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Eleicao de id: 52423341-5a21-4c91-bd19-7d304c62f8d4 guardada com sucesso
  62. 2019-11-20 19:37:40.252  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Eleicao de id: 52423341-5a21-4c91-bd19-7d304c62f8d4 agendada para finalizar em: Thu Nov 21 00:37:40 BRT 2019
  63. 2019-11-20 19:37:40.252  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Pesquisando urna por endereco: 1
  64. 2019-11-20 19:37:40.312  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  65. 2019-11-20 19:37:40.313  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Encontrado urna: Endereco da urna: 1, Estado da urna: INACTIVE
  66. 2019-11-20 19:37:40.314  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Estado da urna de endereco: 1 mudou de estado INACTIVE/BUSY
  67. 2019-11-20 19:37:40.314  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Urna removida das inativas: 1
  68. 2019-11-20 19:37:40.385  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  69. 2019-11-20 19:37:40.388  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Nova urna gravada: Endereco da urna: 1, Estado da urna: INACTIVE
  70. 2019-11-20 19:37:40.443  INFO 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  71. 2019-11-20 19:37:40.459 ERROR 14464 --- [nio-8080-exec-4] c.b.sys_mesario.logger.Logger            : ###### Erro ao guardar sessao:  Id da sessao: com.blockchain_solutions.sys_mesario.domain.model.voting_session.VotingSessionId@2fe6e6c6, Usuario da sessao: 45598364859, Id Eleicao: 45598364859, Endereco da urna: 1, Comeco da sessao: 2019-11-20T19:37:40.392, Fim da sessao: 2019-11-20T19:42:40.392, Esta concluida: false-java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).
  72.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
  73.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  74.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  75.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  76.        at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1372)
  77.        at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1385)
  78.        at com.mysql.cj.jdbc.ClientPreparedStatement.setBoolean(ClientPreparedStatement.java:1467)
  79.        at com.blockchain_solutions.sys_mesario.application.repository.VotingSessionRepositoryImpl.store(VotingSessionRepositoryImpl.java:145)
  80.        at com.blockchain_solutions.sys_mesario.domain.service.UserVotingService.createSessionTo(UserVotingService.java:37)
  81.        at com.blockchain_solutions.sys_mesario.application.service.UserAutenticationService.autenticateByCpf(UserAutenticationService.java:76)
  82.        at com.blockchain_solutions.sys_mesario.presentation.facade.UserAutenticationFacade.autenticate(UserAutenticationFacade.java:31)
  83.        at com.blockchain_solutions.sys_mesario.presentation.api.ApplicationController.autenticate(ApplicationController.java:38)
  84.        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  85.        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  86.        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  87.        at java.lang.reflect.Method.invoke(Unknown Source)
  88.        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  89.        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  90.        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
  91.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892)
  92.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  93.        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  94.        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039)
  95.        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
  96.        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
  97.        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897)
  98.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
  99.        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
  100.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  101.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  102.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  103.        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  104.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  105.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  106.        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
  107.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  108.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  109.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  110.        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
  111.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  112.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  113.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  114.        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
  115.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  116.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  117.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  118.        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
  119.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  120.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  121.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  122.        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  123.        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  124.        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
  125.        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  126.        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  127.        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  128.        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  129.        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
  130.        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  131.        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
  132.        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
  133.        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  134.        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  135.        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  136.        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  137.        at java.lang.Thread.run(Unknown Source)
  138.  
  139.  
  140. java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).
  141.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  142.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  143.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  144.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  145.        at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1372) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  146.        at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1385) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  147.        at com.mysql.cj.jdbc.ClientPreparedStatement.setBoolean(ClientPreparedStatement.java:1467) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  148.        at com.blockchain_solutions.sys_mesario.application.repository.VotingSessionRepositoryImpl.store(VotingSessionRepositoryImpl.java:145) ~[sys_mesario-0.0.1.jar:0.0.1]
  149.        at com.blockchain_solutions.sys_mesario.domain.service.UserVotingService.createSessionTo(UserVotingService.java:37) [sys_mesario-0.0.1.jar:0.0.1]
  150.        at com.blockchain_solutions.sys_mesario.application.service.UserAutenticationService.autenticateByCpf(UserAutenticationService.java:76) [sys_mesario-0.0.1.jar:0.0.1]
  151.        at com.blockchain_solutions.sys_mesario.presentation.facade.UserAutenticationFacade.autenticate(UserAutenticationFacade.java:31) [sys_mesario-0.0.1.jar:0.0.1]
  152.        at com.blockchain_solutions.sys_mesario.presentation.api.ApplicationController.autenticate(ApplicationController.java:38) [sys_mesario-0.0.1.jar:0.0.1]
  153.        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_231]
  154.        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  155.        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  156.        at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_231]
  157.        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  158.        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  159.        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  160.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  161.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  162.        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  163.        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  164.        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  165.        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  166.        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  167.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) [tomcat-embed-core-9.0.21.jar:9.0.21]
  168.        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  169.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) [tomcat-embed-core-9.0.21.jar:9.0.21]
  170.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-embed-core-9.0.21.jar:9.0.21]
  171.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  172.        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.21.jar:9.0.21]
  173.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  174.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  175.        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  176.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  177.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  178.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  179.        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  180.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  181.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  182.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  183.        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  184.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  185.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  186.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  187.        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  188.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  189.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  190.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  191.        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-embed-core-9.0.21.jar:9.0.21]
  192.        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.21.jar:9.0.21]
  193.        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) [tomcat-embed-core-9.0.21.jar:9.0.21]
  194.        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.21.jar:9.0.21]
  195.        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.21.jar:9.0.21]
  196.        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.21.jar:9.0.21]
  197.        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.21.jar:9.0.21]
  198.        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-embed-core-9.0.21.jar:9.0.21]
  199.        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-9.0.21.jar:9.0.21]
  200.        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) [tomcat-embed-core-9.0.21.jar:9.0.21]
  201.        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) [tomcat-embed-core-9.0.21.jar:9.0.21]
  202.        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.21.jar:9.0.21]
  203.        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_231]
  204.        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_231]
  205.        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.21.jar:9.0.21]
  206.        at java.lang.Thread.run(Unknown Source) [na:1.8.0_231]
  207.  
  208. 2019-11-20 19:37:40.466 ERROR 14464 --- [nio-8080-exec-4] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.lang.RuntimeException: java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).] with root cause
  209.  
  210. java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).
  211.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  212.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  213.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  214.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  215.        at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1372) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  216.        at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1385) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  217.        at com.mysql.cj.jdbc.ClientPreparedStatement.setBoolean(ClientPreparedStatement.java:1467) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  218.        at com.blockchain_solutions.sys_mesario.application.repository.VotingSessionRepositoryImpl.store(VotingSessionRepositoryImpl.java:145) ~[sys_mesario-0.0.1.jar:0.0.1]
  219.        at com.blockchain_solutions.sys_mesario.domain.service.UserVotingService.createSessionTo(UserVotingService.java:37) ~[sys_mesario-0.0.1.jar:0.0.1]
  220.        at com.blockchain_solutions.sys_mesario.application.service.UserAutenticationService.autenticateByCpf(UserAutenticationService.java:76) ~[sys_mesario-0.0.1.jar:0.0.1]
  221.        at com.blockchain_solutions.sys_mesario.presentation.facade.UserAutenticationFacade.autenticate(UserAutenticationFacade.java:31) ~[sys_mesario-0.0.1.jar:0.0.1]
  222.        at com.blockchain_solutions.sys_mesario.presentation.api.ApplicationController.autenticate(ApplicationController.java:38) ~[sys_mesario-0.0.1.jar:0.0.1]
  223.        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_231]
  224.        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  225.        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  226.        at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_231]
  227.        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  228.        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  229.        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  230.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  231.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  232.        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  233.        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  234.        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  235.        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  236.        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  237.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  238.        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  239.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  240.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  241.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  242.        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.21.jar:9.0.21]
  243.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  244.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  245.        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  246.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  247.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  248.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  249.        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  250.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  251.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  252.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  253.        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  254.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  255.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  256.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  257.        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  258.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  259.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  260.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  261.        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  262.        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.21.jar:9.0.21]
  263.        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) [tomcat-embed-core-9.0.21.jar:9.0.21]
  264.        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.21.jar:9.0.21]
  265.        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.21.jar:9.0.21]
  266.        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.21.jar:9.0.21]
  267.        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.21.jar:9.0.21]
  268.        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-embed-core-9.0.21.jar:9.0.21]
  269.        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-9.0.21.jar:9.0.21]
  270.        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) [tomcat-embed-core-9.0.21.jar:9.0.21]
  271.        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) [tomcat-embed-core-9.0.21.jar:9.0.21]
  272.        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.21.jar:9.0.21]
  273.        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_231]
  274.        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_231]
  275.        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.21.jar:9.0.21]
  276.        at java.lang.Thread.run(Unknown Source) [na:1.8.0_231]
  277.  
  278. 2019-11-20 19:37:43.500  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Recebida requisicao para autenticar usuario: 45598364859
  279. 2019-11-20 19:37:43.505  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Iniciando autentcacao do usuario por cpf: 45598364859
  280. 2019-11-20 19:37:43.552  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  281. 2019-11-20 19:37:43.555  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Encontrado usuario: CPF: 45598364859, Nome: walber martin
  282. 2019-11-20 19:37:43.557  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Tentando autenticar usuario: CPF: 45598364859, Nome: walber martin
  283. Scan your finger
  284. Matching finger: left pinky, FAR achieved: 0,00000.
  285. 2019-11-20 19:37:45.518  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Verificando se o usuario 45598364859 esta votando
  286. 2019-11-20 19:37:45.520  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Usuario 45598364859 nÒo esta votando
  287. 2019-11-20 19:37:45.611  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  288. 2019-11-20 19:37:45.611  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Verificando se o usuario 45598364859 ja votou
  289. 2019-11-20 19:37:45.617  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### O usuario 45598364859 ainda nao votou
  290. 2019-11-20 19:37:45.618  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Endereco da urna ativa devolvida: 1
  291. 2019-11-20 19:37:45.620  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Quantidade de urnas ativas: 1
  292. 2019-11-20 19:37:45.621  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Pesquisando urna por endereco: 1
  293. 2019-11-20 19:37:45.702  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  294. 2019-11-20 19:37:45.706  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Encontrado urna: Endereco da urna: 1, Estado da urna: INACTIVE
  295. 2019-11-20 19:37:45.707  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Estado da urna de endereco: 1 mudou de estado INACTIVE/BUSY
  296. 2019-11-20 19:37:45.707  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Urna removida das inativas: 1
  297. 2019-11-20 19:37:45.774  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  298. 2019-11-20 19:37:45.780  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Nova urna gravada: Endereco da urna: 1, Estado da urna: INACTIVE
  299. 2019-11-20 19:37:45.843  INFO 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  300. 2019-11-20 19:37:45.846 ERROR 14464 --- [nio-8080-exec-5] c.b.sys_mesario.logger.Logger            : ###### Erro ao guardar sessao:  Id da sessao: com.blockchain_solutions.sys_mesario.domain.model.voting_session.VotingSessionId@67a9c134, Usuario da sessao: 45598364859, Id Eleicao: 45598364859, Endereco da urna: 1, Comeco da sessao: 2019-11-20T19:37:45.782, Fim da sessao: 2019-11-20T19:42:45.782, Esta concluida: false-java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).
  301.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
  302.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  303.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  304.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  305.        at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1372)
  306.        at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1385)
  307.        at com.mysql.cj.jdbc.ClientPreparedStatement.setBoolean(ClientPreparedStatement.java:1467)
  308.        at com.blockchain_solutions.sys_mesario.application.repository.VotingSessionRepositoryImpl.store(VotingSessionRepositoryImpl.java:145)
  309.        at com.blockchain_solutions.sys_mesario.domain.service.UserVotingService.createSessionTo(UserVotingService.java:37)
  310.        at com.blockchain_solutions.sys_mesario.application.service.UserAutenticationService.autenticateByCpf(UserAutenticationService.java:76)
  311.        at com.blockchain_solutions.sys_mesario.presentation.facade.UserAutenticationFacade.autenticate(UserAutenticationFacade.java:31)
  312.        at com.blockchain_solutions.sys_mesario.presentation.api.ApplicationController.autenticate(ApplicationController.java:38)
  313.        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  314.        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  315.        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  316.        at java.lang.reflect.Method.invoke(Unknown Source)
  317.        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  318.        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  319.        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
  320.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892)
  321.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  322.        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  323.        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039)
  324.        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
  325.        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
  326.        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897)
  327.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
  328.        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
  329.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  330.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  331.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  332.        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  333.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  334.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  335.        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
  336.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  337.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  338.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  339.        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
  340.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  341.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  342.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  343.        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
  344.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  345.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  346.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  347.        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
  348.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  349.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  350.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  351.        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  352.        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  353.        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
  354.        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  355.        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  356.        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  357.        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  358.        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
  359.        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  360.        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
  361.        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
  362.        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  363.        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  364.        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  365.        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  366.        at java.lang.Thread.run(Unknown Source)
  367.  
  368.  
  369. java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).
  370.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  371.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  372.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  373.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  374.        at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1372) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  375.        at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1385) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  376.        at com.mysql.cj.jdbc.ClientPreparedStatement.setBoolean(ClientPreparedStatement.java:1467) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  377.        at com.blockchain_solutions.sys_mesario.application.repository.VotingSessionRepositoryImpl.store(VotingSessionRepositoryImpl.java:145) ~[sys_mesario-0.0.1.jar:0.0.1]
  378.        at com.blockchain_solutions.sys_mesario.domain.service.UserVotingService.createSessionTo(UserVotingService.java:37) [sys_mesario-0.0.1.jar:0.0.1]
  379.        at com.blockchain_solutions.sys_mesario.application.service.UserAutenticationService.autenticateByCpf(UserAutenticationService.java:76) [sys_mesario-0.0.1.jar:0.0.1]
  380.        at com.blockchain_solutions.sys_mesario.presentation.facade.UserAutenticationFacade.autenticate(UserAutenticationFacade.java:31) [sys_mesario-0.0.1.jar:0.0.1]
  381.        at com.blockchain_solutions.sys_mesario.presentation.api.ApplicationController.autenticate(ApplicationController.java:38) [sys_mesario-0.0.1.jar:0.0.1]
  382.        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_231]
  383.        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  384.        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  385.        at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_231]
  386.        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  387.        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  388.        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  389.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  390.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  391.        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  392.        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  393.        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  394.        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  395.        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  396.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) [tomcat-embed-core-9.0.21.jar:9.0.21]
  397.        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  398.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) [tomcat-embed-core-9.0.21.jar:9.0.21]
  399.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-embed-core-9.0.21.jar:9.0.21]
  400.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  401.        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.21.jar:9.0.21]
  402.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  403.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  404.        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  405.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  406.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  407.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  408.        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  409.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  410.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  411.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  412.        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  413.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  414.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  415.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  416.        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  417.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  418.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  419.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  420.        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-embed-core-9.0.21.jar:9.0.21]
  421.        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.21.jar:9.0.21]
  422.        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) [tomcat-embed-core-9.0.21.jar:9.0.21]
  423.        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.21.jar:9.0.21]
  424.        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.21.jar:9.0.21]
  425.        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.21.jar:9.0.21]
  426.        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.21.jar:9.0.21]
  427.        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-embed-core-9.0.21.jar:9.0.21]
  428.        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-9.0.21.jar:9.0.21]
  429.        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) [tomcat-embed-core-9.0.21.jar:9.0.21]
  430.        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) [tomcat-embed-core-9.0.21.jar:9.0.21]
  431.        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.21.jar:9.0.21]
  432.        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_231]
  433.        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_231]
  434.        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.21.jar:9.0.21]
  435.        at java.lang.Thread.run(Unknown Source) [na:1.8.0_231]
  436.  
  437. 2019-11-20 19:37:45.852 ERROR 14464 --- [nio-8080-exec-5] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.lang.RuntimeException: java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).] with root cause
  438.  
  439. java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).
  440.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  441.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  442.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  443.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  444.        at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1372) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  445.        at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1385) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  446.        at com.mysql.cj.jdbc.ClientPreparedStatement.setBoolean(ClientPreparedStatement.java:1467) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  447.        at com.blockchain_solutions.sys_mesario.application.repository.VotingSessionRepositoryImpl.store(VotingSessionRepositoryImpl.java:145) ~[sys_mesario-0.0.1.jar:0.0.1]
  448.        at com.blockchain_solutions.sys_mesario.domain.service.UserVotingService.createSessionTo(UserVotingService.java:37) ~[sys_mesario-0.0.1.jar:0.0.1]
  449.        at com.blockchain_solutions.sys_mesario.application.service.UserAutenticationService.autenticateByCpf(UserAutenticationService.java:76) ~[sys_mesario-0.0.1.jar:0.0.1]
  450.        at com.blockchain_solutions.sys_mesario.presentation.facade.UserAutenticationFacade.autenticate(UserAutenticationFacade.java:31) ~[sys_mesario-0.0.1.jar:0.0.1]
  451.        at com.blockchain_solutions.sys_mesario.presentation.api.ApplicationController.autenticate(ApplicationController.java:38) ~[sys_mesario-0.0.1.jar:0.0.1]
  452.        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_231]
  453.        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  454.        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  455.        at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_231]
  456.        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  457.        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  458.        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  459.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  460.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  461.        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  462.        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  463.        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  464.        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  465.        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  466.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  467.        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  468.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  469.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  470.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  471.        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.21.jar:9.0.21]
  472.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  473.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  474.        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  475.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  476.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  477.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  478.        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  479.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  480.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  481.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  482.        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  483.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  484.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  485.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  486.        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  487.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  488.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  489.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  490.        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  491.        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.21.jar:9.0.21]
  492.        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) [tomcat-embed-core-9.0.21.jar:9.0.21]
  493.        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.21.jar:9.0.21]
  494.        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.21.jar:9.0.21]
  495.        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.21.jar:9.0.21]
  496.        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.21.jar:9.0.21]
  497.        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-embed-core-9.0.21.jar:9.0.21]
  498.        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-9.0.21.jar:9.0.21]
  499.        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) [tomcat-embed-core-9.0.21.jar:9.0.21]
  500.        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) [tomcat-embed-core-9.0.21.jar:9.0.21]
  501.        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.21.jar:9.0.21]
  502.        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_231]
  503.        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_231]
  504.        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.21.jar:9.0.21]
  505.        at java.lang.Thread.run(Unknown Source) [na:1.8.0_231]
  506.  
  507. 2019-11-20 19:37:52.321  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Recebida requisicao para autenticar usuario: 45598364859
  508. 2019-11-20 19:37:52.323  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Iniciando autentcacao do usuario por cpf: 45598364859
  509. 2019-11-20 19:37:52.383  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  510. 2019-11-20 19:37:52.385  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Encontrado usuario: CPF: 45598364859, Nome: walber martin
  511. 2019-11-20 19:37:52.386  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Tentando autenticar usuario: CPF: 45598364859, Nome: walber martin
  512. Scan your finger
  513. Matching finger: left pinky, FAR achieved: 0,00000.
  514. 2019-11-20 19:37:53.674  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Verificando se o usuario 45598364859 esta votando
  515. 2019-11-20 19:37:53.676  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Usuario 45598364859 nÒo esta votando
  516. 2019-11-20 19:37:53.749  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  517. 2019-11-20 19:37:53.749  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Verificando se o usuario 45598364859 ja votou
  518. 2019-11-20 19:37:53.752  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### O usuario 45598364859 ainda nao votou
  519. 2019-11-20 19:37:53.753  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Endereco da urna ativa devolvida: 1
  520. 2019-11-20 19:37:53.753  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Quantidade de urnas ativas: 1
  521. 2019-11-20 19:37:53.754  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Pesquisando urna por endereco: 1
  522. 2019-11-20 19:37:53.803  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  523. 2019-11-20 19:37:53.806  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Encontrado urna: Endereco da urna: 1, Estado da urna: INACTIVE
  524. 2019-11-20 19:37:53.807  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Estado da urna de endereco: 1 mudou de estado INACTIVE/BUSY
  525. 2019-11-20 19:37:53.808  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Urna removida das inativas: 1
  526. 2019-11-20 19:37:53.862  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  527. 2019-11-20 19:37:53.864  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Nova urna gravada: Endereco da urna: 1, Estado da urna: INACTIVE
  528. 2019-11-20 19:37:53.913  INFO 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  529. 2019-11-20 19:37:53.916 ERROR 14464 --- [nio-8080-exec-7] c.b.sys_mesario.logger.Logger            : ###### Erro ao guardar sessao:  Id da sessao: com.blockchain_solutions.sys_mesario.domain.model.voting_session.VotingSessionId@38bf26d0, Usuario da sessao: 45598364859, Id Eleicao: 45598364859, Endereco da urna: 1, Comeco da sessao: 2019-11-20T19:37:53.865, Fim da sessao: 2019-11-20T19:42:53.865, Esta concluida: false-java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).
  530.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
  531.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  532.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  533.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  534.        at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1372)
  535.        at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1385)
  536.        at com.mysql.cj.jdbc.ClientPreparedStatement.setBoolean(ClientPreparedStatement.java:1467)
  537.        at com.blockchain_solutions.sys_mesario.application.repository.VotingSessionRepositoryImpl.store(VotingSessionRepositoryImpl.java:145)
  538.        at com.blockchain_solutions.sys_mesario.domain.service.UserVotingService.createSessionTo(UserVotingService.java:37)
  539.        at com.blockchain_solutions.sys_mesario.application.service.UserAutenticationService.autenticateByCpf(UserAutenticationService.java:76)
  540.        at com.blockchain_solutions.sys_mesario.presentation.facade.UserAutenticationFacade.autenticate(UserAutenticationFacade.java:31)
  541.        at com.blockchain_solutions.sys_mesario.presentation.api.ApplicationController.autenticate(ApplicationController.java:38)
  542.        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  543.        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  544.        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  545.        at java.lang.reflect.Method.invoke(Unknown Source)
  546.        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  547.        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  548.        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
  549.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892)
  550.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  551.        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  552.        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039)
  553.        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
  554.        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
  555.        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897)
  556.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
  557.        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
  558.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  559.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  560.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  561.        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  562.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  563.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  564.        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
  565.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  566.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  567.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  568.        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
  569.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  570.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  571.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  572.        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
  573.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  574.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  575.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  576.        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
  577.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  578.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  579.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  580.        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  581.        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  582.        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
  583.        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  584.        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  585.        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  586.        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  587.        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
  588.        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  589.        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
  590.        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
  591.        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  592.        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  593.        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  594.        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  595.        at java.lang.Thread.run(Unknown Source)
  596.  
  597.  
  598. java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).
  599.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  600.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  601.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  602.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  603.        at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1372) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  604.        at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1385) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  605.        at com.mysql.cj.jdbc.ClientPreparedStatement.setBoolean(ClientPreparedStatement.java:1467) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  606.        at com.blockchain_solutions.sys_mesario.application.repository.VotingSessionRepositoryImpl.store(VotingSessionRepositoryImpl.java:145) ~[sys_mesario-0.0.1.jar:0.0.1]
  607.        at com.blockchain_solutions.sys_mesario.domain.service.UserVotingService.createSessionTo(UserVotingService.java:37) [sys_mesario-0.0.1.jar:0.0.1]
  608.        at com.blockchain_solutions.sys_mesario.application.service.UserAutenticationService.autenticateByCpf(UserAutenticationService.java:76) [sys_mesario-0.0.1.jar:0.0.1]
  609.        at com.blockchain_solutions.sys_mesario.presentation.facade.UserAutenticationFacade.autenticate(UserAutenticationFacade.java:31) [sys_mesario-0.0.1.jar:0.0.1]
  610.        at com.blockchain_solutions.sys_mesario.presentation.api.ApplicationController.autenticate(ApplicationController.java:38) [sys_mesario-0.0.1.jar:0.0.1]
  611.        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_231]
  612.        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  613.        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  614.        at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_231]
  615.        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  616.        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  617.        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  618.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  619.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  620.        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  621.        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  622.        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  623.        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  624.        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  625.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) [tomcat-embed-core-9.0.21.jar:9.0.21]
  626.        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  627.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) [tomcat-embed-core-9.0.21.jar:9.0.21]
  628.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-embed-core-9.0.21.jar:9.0.21]
  629.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  630.        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.21.jar:9.0.21]
  631.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  632.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  633.        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  634.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  635.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  636.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  637.        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  638.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  639.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  640.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  641.        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  642.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  643.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  644.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  645.        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  646.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  647.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  648.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  649.        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-embed-core-9.0.21.jar:9.0.21]
  650.        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.21.jar:9.0.21]
  651.        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) [tomcat-embed-core-9.0.21.jar:9.0.21]
  652.        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.21.jar:9.0.21]
  653.        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.21.jar:9.0.21]
  654.        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.21.jar:9.0.21]
  655.        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.21.jar:9.0.21]
  656.        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-embed-core-9.0.21.jar:9.0.21]
  657.        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-9.0.21.jar:9.0.21]
  658.        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) [tomcat-embed-core-9.0.21.jar:9.0.21]
  659.        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) [tomcat-embed-core-9.0.21.jar:9.0.21]
  660.        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.21.jar:9.0.21]
  661.        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_231]
  662.        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_231]
  663.        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.21.jar:9.0.21]
  664.        at java.lang.Thread.run(Unknown Source) [na:1.8.0_231]
  665.  
  666. 2019-11-20 19:37:53.920 ERROR 14464 --- [nio-8080-exec-7] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.lang.RuntimeException: java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).] with root cause
  667.  
  668. java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).
  669.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  670.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  671.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  672.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  673.        at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1372) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  674.        at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1385) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  675.        at com.mysql.cj.jdbc.ClientPreparedStatement.setBoolean(ClientPreparedStatement.java:1467) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  676.        at com.blockchain_solutions.sys_mesario.application.repository.VotingSessionRepositoryImpl.store(VotingSessionRepositoryImpl.java:145) ~[sys_mesario-0.0.1.jar:0.0.1]
  677.        at com.blockchain_solutions.sys_mesario.domain.service.UserVotingService.createSessionTo(UserVotingService.java:37) ~[sys_mesario-0.0.1.jar:0.0.1]
  678.        at com.blockchain_solutions.sys_mesario.application.service.UserAutenticationService.autenticateByCpf(UserAutenticationService.java:76) ~[sys_mesario-0.0.1.jar:0.0.1]
  679.        at com.blockchain_solutions.sys_mesario.presentation.facade.UserAutenticationFacade.autenticate(UserAutenticationFacade.java:31) ~[sys_mesario-0.0.1.jar:0.0.1]
  680.        at com.blockchain_solutions.sys_mesario.presentation.api.ApplicationController.autenticate(ApplicationController.java:38) ~[sys_mesario-0.0.1.jar:0.0.1]
  681.        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_231]
  682.        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  683.        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  684.        at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_231]
  685.        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  686.        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  687.        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  688.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  689.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  690.        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  691.        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  692.        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  693.        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  694.        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  695.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  696.        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  697.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  698.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  699.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  700.        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.21.jar:9.0.21]
  701.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  702.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  703.        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  704.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  705.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  706.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  707.        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  708.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  709.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  710.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  711.        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  712.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  713.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  714.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  715.        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  716.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  717.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  718.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  719.        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  720.        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.21.jar:9.0.21]
  721.        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) [tomcat-embed-core-9.0.21.jar:9.0.21]
  722.        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.21.jar:9.0.21]
  723.        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.21.jar:9.0.21]
  724.        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.21.jar:9.0.21]
  725.        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.21.jar:9.0.21]
  726.        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-embed-core-9.0.21.jar:9.0.21]
  727.        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-9.0.21.jar:9.0.21]
  728.        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) [tomcat-embed-core-9.0.21.jar:9.0.21]
  729.        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) [tomcat-embed-core-9.0.21.jar:9.0.21]
  730.        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.21.jar:9.0.21]
  731.        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_231]
  732.        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_231]
  733.        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.21.jar:9.0.21]
  734.        at java.lang.Thread.run(Unknown Source) [na:1.8.0_231]
  735.  
  736. 2019-11-20 19:37:55.781  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Recebida requisicao para autenticar usuario: 45598364859
  737. 2019-11-20 19:37:55.782  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Iniciando autentcacao do usuario por cpf: 45598364859
  738. 2019-11-20 19:37:55.833  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  739. 2019-11-20 19:37:55.835  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Encontrado usuario: CPF: 45598364859, Nome: walber martin
  740. 2019-11-20 19:37:55.836  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Tentando autenticar usuario: CPF: 45598364859, Nome: walber martin
  741. Scan your finger
  742. Matching finger: left pinky, FAR achieved: 0,00000.
  743. 2019-11-20 19:37:56.946  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Verificando se o usuario 45598364859 esta votando
  744. 2019-11-20 19:37:56.947  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Usuario 45598364859 nÒo esta votando
  745. 2019-11-20 19:37:57.025  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  746. 2019-11-20 19:37:57.026  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Verificando se o usuario 45598364859 ja votou
  747. 2019-11-20 19:37:57.032  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### O usuario 45598364859 ainda nao votou
  748. 2019-11-20 19:37:57.034  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Endereco da urna ativa devolvida: 1
  749. 2019-11-20 19:37:57.034  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Quantidade de urnas ativas: 1
  750. 2019-11-20 19:37:57.035  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Pesquisando urna por endereco: 1
  751. 2019-11-20 19:37:57.130  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  752. 2019-11-20 19:37:57.133  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Encontrado urna: Endereco da urna: 1, Estado da urna: INACTIVE
  753. 2019-11-20 19:37:57.135  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Estado da urna de endereco: 1 mudou de estado INACTIVE/BUSY
  754. 2019-11-20 19:37:57.136  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Urna removida das inativas: 1
  755. 2019-11-20 19:37:57.220  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  756. 2019-11-20 19:37:57.224  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Nova urna gravada: Endereco da urna: 1, Estado da urna: INACTIVE
  757. 2019-11-20 19:37:57.283  INFO 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  758. 2019-11-20 19:37:57.287 ERROR 14464 --- [io-8080-exec-10] c.b.sys_mesario.logger.Logger            : ###### Erro ao guardar sessao:  Id da sessao: com.blockchain_solutions.sys_mesario.domain.model.voting_session.VotingSessionId@233ffc6b, Usuario da sessao: 45598364859, Id Eleicao: 45598364859, Endereco da urna: 1, Comeco da sessao: 2019-11-20T19:37:57.225, Fim da sessao: 2019-11-20T19:42:57.225, Esta concluida: false-java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).
  759.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
  760.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  761.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  762.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  763.        at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1372)
  764.        at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1385)
  765.        at com.mysql.cj.jdbc.ClientPreparedStatement.setBoolean(ClientPreparedStatement.java:1467)
  766.        at com.blockchain_solutions.sys_mesario.application.repository.VotingSessionRepositoryImpl.store(VotingSessionRepositoryImpl.java:145)
  767.        at com.blockchain_solutions.sys_mesario.domain.service.UserVotingService.createSessionTo(UserVotingService.java:37)
  768.        at com.blockchain_solutions.sys_mesario.application.service.UserAutenticationService.autenticateByCpf(UserAutenticationService.java:76)
  769.        at com.blockchain_solutions.sys_mesario.presentation.facade.UserAutenticationFacade.autenticate(UserAutenticationFacade.java:31)
  770.        at com.blockchain_solutions.sys_mesario.presentation.api.ApplicationController.autenticate(ApplicationController.java:38)
  771.        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  772.        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  773.        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  774.        at java.lang.reflect.Method.invoke(Unknown Source)
  775.        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  776.        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  777.        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
  778.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892)
  779.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  780.        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  781.        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039)
  782.        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
  783.        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
  784.        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897)
  785.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
  786.        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
  787.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  788.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  789.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  790.        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  791.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  792.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  793.        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
  794.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  795.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  796.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  797.        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
  798.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  799.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  800.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  801.        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
  802.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  803.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  804.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  805.        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
  806.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  807.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  808.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  809.        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  810.        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  811.        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
  812.        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  813.        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  814.        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  815.        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  816.        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
  817.        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  818.        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
  819.        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
  820.        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  821.        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  822.        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  823.        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  824.        at java.lang.Thread.run(Unknown Source)
  825.  
  826.  
  827. java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).
  828.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  829.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  830.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  831.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  832.        at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1372) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  833.        at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1385) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  834.        at com.mysql.cj.jdbc.ClientPreparedStatement.setBoolean(ClientPreparedStatement.java:1467) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  835.        at com.blockchain_solutions.sys_mesario.application.repository.VotingSessionRepositoryImpl.store(VotingSessionRepositoryImpl.java:145) ~[sys_mesario-0.0.1.jar:0.0.1]
  836.        at com.blockchain_solutions.sys_mesario.domain.service.UserVotingService.createSessionTo(UserVotingService.java:37) [sys_mesario-0.0.1.jar:0.0.1]
  837.        at com.blockchain_solutions.sys_mesario.application.service.UserAutenticationService.autenticateByCpf(UserAutenticationService.java:76) [sys_mesario-0.0.1.jar:0.0.1]
  838.        at com.blockchain_solutions.sys_mesario.presentation.facade.UserAutenticationFacade.autenticate(UserAutenticationFacade.java:31) [sys_mesario-0.0.1.jar:0.0.1]
  839.        at com.blockchain_solutions.sys_mesario.presentation.api.ApplicationController.autenticate(ApplicationController.java:38) [sys_mesario-0.0.1.jar:0.0.1]
  840.        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_231]
  841.        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  842.        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  843.        at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_231]
  844.        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  845.        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  846.        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  847.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  848.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  849.        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  850.        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  851.        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  852.        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  853.        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  854.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) [tomcat-embed-core-9.0.21.jar:9.0.21]
  855.        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  856.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) [tomcat-embed-core-9.0.21.jar:9.0.21]
  857.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-embed-core-9.0.21.jar:9.0.21]
  858.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  859.        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.21.jar:9.0.21]
  860.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  861.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  862.        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  863.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  864.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  865.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  866.        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  867.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  868.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  869.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  870.        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  871.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  872.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  873.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  874.        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  875.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  876.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  877.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  878.        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-embed-core-9.0.21.jar:9.0.21]
  879.        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.21.jar:9.0.21]
  880.        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) [tomcat-embed-core-9.0.21.jar:9.0.21]
  881.        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.21.jar:9.0.21]
  882.        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.21.jar:9.0.21]
  883.        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.21.jar:9.0.21]
  884.        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.21.jar:9.0.21]
  885.        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-embed-core-9.0.21.jar:9.0.21]
  886.        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-9.0.21.jar:9.0.21]
  887.        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) [tomcat-embed-core-9.0.21.jar:9.0.21]
  888.        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) [tomcat-embed-core-9.0.21.jar:9.0.21]
  889.        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.21.jar:9.0.21]
  890.        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_231]
  891.        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_231]
  892.        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.21.jar:9.0.21]
  893.        at java.lang.Thread.run(Unknown Source) [na:1.8.0_231]
  894.  
  895. 2019-11-20 19:37:57.292 ERROR 14464 --- [io-8080-exec-10] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.lang.RuntimeException: java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).] with root cause
  896.  
  897. java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).
  898.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  899.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  900.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  901.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  902.        at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1372) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  903.        at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1385) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  904.        at com.mysql.cj.jdbc.ClientPreparedStatement.setBoolean(ClientPreparedStatement.java:1467) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  905.        at com.blockchain_solutions.sys_mesario.application.repository.VotingSessionRepositoryImpl.store(VotingSessionRepositoryImpl.java:145) ~[sys_mesario-0.0.1.jar:0.0.1]
  906.        at com.blockchain_solutions.sys_mesario.domain.service.UserVotingService.createSessionTo(UserVotingService.java:37) ~[sys_mesario-0.0.1.jar:0.0.1]
  907.        at com.blockchain_solutions.sys_mesario.application.service.UserAutenticationService.autenticateByCpf(UserAutenticationService.java:76) ~[sys_mesario-0.0.1.jar:0.0.1]
  908.        at com.blockchain_solutions.sys_mesario.presentation.facade.UserAutenticationFacade.autenticate(UserAutenticationFacade.java:31) ~[sys_mesario-0.0.1.jar:0.0.1]
  909.        at com.blockchain_solutions.sys_mesario.presentation.api.ApplicationController.autenticate(ApplicationController.java:38) ~[sys_mesario-0.0.1.jar:0.0.1]
  910.        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_231]
  911.        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  912.        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  913.        at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_231]
  914.        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  915.        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  916.        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  917.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  918.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  919.        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  920.        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  921.        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  922.        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  923.        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  924.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  925.        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  926.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  927.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  928.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  929.        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.21.jar:9.0.21]
  930.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  931.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  932.        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  933.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  934.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  935.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  936.        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  937.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  938.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  939.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  940.        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  941.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  942.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  943.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  944.        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  945.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  946.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  947.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  948.        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  949.        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.21.jar:9.0.21]
  950.        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) [tomcat-embed-core-9.0.21.jar:9.0.21]
  951.        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.21.jar:9.0.21]
  952.        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.21.jar:9.0.21]
  953.        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.21.jar:9.0.21]
  954.        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.21.jar:9.0.21]
  955.        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-embed-core-9.0.21.jar:9.0.21]
  956.        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-9.0.21.jar:9.0.21]
  957.        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) [tomcat-embed-core-9.0.21.jar:9.0.21]
  958.        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) [tomcat-embed-core-9.0.21.jar:9.0.21]
  959.        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.21.jar:9.0.21]
  960.        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_231]
  961.        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_231]
  962.        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.21.jar:9.0.21]
  963.        at java.lang.Thread.run(Unknown Source) [na:1.8.0_231]
  964.  
  965. 2019-11-20 19:38:40.328  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Recebida requisicao para autenticar usuario: 45598364859
  966. 2019-11-20 19:38:40.328  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Iniciando autentcacao do usuario por cpf: 45598364859
  967. 2019-11-20 19:38:40.376  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  968. 2019-11-20 19:38:40.378  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Encontrado usuario: CPF: 45598364859, Nome: walber martin
  969. 2019-11-20 19:38:40.379  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Tentando autenticar usuario: CPF: 45598364859, Nome: walber martin
  970. Scan your finger
  971. Matching finger: left pinky, FAR achieved: 0,00000.
  972. 2019-11-20 19:38:43.953  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Verificando se o usuario 45598364859 esta votando
  973. 2019-11-20 19:38:43.955  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Usuario 45598364859 nÒo esta votando
  974. 2019-11-20 19:38:44.026  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  975. 2019-11-20 19:38:44.027  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Verificando se o usuario 45598364859 ja votou
  976. 2019-11-20 19:38:44.030  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### O usuario 45598364859 ainda nao votou
  977. 2019-11-20 19:38:44.032  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Endereco da urna ativa devolvida: 1
  978. 2019-11-20 19:38:44.032  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Quantidade de urnas ativas: 1
  979. 2019-11-20 19:38:44.033  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Pesquisando urna por endereco: 1
  980. 2019-11-20 19:38:44.101  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  981. 2019-11-20 19:38:44.104  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Encontrado urna: Endereco da urna: 1, Estado da urna: INACTIVE
  982. 2019-11-20 19:38:44.105  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Estado da urna de endereco: 1 mudou de estado INACTIVE/BUSY
  983. 2019-11-20 19:38:44.107  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Urna removida das inativas: 1
  984. 2019-11-20 19:38:44.167  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  985. 2019-11-20 19:38:44.170  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Nova urna gravada: Endereco da urna: 1, Estado da urna: INACTIVE
  986. 2019-11-20 19:38:44.226  INFO 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Conexao criada com sucesso com a string de conexao: jdbc:mysql://192.168.1.8:3306/db_blockchain_solutions
  987. 2019-11-20 19:38:44.229 ERROR 14464 --- [nio-8080-exec-6] c.b.sys_mesario.logger.Logger            : ###### Erro ao guardar sessao:  Id da sessao: com.blockchain_solutions.sys_mesario.domain.model.voting_session.VotingSessionId@40aa0d29, Usuario da sessao: 45598364859, Id Eleicao: 45598364859, Endereco da urna: 1, Comeco da sessao: 2019-11-20T19:38:44.172, Fim da sessao: 2019-11-20T19:43:44.172, Esta concluida: false-java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).
  988.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
  989.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
  990.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
  991.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
  992.        at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1372)
  993.        at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1385)
  994.        at com.mysql.cj.jdbc.ClientPreparedStatement.setBoolean(ClientPreparedStatement.java:1467)
  995.        at com.blockchain_solutions.sys_mesario.application.repository.VotingSessionRepositoryImpl.store(VotingSessionRepositoryImpl.java:145)
  996.        at com.blockchain_solutions.sys_mesario.domain.service.UserVotingService.createSessionTo(UserVotingService.java:37)
  997.        at com.blockchain_solutions.sys_mesario.application.service.UserAutenticationService.autenticateByCpf(UserAutenticationService.java:76)
  998.        at com.blockchain_solutions.sys_mesario.presentation.facade.UserAutenticationFacade.autenticate(UserAutenticationFacade.java:31)
  999.        at com.blockchain_solutions.sys_mesario.presentation.api.ApplicationController.autenticate(ApplicationController.java:38)
  1000.        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  1001.        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  1002.        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  1003.        at java.lang.reflect.Method.invoke(Unknown Source)
  1004.        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
  1005.        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
  1006.        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
  1007.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892)
  1008.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
  1009.        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
  1010.        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039)
  1011.        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
  1012.        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
  1013.        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897)
  1014.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
  1015.        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
  1016.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
  1017.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
  1018.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  1019.        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
  1020.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  1021.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  1022.        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
  1023.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  1024.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  1025.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  1026.        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
  1027.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  1028.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  1029.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  1030.        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
  1031.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  1032.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  1033.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  1034.        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
  1035.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
  1036.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
  1037.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
  1038.        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
  1039.        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
  1040.        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
  1041.        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
  1042.        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
  1043.        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
  1044.        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
  1045.        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
  1046.        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
  1047.        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
  1048.        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
  1049.        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
  1050.        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  1051.        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  1052.        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  1053.        at java.lang.Thread.run(Unknown Source)
  1054.  
  1055.  
  1056. java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).
  1057.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  1058.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  1059.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  1060.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  1061.        at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1372) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  1062.        at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1385) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  1063.        at com.mysql.cj.jdbc.ClientPreparedStatement.setBoolean(ClientPreparedStatement.java:1467) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  1064.        at com.blockchain_solutions.sys_mesario.application.repository.VotingSessionRepositoryImpl.store(VotingSessionRepositoryImpl.java:145) ~[sys_mesario-0.0.1.jar:0.0.1]
  1065.        at com.blockchain_solutions.sys_mesario.domain.service.UserVotingService.createSessionTo(UserVotingService.java:37) [sys_mesario-0.0.1.jar:0.0.1]
  1066.        at com.blockchain_solutions.sys_mesario.application.service.UserAutenticationService.autenticateByCpf(UserAutenticationService.java:76) [sys_mesario-0.0.1.jar:0.0.1]
  1067.        at com.blockchain_solutions.sys_mesario.presentation.facade.UserAutenticationFacade.autenticate(UserAutenticationFacade.java:31) [sys_mesario-0.0.1.jar:0.0.1]
  1068.        at com.blockchain_solutions.sys_mesario.presentation.api.ApplicationController.autenticate(ApplicationController.java:38) [sys_mesario-0.0.1.jar:0.0.1]
  1069.        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_231]
  1070.        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  1071.        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  1072.        at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_231]
  1073.        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1074.        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1075.        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1076.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1077.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1078.        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1079.        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1080.        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1081.        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1082.        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1083.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1084.        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) [spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1085.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1086.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1087.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1088.        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.21.jar:9.0.21]
  1089.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1090.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1091.        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1092.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1093.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1094.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1095.        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1096.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1097.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1098.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1099.        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1100.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1101.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1102.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1103.        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1104.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) [spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1105.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1106.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1107.        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1108.        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1109.        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1110.        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1111.        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1112.        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1113.        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1114.        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1115.        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1116.        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1117.        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1118.        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1119.        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_231]
  1120.        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_231]
  1121.        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1122.        at java.lang.Thread.run(Unknown Source) [na:1.8.0_231]
  1123.  
  1124. 2019-11-20 19:38:44.232 ERROR 14464 --- [nio-8080-exec-6] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.lang.RuntimeException: java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).] with root cause
  1125.  
  1126. java.sql.SQLException: Parameter index out of range (8 > number of parameters, which is 7).
  1127.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  1128.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  1129.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  1130.        at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  1131.        at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1372) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  1132.        at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1385) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  1133.        at com.mysql.cj.jdbc.ClientPreparedStatement.setBoolean(ClientPreparedStatement.java:1467) ~[mysql-connector-java-8.0.18.jar:8.0.18]
  1134.        at com.blockchain_solutions.sys_mesario.application.repository.VotingSessionRepositoryImpl.store(VotingSessionRepositoryImpl.java:145) ~[sys_mesario-0.0.1.jar:0.0.1]
  1135.        at com.blockchain_solutions.sys_mesario.domain.service.UserVotingService.createSessionTo(UserVotingService.java:37) ~[sys_mesario-0.0.1.jar:0.0.1]
  1136.        at com.blockchain_solutions.sys_mesario.application.service.UserAutenticationService.autenticateByCpf(UserAutenticationService.java:76) ~[sys_mesario-0.0.1.jar:0.0.1]
  1137.        at com.blockchain_solutions.sys_mesario.presentation.facade.UserAutenticationFacade.autenticate(UserAutenticationFacade.java:31) ~[sys_mesario-0.0.1.jar:0.0.1]
  1138.        at com.blockchain_solutions.sys_mesario.presentation.api.ApplicationController.autenticate(ApplicationController.java:38) ~[sys_mesario-0.0.1.jar:0.0.1]
  1139.        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_231]
  1140.        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  1141.        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) ~[na:1.8.0_231]
  1142.        at java.lang.reflect.Method.invoke(Unknown Source) ~[na:1.8.0_231]
  1143.        at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1144.        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1145.        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1146.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1147.        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1148.        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1149.        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1150.        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1151.        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1152.        at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:897) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1153.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  1154.        at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882) ~[spring-webmvc-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1155.        at javax.servlet.http.HttpServlet.service(HttpServlet.java:741) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  1156.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  1157.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  1158.        at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.21.jar:9.0.21]
  1159.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  1160.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  1161.        at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1162.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1163.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  1164.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  1165.        at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1166.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1167.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  1168.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  1169.        at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1170.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1171.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  1172.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  1173.        at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1174.        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109) ~[spring-web-5.1.8.RELEASE.jar:5.1.8.RELEASE]
  1175.        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  1176.        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  1177.        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.21.jar:9.0.21]
  1178.        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1179.        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1180.        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1181.        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1182.        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1183.        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1184.        at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1185.        at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1186.        at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1187.        at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1188.        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1189.        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [na:1.8.0_231]
  1190.        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [na:1.8.0_231]
  1191.        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.21.jar:9.0.21]
  1192.        at java.lang.Thread.run(Unknown Source) [na:1.8.0_231]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!