HTTP Status 500 - javax.servlet.ServletException: javax.servlet.jsp.JspException: javax.servlet.ServletException: javax.servlet.jsp.JspException:


type Exception report

message javax.servlet.ServletException: javax.servlet.jsp.JspException: javax.servlet.ServletException: javax.servlet.jsp.JspException:

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: javax.servlet.ServletException: javax.servlet.jsp.JspException: 
  select ' ' flat,
       Initcap(CASE WHEN ? IN ('en', 'eng') then rtrim(b.eng_name) else rtrim(b.chi_name) end) floor,
       u.unit_id,
       nvl(u.gross_area, 0) as gross_area,  round(nvl(u.display_net_area, 0), 0) net_area,
       case when color = '#E7FEFD' then '#EBF4F8' when color = '#F7EEFF' then '#fff6e8' when color = '#EBCDFA' then '#e7f8d1' else color end as color,
       nvl(no_of_tx, 0) no_of_tx,
       rtrim(ps.chi_name) prop_style, latest_Tx,case when not consideration is null then CASE when ? = 10000 then round(consideration / 10000,0) else round(consideration / 1000000,2) end else null end
	   as consideration, 
	   case when not consideration2 is null then CASE when ? = 10000 then round(consideration2 / 10000,0) else round(consideration2 / 1000000,2) end else null end
	   as consideration2,  CASE WHEN ? IN ('en', 'eng') then TO_CHAR(delivery_date, 'YYYY') else TO_CHAR(delivery_date, 'YY') end as instrument_date,
	   case when consideration2 =0 then 0 else round( consideration *100 / consideration2  -100,2) end as perc, nvl(to_char(mkt_type),'2') mkt_type
	   , transaction_type
  from unit u, building b, prop_style ps,
       tmp_unit_color,
	   (select (select ps.consideration from pis.mdb_pis_unit_tx_mapping ps where  p.delivery_date = ps.delivery_date
          and p.unit_id = ps.pis_unit_id and rownum = 1) as consideration, p.*,
        ( select distinct p3.consideration from pis.mdb_pis_unit_tx_mapping p3 where rownum =1 and p3.pis_unit_id = p.unit_id and p3.delivery_date =
               (select max(delivery_date) from pis.mdb_pis_unit_tx_mapping p2 where p2.pis_unit_id = p.unit_id and p2.delivery_date < p.delivery_date)
        ) as  consideration2 from  (
			select p.*, case when b.transaction_type is not null then transaction_type else null end transaction_type from (
				 select pis_unit_id unit_id, count(0) no_of_tx,
				  case when trunc(sysdate) - trunc(MAX(delivery_date)) < 30 then 1 
				   when trunc(sysdate) - trunc(MAX(delivery_date)) < 90 then 2 
				   when trunc(sysdate) - trunc(MAX(delivery_date)) < 365 then 3
				   else 4 end as latest_Tx,
				   trunc(MAX(delivery_date)) AS delivery_date, MAX(nvl(to_char(mkt_type),'2')) mkt_type
				 from mdb_pis_unit_tx_mapping su, building sb
				 where su.pis_bldg_id = sb.bldg_id
					
					   and sb.est_id = rpad(?, 10, ' ')
					
					
					
					   and sb.street_id = rpad(?, 10, ' ')
					
				   and (sb.deleted is null or sb.deleted = 'N')
				   and (su.deleted is null or su.deleted = 'N')
				   and pis_unit_id is not null
				   and consideration > 0
				   and exists (select 1 from mltest.pt_inst_type where inst_type in ('ASP', 'SSP') and inst_id = instrument_id)
				 group by pis_unit_id
			) p
			left join pis.mdb_pis_unit_tx_mapping b on b.pis_unit_id = p.unit_id and b.delivery_date = p.delivery_date and b.deleted = 'N'
		 ) p
		) tx
 where u.bldg_id = b.bldg_id
   and b.prop_style_id = ps.style_id(+)
   and b.bldg_type = 'HOUSE'

   and b.est_id = rpad(?, 10, ' ')



   and b.street_id = rpad(?, 10, ' ')

   and (b.deleted is null or b.deleted = 'N')
   and rtrim(b.chi_name) is not null
   and nvl(u.room, 0) = tmp_unit_color.room
   and u.unit_id = tx.unit_id(+)
   and trim(u.unit_type) != 'NON-DOME'
 order by replace(translate(b.chi_name, '0123456789', ' '),' ',''), replace(translate(b.chi_name, translate(b.chi_name, '0123456789', 'k'), ' '),' ','') + 1
 
 
 
 

 



 


 



 

