JBWEB000309: type JBWEB000066: Exception report
JBWEB000068: message java.lang.RuntimeException: java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string
JBWEB000069: description JBWEB000145: The server encountered an internal error that prevented it from fulfilling this request.
JBWEB000070: exception
org.apache.jasper.JasperException: java.lang.RuntimeException: java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:409) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:246) javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
JBWEB000071: root cause
java.lang.RuntimeException: java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string br.gov.in.pesquisa.dao.ConsultaDAO.consultarPaginas(ConsultaDAO.java:538) br.gov.in.pesquisa.PDFReader.PDFViewerFramework.consultarPaginas(PDFViewerFramework.java:63) org.apache.jsp.jsp.visualiza.index_jsp._jspService(index_jsp.java:150) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:69) javax.servlet.http.HttpServlet.service(HttpServlet.java:847) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:365) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:246) javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
JBWEB000071: root cause
java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553) oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270) oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91) oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807) oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713) oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167) org.jboss.jca.adapters.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:106) org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) core.connection.JDBC.TrataSql.queryResultSet(TrataSql.java:54) br.gov.in.pesquisa.dao.ConsultaDAO.consultarPaginas(ConsultaDAO.java:534) br.gov.in.pesquisa.PDFReader.PDFViewerFramework.consultarPaginas(PDFViewerFramework.java:63) org.apache.jsp.jsp.visualiza.index_jsp._jspService(index_jsp.java:150) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:69) javax.servlet.http.HttpServlet.service(HttpServlet.java:847) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:365) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:246) javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
JBWEB000071: root cause
Error : 1830, Position : 185, Sql = select count(codigo) as valor from SGPUB.tb_pagina_edicao where codigo_edicao = (select codigo from SGPUB.tb_edicao where codigo_tipo_periodico = 1 and trunc(data_publicacao) = to_date('09/10/20150','dd/mm/yyyy')), OriginalSql = select count(codigo) as valor from SGPUB.tb_pagina_edicao where codigo_edicao = (select codigo from SGPUB.tb_edicao where codigo_tipo_periodico = 1 and trunc(data_publicacao) = to_date('09/10/20150','dd/mm/yyyy')), Error Msg = ORA-01830: date format picture ends before converting entire input string oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513) oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:553) oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655) oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270) oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91) oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807) oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983) oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168) oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666) oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426) oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713) oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167) org.jboss.jca.adapters.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:106) org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) core.connection.JDBC.TrataSql.queryResultSet(TrataSql.java:54) br.gov.in.pesquisa.dao.ConsultaDAO.consultarPaginas(ConsultaDAO.java:534) br.gov.in.pesquisa.PDFReader.PDFViewerFramework.consultarPaginas(PDFViewerFramework.java:63) org.apache.jsp.jsp.visualiza.index_jsp._jspService(index_jsp.java:150) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:69) javax.servlet.http.HttpServlet.service(HttpServlet.java:847) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:365) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:246) javax.servlet.http.HttpServlet.service(HttpServlet.java:847)