API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Feb 20th, 2020
168
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.14 KB | None | 0 0
raw download clone embed print report
  1. net.n2oapp.framework.engine.exception.N2oSqlException: ERROR: function lower(integer) does not exist
  2. Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  3. Position: 5019
  4. at net.n2oapp.framework.engine.data.query.SqlQueryEngine.init(SqlQueryEngine.java:50)
  5. at net.n2oapp.framework.api.data.ComputationalQueryEngine.executeQuery(ComputationalQueryEngine.java:22)
  6. at net.n2oapp.framework.engine.processor.QueryProcessor.doQuery(QueryProcessor.java:126)
  7. at net.n2oapp.framework.engine.processor.QueryProcessor.executeQuery(QueryProcessor.java:67)
  8. at net.n2oapp.framework.engine.processor.QueryProcessor.execute(QueryProcessor.java:43)
  9. at net.n2oapp.framework.ui.controller.query.GetController.executeQuery(GetController.java:39)
  10. at net.n2oapp.framework.ui.controller.query.QueryController.execute(QueryController.java:46)
  11. at net.n2oapp.framework.ui.controller.DataController.getData(DataController.java:59)
  12. at net.n2oapp.framework.ui.servlet.data.DataServlet$1.resolveSuccessModel(DataServlet.java:32)
  13. at net.n2oapp.framework.mvc.callback.json.JsonServletCallback.onService(JsonServletCallback.java:25)
  14. at net.n2oapp.framework.mvc.api.SimpleServletTemplate.doService(SimpleServletTemplate.java:28)
  15. at net.n2oapp.framework.ui.servlet.data.DataServlet.safeDoGet(DataServlet.java:28)
  16. at net.n2oapp.framework.mvc.n2o.N2oServlet.doGet(N2oServlet.java:81)
  17. at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
  18. at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
  19. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  20. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  21. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  22. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  23. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  24. at net.n2oapp.security.auth.filter.WorkplaceFilter.doFilter(WorkplaceFilter.java:53)
  25. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  26. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  27. at net.n2oapp.framework.ui.servlet.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:28)
  28. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  29. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  30. at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:110)
  31. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  32. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  33. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)
  34. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
  35. at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
  36. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  37. at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115)
  38. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  39. at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
  40. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  41. at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:169)
  42. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  43. at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
  44. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  45. at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilterInternal(BasicAuthenticationFilter.java:158)
  46. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  47. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  48. at org.springframework.security.web.authentication.ui.DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilter.java:177)
  49. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  50. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:206)
  51. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  52. at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:206)
  53. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  54. at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:121)
  55. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  56. at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:66)
  57. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  58. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  59. at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
  60. at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
  61. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  62. at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:106)
  63. at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)
  64. at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)
  65. at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)
  66. at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
  67. at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)
  68. at net.n2oapp.security.auth.filter.SecurityFilter.doFilter(SecurityFilter.java:43)
  69. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  70. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  71. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
  72. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
  73. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
  74. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
  75. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
  76. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
  77. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  78. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)
  79. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
  80. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
  81. at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
  82. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  83. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  84. at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
  85. at java.lang.Thread.run(Thread.java:745)
  86. Caused by: net.n2oapp.criteria.sql.query.CriteriaSqlException: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [
  87. select t.id, t.uid, t.create_date, t.patient_id, concat_ws(' ', initcap(ind.surname), initcap(ind.name), initcap(ind.patr_name)), ind.gender_id, (SELECT gen.name FROM public.pim_gender gen WHERE gen.id = ind.gender_id), ind.birth_dt,
  88. (select social_group_id from pci_patient pat
  89. where pat.id = ind.id limit 1)
  90. ,
  91. (SELECT sg.name FROM public.md_soc_group sg
  92. JOIN pci_patient pat on pat.social_group_id = sg.id
  93. WHERE pat.id = ind.id
  94. limit 1), (select concat_ws(' ', passport.series, passport.number) from pim_individual_doc passport where passport.indiv_id = ind.id and passport.type_id =
  95. (select dtype.id from pim_doc_type dtype where dtype.code = 'PASSPORT_RUSSIAN_FEDERATION' limit 1) limit 1), (select passport.issue_dt from pim_individual_doc passport where passport.indiv_id = ind.id and passport.type_id =
  96. (select dtype.id from pim_doc_type dtype where dtype.code = 'PASSPORT_RUSSIAN_FEDERATION' limit 1) limit 1),
  97. (select concat_ws(' ', polic.series, polic.number)
  98. from pim_individual_doc polic
  99. where polic.indiv_id = ind.id and polic.type_id in
  100. (select dtype.id from pim_doc_type dtype where dtype.code in ('MHI_UNIFORM', 'MHI_OLDER'))
  101. order by polic.type_id desc
  102. limit 1)
  103. ,
  104. (select polic.issue_dt
  105. from pim_individual_doc polic
  106. where polic.indiv_id = ind.id and polic.type_id in
  107. (select dtype.id from pim_doc_type dtype where dtype.code in ('MHI_UNIFORM', 'MHI_OLDER'))
  108. order by polic.type_id desc
  109. limit 1)
  110. ,
  111. (SELECT epos.id FROM public.mc_step step
  112. JOIN public.sr_res_group res ON res.id = step.res_group_id
  113. JOIN public.pim_employee_position epos ON epos.id = res.responsible_id
  114. JOIN public.pim_employee empl ON empl.id = epos.employee_id
  115. JOIN public.pim_individual ind ON ind.id = empl.individual_id
  116. WHERE step.case_id = t.id
  117. ORDER BY step.admission_date
  118. LIMIT 1)
  119. ,
  120. (SELECT concat_ws(' ', initcap(ind.surname), initcap(ind.name), initcap(ind.patr_name)) FROM public.mc_step step
  121. JOIN public.sr_res_group res ON res.id = step.res_group_id
  122. JOIN public.pim_employee_position epos ON epos.id = res.responsible_id
  123. JOIN public.pim_employee empl ON empl.id = epos.employee_id
  124. JOIN public.pim_individual ind ON ind.id = empl.individual_id
  125. WHERE step.case_id = t.id
  126. ORDER BY step.admission_date
  127. LIMIT 1)
  128. , t.admission_reason_id, t.admission_state_id, t.admission_type_id, t.care_level_id, t.care_regimen_id, t.case_type_id, t.repeat_count_id, t.clinic_id, t.funding_id, (SELECT fund.name FROM public.fin_funding_source_type fund WHERE fund.id = t.funding_id), t.init_goal_id, t.init_type_id, (select get_diagnosis_init(diag.diagnos_id, (select array_agg(attr_value_id) from mc_diag_attr where diagnosis_id = t.main_diagnos_id))),
  129. (SELECT mc_d.stage_id FROM public.mc_diagnosis mc_d
  130. WHERE mc_d.id = t.main_diagnos_id)
  131. , t.main_diagnos_id, (select mcd.diagnos_id from public.mc_diagnosis mcd where mcd.id=t.main_diagnos_id),
  132. (select get_diagnosis_full_name(t.main_diagnos_id))
  133. ,
  134. (SELECT ref.diagnosis_id FROM md_referral ref
  135. JOIN public.mc_step step ON step.id = ref.step_id
  136. WHERE step.case_id = t.id
  137. ORDER BY step.admission_date
  138. LIMIT 1)
  139. , t.referral_id, t.referral_resulting_id, t.open_date, t.closing_step_id, t.closing_step_id, (SELECT step.outcome_date FROM mc_step step WHERE step.id = t.closing_step_id LIMIT 1),
  140. (SELECT
  141. CASE
  142. WHEN count(*) = 0 THEN 'не подлежит учету'
  143. WHEN count(*) > 0 THEN 'подлежит учету'
  144. END
  145. FROM d_accounting.account_case acc
  146. WHERE acc.case_id = t.id
  147. LIMIT 1)
  148. , (select exists(select 1 from mc_step where case_id = t.id)), (select count(*) from fin_bill_spec_item fi
  149. join md_srv_rendered srv on fi.service_id=srv.id
  150. where srv.case_id = t.id), t.clinic_id, diag.clinical_form_id, diag.complication_id, diag.localization_id
  151. from public.mc_case t
  152. join public.mc_case_type ct on ct.id=t.case_type_id and ct.case_mode_id = 1 and ct.e_code not in ('7','8')
  153. join public.pim_individual ind ON ind.id = t.patient_id
  154. left join public.mc_diagnosis diag on diag.id = t.main_diagnos_id
  155. where trim(lower(t.uid)) like '%'||trim(lower(?))||'%'
  156. order by 1
  157. limit 11]; nested exception is org.postgresql.util.PSQLException: ERROR: function lower(integer) does not exist
  158. Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  159. Position: 5019
  160. at net.n2oapp.criteria.sql.query.SqlPageDao.getList(SqlPageDao.java:48)
  161. at net.n2oapp.criteria.api.query.QueryPage.getCollectionInitial(QueryPage.java:42)
  162. at net.n2oapp.framework.engine.data.query.page.TransactionalQueryPage.getCollectionInitial(TransactionalQueryPage.java:48)
  163. at net.n2oapp.criteria.api.ComputationalCollectionPage.getCollection(ComputationalCollectionPage.java:37)
  164. at net.n2oapp.criteria.api.ComputationalCollectionPage.init(ComputationalCollectionPage.java:61)
  165. at net.n2oapp.framework.engine.data.query.page.TransactionalQueryPage.access$1(TransactionalQueryPage.java:1)
  166. at net.n2oapp.framework.engine.data.query.page.TransactionalQueryPage$1.doInTransactionWithoutResult(TransactionalQueryPage.java:33)
  167. at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:34)
  168. at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
  169. at net.n2oapp.routing.datasource.JndiRoutingDataSourceTemplate.lambda$execute$0(JndiRoutingDataSourceTemplate.java:26)
  170. at net.n2oapp.routing.datasource.JndiRoutingDataSourceTemplate.execute(JndiRoutingDataSourceTemplate.java:17)
  171. at net.n2oapp.routing.datasource.JndiRoutingDataSourceTemplate.execute(JndiRoutingDataSourceTemplate.java:25)
  172. at net.n2oapp.framework.engine.data.query.page.TransactionalQueryPage.init(TransactionalQueryPage.java:30)
  173. at net.n2oapp.framework.api.data.ComputationalQueryEngine.init(ComputationalQueryEngine.java:31)
  174. at net.n2oapp.framework.engine.data.query.SqlQueryEngine.init(SqlQueryEngine.java:48)
  175. ... 81 more
  176. Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [
  177. select t.id, t.uid, t.create_date, t.patient_id, concat_ws(' ', initcap(ind.surname), initcap(ind.name), initcap(ind.patr_name)), ind.gender_id, (SELECT gen.name FROM public.pim_gender gen WHERE gen.id = ind.gender_id), ind.birth_dt,
  178. (select social_group_id from pci_patient pat
  179. where pat.id = ind.id limit 1)
  180. ,
  181. (SELECT sg.name FROM public.md_soc_group sg
  182. JOIN pci_patient pat on pat.social_group_id = sg.id
  183. WHERE pat.id = ind.id
  184. limit 1), (select concat_ws(' ', passport.series, passport.number) from pim_individual_doc passport where passport.indiv_id = ind.id and passport.type_id =
  185. (select dtype.id from pim_doc_type dtype where dtype.code = 'PASSPORT_RUSSIAN_FEDERATION' limit 1) limit 1), (select passport.issue_dt from pim_individual_doc passport where passport.indiv_id = ind.id and passport.type_id =
  186. (select dtype.id from pim_doc_type dtype where dtype.code = 'PASSPORT_RUSSIAN_FEDERATION' limit 1) limit 1),
  187. (select concat_ws(' ', polic.series, polic.number)
  188. from pim_individual_doc polic
  189. where polic.indiv_id = ind.id and polic.type_id in
  190. (select dtype.id from pim_doc_type dtype where dtype.code in ('MHI_UNIFORM', 'MHI_OLDER'))
  191. order by polic.type_id desc
  192. limit 1)
  193. ,
  194. (select polic.issue_dt
  195. from pim_individual_doc polic
  196. where polic.indiv_id = ind.id and polic.type_id in
  197. (select dtype.id from pim_doc_type dtype where dtype.code in ('MHI_UNIFORM', 'MHI_OLDER'))
  198. order by polic.type_id desc
  199. limit 1)
  200. ,
  201. (SELECT epos.id FROM public.mc_step step
  202. JOIN public.sr_res_group res ON res.id = step.res_group_id
  203. JOIN public.pim_employee_position epos ON epos.id = res.responsible_id
  204. JOIN public.pim_employee empl ON empl.id = epos.employee_id
  205. JOIN public.pim_individual ind ON ind.id = empl.individual_id
  206. WHERE step.case_id = t.id
  207. ORDER BY step.admission_date
  208. LIMIT 1)
  209. ,
  210. (SELECT concat_ws(' ', initcap(ind.surname), initcap(ind.name), initcap(ind.patr_name)) FROM public.mc_step step
  211. JOIN public.sr_res_group res ON res.id = step.res_group_id
  212. JOIN public.pim_employee_position epos ON epos.id = res.responsible_id
  213. JOIN public.pim_employee empl ON empl.id = epos.employee_id
  214. JOIN public.pim_individual ind ON ind.id = empl.individual_id
  215. WHERE step.case_id = t.id
  216. ORDER BY step.admission_date
  217. LIMIT 1)
  218. , t.admission_reason_id, t.admission_state_id, t.admission_type_id, t.care_level_id, t.care_regimen_id, t.case_type_id, t.repeat_count_id, t.clinic_id, t.funding_id, (SELECT fund.name FROM public.fin_funding_source_type fund WHERE fund.id = t.funding_id), t.init_goal_id, t.init_type_id, (select get_diagnosis_init(diag.diagnos_id, (select array_agg(attr_value_id) from mc_diag_attr where diagnosis_id = t.main_diagnos_id))),
  219. (SELECT mc_d.stage_id FROM public.mc_diagnosis mc_d
  220. WHERE mc_d.id = t.main_diagnos_id)
  221. , t.main_diagnos_id, (select mcd.diagnos_id from public.mc_diagnosis mcd where mcd.id=t.main_diagnos_id),
  222. (select get_diagnosis_full_name(t.main_diagnos_id))
  223. ,
  224. (SELECT ref.diagnosis_id FROM md_referral ref
  225. JOIN public.mc_step step ON step.id = ref.step_id
  226. WHERE step.case_id = t.id
  227. ORDER BY step.admission_date
  228. LIMIT 1)
  229. , t.referral_id, t.referral_resulting_id, t.open_date, t.closing_step_id, t.closing_step_id, (SELECT step.outcome_date FROM mc_step step WHERE step.id = t.closing_step_id LIMIT 1),
  230. (SELECT
  231. CASE
  232. WHEN count(*) = 0 THEN 'не подлежит учету'
  233. WHEN count(*) > 0 THEN 'подлежит учету'
  234. END
  235. FROM d_accounting.account_case acc
  236. WHERE acc.case_id = t.id
  237. LIMIT 1)
  238. , (select exists(select 1 from mc_step where case_id = t.id)), (select count(*) from fin_bill_spec_item fi
  239. join md_srv_rendered srv on fi.service_id=srv.id
  240. where srv.case_id = t.id), t.clinic_id, diag.clinical_form_id, diag.complication_id, diag.localization_id
  241. from public.mc_case t
  242. join public.mc_case_type ct on ct.id=t.case_type_id and ct.case_mode_id = 1 and ct.e_code not in ('7','8')
  243. join public.pim_individual ind ON ind.id = t.patient_id
  244. left join public.mc_diagnosis diag on diag.id = t.main_diagnos_id
  245. where trim(lower(t.uid)) like '%'||trim(lower(?))||'%'
  246. order by 1
  247. limit 11]; nested exception is org.postgresql.util.PSQLException: ERROR: function lower(integer) does not exist
  248. Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  249. Position: 5019
  250. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:99)
  251. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73)
  252. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  253. at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
  254. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:645)
  255. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:680)
  256. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:707)
  257. at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:757)
  258. at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:192)
  259. at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:199)
  260. at net.n2oapp.criteria.sql.query.SqlPageDao.getList(SqlPageDao.java:46)
  261. ... 95 more
  262. Caused by: org.postgresql.util.PSQLException: ERROR: function lower(integer) does not exist
  263. Hint: No function matches the given name and argument types. You might need to add explicit type casts.
  264. Position: 5019
  265. at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)
  266. at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)
  267. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
  268. at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:561)
  269. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:419)
  270. at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:304)
  271. at sun.reflect.GeneratedMethodAccessor28.invoke(Unknown Source)
  272. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  273. at java.lang.reflect.Method.invoke(Method.java:497)
  274. at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:138)
  275. at com.sun.proxy.$Proxy32.executeQuery(Unknown Source)
  276. at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:688)
  277. at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629)
  278. ... 101 more
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!