: Closed Statement: getMetaData
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:561)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:462)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.midland.commons.filters.CORSFilter.doFilter(CORSFilter.java:32)
	org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)
	filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)

root cause

javax.servlet.ServletException: javax.servlet.jsp.JspException: javax.servlet.ServletException: javax.servlet.jsp.JspException: 
  select ' ' flat,
       Initcap(CASE WHEN ? IN ('en', 'eng') then rtrim(b.eng_name) else rtrim(b.chi_name) end) floor,
       u.unit_id,
       nvl(u.gross_area, 0) as gross_area,  round(nvl(u.display_net_area, 0), 0) net_area,
       case when color = '#E7FEFD' then '#EBF4F8' when color = '#F7EEFF' then '#fff6e8' when color = '#EBCDFA' then '#e7f8d1' else color end as color,
       nvl(no_of_tx, 0) no_of_tx,
       rtrim(ps.chi_name) prop_style, latest_Tx,case when not consideration is null then CASE when ? = 10000 then round(consideration / 10000,0) else round(consideration / 1000000,2) end else null end
	   as consideration, 
	   case when not consideration2 is null then CASE when ? = 10000 then round(consideration2 / 10000,0) else round(consideration2 / 1000000,2) end else null end
	   as consideration2,  CASE WHEN ? IN ('en', 'eng') then TO_CHAR(delivery_date, 'YYYY') else TO_CHAR(delivery_date, 'YY') end as instrument_date,
	   case when consideration2 =0 then 0 else round( consideration *100 / consideration2  -100,2) end as perc, nvl(to_char(mkt_type),'2') mkt_type
	   , transaction_type
  from unit u, building b, prop_style ps,
       tmp_unit_color,
	   (select (select ps.consideration from pis.mdb_pis_unit_tx_mapping ps where  p.delivery_date = ps.delivery_date
          and p.unit_id = ps.pis_unit_id and rownum = 1) as consideration, p.*,
        ( select distinct p3.consideration from pis.mdb_pis_unit_tx_mapping p3 where rownum =1 and p3.pis_unit_id = p.unit_id and p3.delivery_date =
               (select max(delivery_date) from pis.mdb_pis_unit_tx_mapping p2 where p2.pis_unit_id = p.unit_id and p2.delivery_date < p.delivery_date)
        ) as  consideration2 from  (
			select p.*, case when b.transaction_type is not null then transaction_type else null end transaction_type from (
				 select pis_unit_id unit_id, count(0) no_of_tx,
				  case when trunc(sysdate) - trunc(MAX(delivery_date)) < 30 then 1 
				   when trunc(sysdate) - trunc(MAX(delivery_date)) < 90 then 2 
				   when trunc(sysdate) - trunc(MAX(delivery_date)) < 365 then 3
				   else 4 end as latest_Tx,
				   trunc(MAX(delivery_date)) AS delivery_date, MAX(nvl(to_char(mkt_type),'2')) mkt_type
				 from mdb_pis_unit_tx_mapping su, building sb
				 where su.pis_bldg_id = sb.bldg_id
					
					   and sb.est_id = rpad(?, 10, ' ')
					
					
					
					   and sb.street_id = rpad(?, 10, ' ')
					
				   and (sb.deleted is null or sb.deleted = 'N')
				   and (su.deleted is null or su.deleted = 'N')
				   and pis_unit_id is not null
				   and consideration > 0
				   and exists (select 1 from mltest.pt_inst_type where inst_type in ('ASP', 'SSP') and inst_id = instrument_id)
				 group by pis_unit_id
			) p
			left join pis.mdb_pis_unit_tx_mapping b on b.pis_unit_id = p.unit_id and b.delivery_date = p.delivery_date and b.deleted = 'N'
		 ) p
		) tx
 where u.bldg_id = b.bldg_id
   and b.prop_style_id = ps.style_id(+)
   and b.bldg_type = 'HOUSE'

   and b.est_id = rpad(?, 10, ' ')



   and b.street_id = rpad(?, 10, ' ')

   and (b.deleted is null or b.deleted = 'N')
   and rtrim(b.chi_name) is not null
   and nvl(u.room, 0) = tmp_unit_color.room
   and u.unit_id = tx.unit_id(+)
   and trim(u.unit_type) != 'NON-DOME'
 order by replace(translate(b.chi_name, '0123456789', ' '),' ',''), replace(translate(b.chi_name, translate(b.chi_name, '0123456789', 'k'), ' '),' ','') + 1
 
 
 
 

 



 


 



 

