Exception stack
java.sql.SQLException: ERROR: function web.pub_keltsky_tyden() does not exist at character 8
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:126)
at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:451)
at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:281)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at paulb.catwalk3.server.postgresql.PostgreSQLSession.call(PostgreSQLSession.java:138)
at paulb.catwalk3.server.BrowserServlet.processRequest(BrowserServlet.java:41)
at paulb.catwalk3.server.GenericServlet.internalProcessRequest(GenericServlet.java:86)
at paulb.catwalk3.server.GenericServlet.doGet(GenericServlet.java:54)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:172)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:879)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
at java.base/java.lang.Thread.run(Thread.java:840)
Debug log
Creating new session: paulb.catwalk3.server.postgresql.PostgreSQLSession
Procedure name: web.pub_doc
Content type: text/html; charset=UTF-8
Opening session: username=svmk database=svmk_postgres_1/svmk
Parameters:
path_info = wikiimg
image_name = _MG_0756.JPG
describeProcSql: SELECT NAME, TYPE FROM CW.DESCRIBE_PROC('WEB.PUB_DOC') ORDER BY POSITION
initDocSql: SELECT CW.INIT_CALL()
callSql: SELECT WEB.PUB_DOC(?, ?, ?, ?, ?)
Comparing params: 0:id, 0:path_info
Comparing params: 0:id, 1:image_name
Comparing params: 1:path_info, 0:path_info
OK, match
Comparing params: 2:image_name, 0:path_info
Comparing params: 2:image_name, 1:image_name
OK, match
Comparing params: 3:print, 0:path_info
Comparing params: 3:print, 1:image_name
Comparing params: 4:check_frame, 0:path_info
Comparing params: 4:check_frame, 1:image_name
initSessionSql: SELECT CW.INIT_SESSION()
getHdrsSql: SELECT CW.GET_VAR('CW.CONTENT_TYPE') AS CONTENT_TYPE, CW.GET_VAR('CW.SEND_REDIRECT') AS SEND_REDIRECT, CW.GET_VAR('CW.CLOSE') AS CLOSE
Content type: image/jpeg; charset=UTF-8
getCharDataSql: SELECT DATA FROM CHARACTER_DATA ORDER BY OID
getBinDataSql: SELECT ENCODE(DATA, 'hex') AS HEX FROM BINARY_DATA
Procedure name: web.pub_keltsky_tyden
Parameters:
describeProcSql: SELECT NAME, TYPE FROM CW.DESCRIBE_PROC('WEB.PUB_KELTSKY_TYDEN') ORDER BY POSITION
initDocSql: SELECT CW.INIT_CALL()
callSql: SELECT WEB.PUB_KELTSKY_TYDEN()