API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 24th, 2018
84
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 13.04 KB | None | 0 0
raw download clone embed print report
  1. ERROR - SqlExceptionHelper.logExceptions(146) |2018-04-24 11:52:18,578| You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition condition0_ cross join patient patient1_ inner join person patient1_1_' at line 1
  2. ERROR - BaseRestController.handleException(115) |2018-04-24 11:52:18,604| could not extract ResultSet
  3. org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  4.     at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:80)
  5.     at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
  6.     at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
  7.     at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:112)
  8.     at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:91)
  9.     at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)
  10.     at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
  11.     at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
  12.     at org.hibernate.loader.Loader.doQuery(Loader.java:910)
  13.     at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
  14.     at org.hibernate.loader.Loader.doList(Loader.java:2554)
  15.     at org.hibernate.loader.Loader.doList(Loader.java:2540)
  16.     at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
  17.     at org.hibernate.loader.Loader.list(Loader.java:2365)
  18.     at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)
  19.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
  20.     at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)
  21.     at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)
  22.     at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
  23.     at org.openmrs.api.db.hibernate.HibernateConditionDAO.getActiveConditions(HibernateConditionDAO.java:108)
  24.     at org.openmrs.api.impl.ConditionServiceImpl.getActiveConditions(ConditionServiceImpl.java:90)
  25.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  26.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  27.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  28.     at java.lang.reflect.Method.invoke(Method.java:498)
  29.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  30.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  31.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  32.     at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
  33.     at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
  34.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
  35.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  36.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  37.     at com.sun.proxy.$Proxy217.getActiveConditions(Unknown Source)
  38.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  39.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  40.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  41.     at java.lang.reflect.Method.invoke(Method.java:498)
  42.     at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
  43.     at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
  44.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
  45.     at org.springframework.cache.interceptor.CacheInterceptor$1.invoke(CacheInterceptor.java:52)
  46.     at org.springframework.cache.interceptor.CacheAspectSupport.execute(CacheAspectSupport.java:303)
  47.     at org.springframework.cache.interceptor.CacheInterceptor.invoke(CacheInterceptor.java:61)
  48.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  49.     at org.openmrs.aop.LoggingAdvice.invoke(LoggingAdvice.java:122)
  50.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  51.     at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  52.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  53.     at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:52)
  54.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
  55.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
  56.     at com.sun.proxy.$Proxy218.getActiveConditions(Unknown Source)
  57.     at org.openmrs.module.emrapi.web.controller.ConditionController.getConditionHistory(ConditionController.java:57)
  58.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  59.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  60.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  61.     at java.lang.reflect.Method.invoke(Method.java:498)
  62.     at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:177)
  63.     at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:446)
  64.     at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:434)
  65.     at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:943)
  66.     at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:877)
  67.     at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:966)
  68.     at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:857)
  69.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
  70.     at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:842)
  71.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
  72.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  73.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  74.     at org.openmrs.module.web.filter.ForcePasswordChangeFilter.doFilter(ForcePasswordChangeFilter.java:60)
  75.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  76.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  77.     at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:73)
  78.     at org.openmrs.web.filter.GZIPFilter.doFilterInternal(GZIPFilter.java:65)
  79.     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  80.     at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  81.     at org.openmrs.module.webservices.rest.web.filter.AuthorizationFilter.doFilter(AuthorizationFilter.java:104)
  82.     at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  83.     at org.springframework.web.filter.ShallowEtagHeaderFilter.doFilterInternal(ShallowEtagHeaderFilter.java:82)
  84.     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  85.     at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  86.     at org.openmrs.module.owa.filter.OwaFilter.doFilter(OwaFilter.java:57)
  87.     at org.openmrs.module.web.filter.ModuleFilterChain.doFilter(ModuleFilterChain.java:71)
  88.     at org.openmrs.module.web.filter.ModuleFilter.doFilter(ModuleFilter.java:57)
  89.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  90.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  91.     at org.openmrs.web.filter.OpenmrsFilter.doFilterInternal(OpenmrsFilter.java:109)
  92.     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  93.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  94.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  95.     at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:150)
  96.     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  97.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  98.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  99.     at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  100.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  101.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  102.     at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  103.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  104.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  105.     at org.openmrs.web.filter.StartupFilter.doFilter(StartupFilter.java:107)
  106.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  107.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  108.     at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
  109.     at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  110.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  111.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  112.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
  113.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
  114.     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
  115.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
  116.     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  117.     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  118.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
  119.     at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
  120.     at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
  121.     at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
  122.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  123.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  124.     at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  125.     at java.lang.Thread.run(Thread.java:748)
  126. Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition condition0_ cross join patient patient1_ inner join person patient1_1_' at line 1
  127.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  128.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  129.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  130.     at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  131.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  132.     at com.mysql.jdbc.Util.getInstance(Util.java:408)
  133.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
  134.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
  135.     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
  136.     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
  137.     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
  138.     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
  139.     at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
  140.     at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
  141.     at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
  142.     at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
  143.     ... 117 more
  144. INFO - LoggingAdvice.invoke(116) |2018-04-24 11:52:25,446| In method UserService.saveUser. Arguments: User=admin,
  145. INFO - LoggingAdvice.invoke(156) |2018-04-24 11:52:25,451| Exiting method saveUser
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!