: Closed Statement: getMetaData
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:912)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:845)
	org.apache.jsp.index_jsp._jspService(index_jsp.java:189)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.midland.commons.filters.CORSFilter.doFilter(CORSFilter.java:32)
	org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)
	filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)

root cause

javax.servlet.ServletException: javax.servlet.jsp.JspException: 
  select ' ' flat,
       Initcap(CASE WHEN ? IN ('en', 'eng') then rtrim(b.eng_name) else rtrim(b.chi_name) end) floor,
       u.unit_id,
       nvl(u.gross_area, 0) as gross_area,  round(nvl(u.display_net_area, 0), 0) net_area,
       case when color = '#E7FEFD' then '#EBF4F8' when color = '#F7EEFF' then '#fff6e8' when color = '#EBCDFA' then '#e7f8d1' else color end as color,
       nvl(no_of_tx, 0) no_of_tx,
       rtrim(ps.chi_name) prop_style, latest_Tx,case when not consideration is null then CASE when ? = 10000 then round(consideration / 10000,0) else round(consideration / 1000000,2) end else null end
	   as consideration, 
	   case when not consideration2 is null then CASE when ? = 10000 then round(consideration2 / 10000,0) else round(consideration2 / 1000000,2) end else null end
	   as consideration2,  CASE WHEN ? IN ('en', 'eng') then TO_CHAR(delivery_date, 'YYYY') else TO_CHAR(delivery_date, 'YY') end as instrument_date,
	   case when consideration2 =0 then 0 else round( consideration *100 / consideration2  -100,2) end as perc, nvl(to_char(mkt_type),'2') mkt_type
	   , transaction_type
  from unit u, building b, prop_style ps,
       tmp_unit_color,
	   (select (select ps.consideration from pis.mdb_pis_unit_tx_mapping ps where  p.delivery_date = ps.delivery_date
          and p.unit_id = ps.pis_unit_id and rownum = 1) as consideration, p.*,
        ( select distinct p3.consideration from pis.mdb_pis_unit_tx_mapping p3 where rownum =1 and p3.pis_unit_id = p.unit_id and p3.delivery_date =
               (select max(delivery_date) from pis.mdb_pis_unit_tx_mapping p2 where p2.pis_unit_id = p.unit_id and p2.delivery_date < p.delivery_date)
        ) as  consideration2 from  (
			select p.*, case when b.transaction_type is not null then transaction_type else null end transaction_type from (
				 select pis_unit_id unit_id, count(0) no_of_tx,
				  case when trunc(sysdate) - trunc(MAX(delivery_date)) < 30 then 1 
				   when trunc(sysdate) - trunc(MAX(delivery_date)) < 90 then 2 
				   when trunc(sysdate) - trunc(MAX(delivery_date)) < 365 then 3
				   else 4 end as latest_Tx,
				   trunc(MAX(delivery_date)) AS delivery_date, MAX(nvl(to_char(mkt_type),'2')) mkt_type
				 from mdb_pis_unit_tx_mapping su, building sb
				 where su.pis_bldg_id = sb.bldg_id
					
					   and sb.est_id = rpad(?, 10, ' ')
					
					
					
					   and sb.street_id = rpad(?, 10, ' ')
					
				   and (sb.deleted is null or sb.deleted = 'N')
				   and (su.deleted is null or su.deleted = 'N')
				   and pis_unit_id is not null
				   and consideration > 0
				   and exists (select 1 from mltest.pt_inst_type where inst_type in ('ASP', 'SSP') and inst_id = instrument_id)
				 group by pis_unit_id
			) p
			left join pis.mdb_pis_unit_tx_mapping b on b.pis_unit_id = p.unit_id and b.delivery_date = p.delivery_date and b.deleted = 'N'
		 ) p
		) tx
 where u.bldg_id = b.bldg_id
   and b.prop_style_id = ps.style_id(+)
   and b.bldg_type = 'HOUSE'

   and b.est_id = rpad(?, 10, ' ')



   and b.street_id = rpad(?, 10, ' ')

   and (b.deleted is null or b.deleted = 'N')
   and rtrim(b.chi_name) is not null
   and nvl(u.room, 0) = tmp_unit_color.room
   and u.unit_id = tx.unit_id(+)
   and trim(u.unit_type) != 'NON-DOME'
 order by replace(translate(b.chi_name, '0123456789', ' '),' ',''), replace(translate(b.chi_name, translate(b.chi_name, '0123456789', 'k'), ' '),' ','') + 1
 
 
 
 

 



 


 



 

: Closed Statement: getMetaData
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:912)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:845)
	org.apache.jsp.index_005fexecute_jsp._jspService(index_005fexecute_jsp.java:1552)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.taglibs.standard.tag.common.core.ImportSupport.acquireString(ImportSupport.java:296)
	org.apache.taglibs.standard.tag.common.core.ImportSupport.doEndTag(ImportSupport.java:161)
	org.apache.jsp.index_jsp._jspx_meth_c_005fimport_005f0(index_jsp.java:622)
	org.apache.jsp.index_jsp._jspx_meth_c_005fset_005f3(index_jsp.java:587)
	org.apache.jsp.index_jsp._jspService(index_jsp.java:155)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.midland.commons.filters.CORSFilter.doFilter(CORSFilter.java:32)
	org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)
	filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)

root cause

java.sql.SQLException: Closed Statement: getMetaData
	oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
	oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
	oracle.jdbc.driver.OracleResultSetImpl.getMetaData(OracleResultSetImpl.java:128)
	org.apache.taglibs.standard.tag.common.sql.ResultImpl.<init>(ResultImpl.java:64)
	org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTagSupport.java:217)
	org.apache.jsp.index_005fexecute_jsp._jspx_meth_sql_005fquery_005f17(index_005fexecute_jsp.java:8012)
	org.apache.jsp.index_005fexecute_jsp._jspService(index_005fexecute_jsp.java:573)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.taglibs.standard.tag.common.core.ImportSupport.acquireString(ImportSupport.java:296)
	org.apache.taglibs.standard.tag.common.core.ImportSupport.doEndTag(ImportSupport.java:161)
	org.apache.jsp.index_jsp._jspx_meth_c_005fimport_005f0(index_jsp.java:622)
	org.apache.jsp.index_jsp._jspx_meth_c_005fset_005f3(index_jsp.java:587)
	org.apache.jsp.index_jsp._jspService(index_jsp.java:155)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	com.midland.commons.filters.CORSFilter.doFilter(CORSFilter.java:32)
	org.apache.catalina.filters.AddDefaultCharsetFilter.doFilter(AddDefaultCharsetFilter.java:88)
	filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:123)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.73 logs.


Apache Tomcat/7.0.73