/jgking/home/homedesign/homedetailsorg.apache.jasper.JasperException: org.apache.jasper.JasperException: com.sok.framework.generation.DatabaseException: com.sok.framework.generation.DatabaseException: SELECT Products.ProductID, Products.Name, Products.ProductNum, Products.Description, Products.Summary, Products.Category, Products.BaseCost, Products.Margin, Products.Cost, Products.GST, Products.TotalCost, Products.CreatedDate, Products.CreatedBy, Products.ModifiedDate, Products.DripModifiedDate, Products.ModifiedBy, Products.ProductGroupID, Products.CopiedFromProductID, Products.Image, Products.ThumbnailImage, Products.ProductDetails, Products.Active, Products.VariablePrice, Products.StockLevel, Products.ProductType, Products.ProductSubType, Products.PricingType, Products.GSTExempt, Products.BaseCost AS EditBaseCost, Products.Margin*100 AS DisplayMargin, Products.Cost AS EditCost, Products.GST AS EditGST, Products.TotalCost AS EditTotalCost, Products.GroupID, Products.AvailableDate, Products.ExpiryDate, Products.SupplierCompanyID, Products.ProductStatusID, Products.LocationID, Products.RegionID, Products.ProductRating, Products.UpdateByProcess, Products.Stage, Products.URL, Products.PublishDescription, Products.DripCost, Products.DripResult, Products.HomeSummary, Products.PublishHomeDescription, Products.Name AS PlanName, Products.DisplayPriceType, Products.DisplayPrice, ProductHomeDetails.Bedrooms AS Bedrooms, ProductHomeDetails.Bathrooms AS Bathrooms, ProductHomeDetails.HomeSize AS HomeSize, ProductHomeDetails.HomeSizeSq AS HomeSizeSq, ProductHomeDetails.LotWidth AS LotWidth, ProductHomeDetails.LotDepth AS LotDepth, ProductHomeDetails.Garage AS Garage, ProductHomeDetails.Study AS Study, ProductHomeDetails.LivingRooms AS LivingRooms, ProductHomeDetails.Dimensions AS Dimensions, ProductHomeDetails.CarParks AS CarParks, ProductHomeDetails.CanFitOnDepth AS CanFitOnDepth, ProductHomeDetails.CanFitOnFrontage AS CanFitOnFrontage, ProductHomeDetails.WillFitHouseSize AS WillFitHouseSize, ProductHomeDetails.Storey AS Storey, ProductHomeDetails.GroundFloorArea AS GroundFloorArea, ProductHomeDetails.FirstFloorWindows AS FirstFloorWindows, ProductHomeDetails.EavesFacade AS EavesFacade, ProductHomeDetails.EavesGround AS EavesGround, ProductHomeDetails.EavesFirst AS EavesFirst, ProductHomeDetails.Media AS Media, ProductHomeDetails.Orientation AS Orientation, ProductGroup.SectionCode AS SectionCode, ProductProductGroup.GroupName AS GroupName, ProductGroup.Name AS SecurityGroupName, ProductModified.FirstName AS ModFirstName, ProductModified.LastName AS ModLastName, ProductCreated.FirstName AS OwnFirstName, ProductCreated.LastName AS OwnLastName, ProductImage.FileName AS ImageName, ProductImage.FilePath AS ImagePath, ProductImage.Description AS ImageDescription, ProductThumbnailImage.FileName AS ThumbnailImageName, ProductThumbnailImage.FilePath AS ThumbnailImagePath, ProductSupplierCompany.Company AS SupplierCompany, ProductStatusList.StatusID AS CurrentStatusID, ProductStatusList.Status AS CurrentStatus, ProductStatusList.StatusValue AS CurrentStatusValue, ProductVariationHomeDesign.Name AS HomeName, ProductVariationHomeDesign.ShowOnPortalFlag AS HomeShowOnPortalFlag, ProductVariationHomeDesign.ProductNum AS HomeProductNum, ProductVariationHomeDesign.Image AS HomeImage, ProductImage_home.FilePath AS HomeImagePath, ProductVariationHomeDesign.ThumbnailImage AS HomeThumbnailImage, ProductThumbnailImage_home.FilePath AS HomeThumbnailPath, ProductVariationHomeDesign.PreAvailableDate AS HomePreAvailableDate, ProductVariationHomeDesign.AvailableDate AS HomeAvailableDate, ProductVariationHomeDesign.ProductID AS HomeProductID, ProductVariationHomeRange.Name AS RangeName, ProductVariationHomeRange.ShowOnPortalFlag AS RangeShowOnPortalFlag, ProductVariationHomeRange.RangeColorHex AS RangeColorHex, ProductVariationHomeRange.ProductNum AS RangeProductNum, ProductVariationHomeRange.ProductID AS RangeProductID, ProductVariationBrandRange.ProductID AS BrandProductID, ProductVariationBrandRange.Name AS BrandName, ProductVariationBuilderBrand.ProductID AS BuilderProductID, ProductVariationBuilderBrand.Name AS BuilderName FROM Products LEFT OUTER JOIN HomeDetails AS ProductHomeDetails ON Products.ProductID = ProductHomeDetails.ProductID LEFT OUTER JOIN Groups AS ProductGroup ON Products.GroupID = ProductGroup.GroupID LEFT OUTER JOIN ProductGroups AS ProductProductGroup ON Products.ProductGroupID = ProductProductGroup.ProductGroupID LEFT OUTER JOIN Users AS ProductModified ON Products.ModifiedBy = ProductModified.UserID LEFT OUTER JOIN Users AS ProductCreated ON Products.CreatedBy = ProductCreated.UserID LEFT OUTER JOIN Documents AS ProductImage ON Products.Image = ProductImage.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage ON Products.ThumbnailImage = ProductThumbnailImage.DocumentID LEFT OUTER JOIN Companies AS ProductSupplierCompany ON Products.SupplierCompanyID = ProductSupplierCompany.CompanyID LEFT OUTER JOIN ProductStatus AS ProductCurrentStatus ON Products.ProductStatusID = ProductCurrentStatus.ProductStatusID LEFT OUTER JOIN StatusList AS ProductStatusList ON ProductCurrentStatus.StatusID = ProductStatusList.StatusID LEFT OUTER JOIN ProductVariations AS ProductParentHomeDesign ON Products.ProductID = ProductParentHomeDesign.ChildProductID AND ProductParentHomeDesign.Type = 'Home' LEFT OUTER JOIN Products AS ProductVariationHomeDesign ON ProductParentHomeDesign.ParentProductID = ProductVariationHomeDesign.ProductID AND ProductVariationHomeDesign.ProductType = 'Home' LEFT OUTER JOIN Documents AS ProductImage_home ON ProductVariationHomeDesign.Image = ProductImage_home.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage_home ON ProductVariationHomeDesign.ThumbnailImage = ProductThumbnailImage_home.DocumentID LEFT OUTER JOIN ProductVariations AS ProductParentHomeRange ON ProductVariationHomeDesign.ProductID = ProductParentHomeRange.ChildProductID AND ProductParentHomeRange.Type = 'Home Range' LEFT OUTER JOIN Products AS ProductVariationHomeRange ON ProductParentHomeRange.ParentProductID = ProductVariationHomeRange.ProductID AND ProductVariationHomeRange.ProductType = 'Home Range' LEFT OUTER JOIN ProductVariations AS ProductParentBrandRange ON ProductVariationHomeRange.ProductID = ProductParentBrandRange.ChildProductID AND ProductParentBrandRange.Type = 'Brand' LEFT OUTER JOIN Products AS ProductVariationBrandRange ON ProductParentBrandRange.ParentProductID = ProductVariationBrandRange.ProductID AND ProductVariationBrandRange.ProductType = 'Brand' LEFT OUTER JOIN ProductVariations AS ProductParentBuilderBrand ON ProductVariationBrandRange.ProductID = ProductParentBuilderBrand.ChildProductID AND ProductParentBuilderBrand.Type = 'Builder' LEFT OUTER JOIN Products AS ProductVariationBuilderBrand ON ProductParentBuilderBrand.ParentProductID = ProductVariationBuilderBrand.ProductID AND ProductVariationBuilderBrand.ProductType = 'Builder' WHERE Products.ProductType = 'Home Plan' AND Products.Active = 'Y' AND ProductVariationHomeDesign.ProductID = '0T1K46888V26326Z14370V3N8C7F' AND ((Products.Category <> 'PlanSale') OR (Products.Category IS NULL)) ORDER BY Products.Name /* */ null Database Error at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:549) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:455) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:593) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:530) at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954) at org.apache.jsp.cms.websites.index_jsp._jspService(index_jsp.java:200) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.sok.runway.URLFilter.doFilter(URLFilter.java:146) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: org.apache.jasper.JasperException: com.sok.framework.generation.DatabaseException: com.sok.framework.generation.DatabaseException: SELECT Products.ProductID, Products.Name, Products.ProductNum, Products.Description, Products.Summary, Products.Category, Products.BaseCost, Products.Margin, Products.Cost, Products.GST, Products.TotalCost, Products.CreatedDate, Products.CreatedBy, Products.ModifiedDate, Products.DripModifiedDate, Products.ModifiedBy, Products.ProductGroupID, Products.CopiedFromProductID, Products.Image, Products.ThumbnailImage, Products.ProductDetails, Products.Active, Products.VariablePrice, Products.StockLevel, Products.ProductType, Products.ProductSubType, Products.PricingType, Products.GSTExempt, Products.BaseCost AS EditBaseCost, Products.Margin*100 AS DisplayMargin, Products.Cost AS EditCost, Products.GST AS EditGST, Products.TotalCost AS EditTotalCost, Products.GroupID, Products.AvailableDate, Products.ExpiryDate, Products.SupplierCompanyID, Products.ProductStatusID, Products.LocationID, Products.RegionID, Products.ProductRating, Products.UpdateByProcess, Products.Stage, Products.URL, Products.PublishDescription, Products.DripCost, Products.DripResult, Products.HomeSummary, Products.PublishHomeDescription, Products.Name AS PlanName, Products.DisplayPriceType, Products.DisplayPrice, ProductHomeDetails.Bedrooms AS Bedrooms, ProductHomeDetails.Bathrooms AS Bathrooms, ProductHomeDetails.HomeSize AS HomeSize, ProductHomeDetails.HomeSizeSq AS HomeSizeSq, ProductHomeDetails.LotWidth AS LotWidth, ProductHomeDetails.LotDepth AS LotDepth, ProductHomeDetails.Garage AS Garage, ProductHomeDetails.Study AS Study, ProductHomeDetails.LivingRooms AS LivingRooms, ProductHomeDetails.Dimensions AS Dimensions, ProductHomeDetails.CarParks AS CarParks, ProductHomeDetails.CanFitOnDepth AS CanFitOnDepth, ProductHomeDetails.CanFitOnFrontage AS CanFitOnFrontage, ProductHomeDetails.WillFitHouseSize AS WillFitHouseSize, ProductHomeDetails.Storey AS Storey, ProductHomeDetails.GroundFloorArea AS GroundFloorArea, ProductHomeDetails.FirstFloorWindows AS FirstFloorWindows, ProductHomeDetails.EavesFacade AS EavesFacade, ProductHomeDetails.EavesGround AS EavesGround, ProductHomeDetails.EavesFirst AS EavesFirst, ProductHomeDetails.Media AS Media, ProductHomeDetails.Orientation AS Orientation, ProductGroup.SectionCode AS SectionCode, ProductProductGroup.GroupName AS GroupName, ProductGroup.Name AS SecurityGroupName, ProductModified.FirstName AS ModFirstName, ProductModified.LastName AS ModLastName, ProductCreated.FirstName AS OwnFirstName, ProductCreated.LastName AS OwnLastName, ProductImage.FileName AS ImageName, ProductImage.FilePath AS ImagePath, ProductImage.Description AS ImageDescription, ProductThumbnailImage.FileName AS ThumbnailImageName, ProductThumbnailImage.FilePath AS ThumbnailImagePath, ProductSupplierCompany.Company AS SupplierCompany, ProductStatusList.StatusID AS CurrentStatusID, ProductStatusList.Status AS CurrentStatus, ProductStatusList.StatusValue AS CurrentStatusValue, ProductVariationHomeDesign.Name AS HomeName, ProductVariationHomeDesign.ShowOnPortalFlag AS HomeShowOnPortalFlag, ProductVariationHomeDesign.ProductNum AS HomeProductNum, ProductVariationHomeDesign.Image AS HomeImage, ProductImage_home.FilePath AS HomeImagePath, ProductVariationHomeDesign.ThumbnailImage AS HomeThumbnailImage, ProductThumbnailImage_home.FilePath AS HomeThumbnailPath, ProductVariationHomeDesign.PreAvailableDate AS HomePreAvailableDate, ProductVariationHomeDesign.AvailableDate AS HomeAvailableDate, ProductVariationHomeDesign.ProductID AS HomeProductID, ProductVariationHomeRange.Name AS RangeName, ProductVariationHomeRange.ShowOnPortalFlag AS RangeShowOnPortalFlag, ProductVariationHomeRange.RangeColorHex AS RangeColorHex, ProductVariationHomeRange.ProductNum AS RangeProductNum, ProductVariationHomeRange.ProductID AS RangeProductID, ProductVariationBrandRange.ProductID AS BrandProductID, ProductVariationBrandRange.Name AS BrandName, ProductVariationBuilderBrand.ProductID AS BuilderProductID, ProductVariationBuilderBrand.Name AS BuilderName FROM Products LEFT OUTER JOIN HomeDetails AS ProductHomeDetails ON Products.ProductID = ProductHomeDetails.ProductID LEFT OUTER JOIN Groups AS ProductGroup ON Products.GroupID = ProductGroup.GroupID LEFT OUTER JOIN ProductGroups AS ProductProductGroup ON Products.ProductGroupID = ProductProductGroup.ProductGroupID LEFT OUTER JOIN Users AS ProductModified ON Products.ModifiedBy = ProductModified.UserID LEFT OUTER JOIN Users AS ProductCreated ON Products.CreatedBy = ProductCreated.UserID LEFT OUTER JOIN Documents AS ProductImage ON Products.Image = ProductImage.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage ON Products.ThumbnailImage = ProductThumbnailImage.DocumentID LEFT OUTER JOIN Companies AS ProductSupplierCompany ON Products.SupplierCompanyID = ProductSupplierCompany.CompanyID LEFT OUTER JOIN ProductStatus AS ProductCurrentStatus ON Products.ProductStatusID = ProductCurrentStatus.ProductStatusID LEFT OUTER JOIN StatusList AS ProductStatusList ON ProductCurrentStatus.StatusID = ProductStatusList.StatusID LEFT OUTER JOIN ProductVariations AS ProductParentHomeDesign ON Products.ProductID = ProductParentHomeDesign.ChildProductID AND ProductParentHomeDesign.Type = 'Home' LEFT OUTER JOIN Products AS ProductVariationHomeDesign ON ProductParentHomeDesign.ParentProductID = ProductVariationHomeDesign.ProductID AND ProductVariationHomeDesign.ProductType = 'Home' LEFT OUTER JOIN Documents AS ProductImage_home ON ProductVariationHomeDesign.Image = ProductImage_home.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage_home ON ProductVariationHomeDesign.ThumbnailImage = ProductThumbnailImage_home.DocumentID LEFT OUTER JOIN ProductVariations AS ProductParentHomeRange ON ProductVariationHomeDesign.ProductID = ProductParentHomeRange.ChildProductID AND ProductParentHomeRange.Type = 'Home Range' LEFT OUTER JOIN Products AS ProductVariationHomeRange ON ProductParentHomeRange.ParentProductID = ProductVariationHomeRange.ProductID AND ProductVariationHomeRange.ProductType = 'Home Range' LEFT OUTER JOIN ProductVariations AS ProductParentBrandRange ON ProductVariationHomeRange.ProductID = ProductParentBrandRange.ChildProductID AND ProductParentBrandRange.Type = 'Brand' LEFT OUTER JOIN Products AS ProductVariationBrandRange ON ProductParentBrandRange.ParentProductID = ProductVariationBrandRange.ProductID AND ProductVariationBrandRange.ProductType = 'Brand' LEFT OUTER JOIN ProductVariations AS ProductParentBuilderBrand ON ProductVariationBrandRange.ProductID = ProductParentBuilderBrand.ChildProductID AND ProductParentBuilderBrand.Type = 'Builder' LEFT OUTER JOIN Products AS ProductVariationBuilderBrand ON ProductParentBuilderBrand.ParentProductID = ProductVariationBuilderBrand.ProductID AND ProductVariationBuilderBrand.ProductType = 'Builder' WHERE Products.ProductType = 'Home Plan' AND Products.Active = 'Y' AND ProductVariationHomeDesign.ProductID = '0T1K46888V26326Z14370V3N8C7F' AND ((Products.Category <> 'PlanSale') OR (Products.Category IS NULL)) ORDER BY Products.Name /* */ null Database Error at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:549) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:593) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:530) at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954) at org.apache.jsp.cms.websites.jgking.includes.formats.standard_005fformat_jsp._jspx_meth_c_005fif_005f1(standard_005fformat_jsp.java:478) at org.apache.jsp.cms.websites.jgking.includes.formats.standard_005fformat_jsp._jspService(standard_005fformat_jsp.java:393) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) ... 39 more Caused by: com.sok.framework.generation.DatabaseException: com.sok.framework.generation.DatabaseException: SELECT Products.ProductID, Products.Name, Products.ProductNum, Products.Description, Products.Summary, Products.Category, Products.BaseCost, Products.Margin, Products.Cost, Products.GST, Products.TotalCost, Products.CreatedDate, Products.CreatedBy, Products.ModifiedDate, Products.DripModifiedDate, Products.ModifiedBy, Products.ProductGroupID, Products.CopiedFromProductID, Products.Image, Products.ThumbnailImage, Products.ProductDetails, Products.Active, Products.VariablePrice, Products.StockLevel, Products.ProductType, Products.ProductSubType, Products.PricingType, Products.GSTExempt, Products.BaseCost AS EditBaseCost, Products.Margin*100 AS DisplayMargin, Products.Cost AS EditCost, Products.GST AS EditGST, Products.TotalCost AS EditTotalCost, Products.GroupID, Products.AvailableDate, Products.ExpiryDate, Products.SupplierCompanyID, Products.ProductStatusID, Products.LocationID, Products.RegionID, Products.ProductRating, Products.UpdateByProcess, Products.Stage, Products.URL, Products.PublishDescription, Products.DripCost, Products.DripResult, Products.HomeSummary, Products.PublishHomeDescription, Products.Name AS PlanName, Products.DisplayPriceType, Products.DisplayPrice, ProductHomeDetails.Bedrooms AS Bedrooms, ProductHomeDetails.Bathrooms AS Bathrooms, ProductHomeDetails.HomeSize AS HomeSize, ProductHomeDetails.HomeSizeSq AS HomeSizeSq, ProductHomeDetails.LotWidth AS LotWidth, ProductHomeDetails.LotDepth AS LotDepth, ProductHomeDetails.Garage AS Garage, ProductHomeDetails.Study AS Study, ProductHomeDetails.LivingRooms AS LivingRooms, ProductHomeDetails.Dimensions AS Dimensions, ProductHomeDetails.CarParks AS CarParks, ProductHomeDetails.CanFitOnDepth AS CanFitOnDepth, ProductHomeDetails.CanFitOnFrontage AS CanFitOnFrontage, ProductHomeDetails.WillFitHouseSize AS WillFitHouseSize, ProductHomeDetails.Storey AS Storey, ProductHomeDetails.GroundFloorArea AS GroundFloorArea, ProductHomeDetails.FirstFloorWindows AS FirstFloorWindows, ProductHomeDetails.EavesFacade AS EavesFacade, ProductHomeDetails.EavesGround AS EavesGround, ProductHomeDetails.EavesFirst AS EavesFirst, ProductHomeDetails.Media AS Media, ProductHomeDetails.Orientation AS Orientation, ProductGroup.SectionCode AS SectionCode, ProductProductGroup.GroupName AS GroupName, ProductGroup.Name AS SecurityGroupName, ProductModified.FirstName AS ModFirstName, ProductModified.LastName AS ModLastName, ProductCreated.FirstName AS OwnFirstName, ProductCreated.LastName AS OwnLastName, ProductImage.FileName AS ImageName, ProductImage.FilePath AS ImagePath, ProductImage.Description AS ImageDescription, ProductThumbnailImage.FileName AS ThumbnailImageName, ProductThumbnailImage.FilePath AS ThumbnailImagePath, ProductSupplierCompany.Company AS SupplierCompany, ProductStatusList.StatusID AS CurrentStatusID, ProductStatusList.Status AS CurrentStatus, ProductStatusList.StatusValue AS CurrentStatusValue, ProductVariationHomeDesign.Name AS HomeName, ProductVariationHomeDesign.ShowOnPortalFlag AS HomeShowOnPortalFlag, ProductVariationHomeDesign.ProductNum AS HomeProductNum, ProductVariationHomeDesign.Image AS HomeImage, ProductImage_home.FilePath AS HomeImagePath, ProductVariationHomeDesign.ThumbnailImage AS HomeThumbnailImage, ProductThumbnailImage_home.FilePath AS HomeThumbnailPath, ProductVariationHomeDesign.PreAvailableDate AS HomePreAvailableDate, ProductVariationHomeDesign.AvailableDate AS HomeAvailableDate, ProductVariationHomeDesign.ProductID AS HomeProductID, ProductVariationHomeRange.Name AS RangeName, ProductVariationHomeRange.ShowOnPortalFlag AS RangeShowOnPortalFlag, ProductVariationHomeRange.RangeColorHex AS RangeColorHex, ProductVariationHomeRange.ProductNum AS RangeProductNum, ProductVariationHomeRange.ProductID AS RangeProductID, ProductVariationBrandRange.ProductID AS BrandProductID, ProductVariationBrandRange.Name AS BrandName, ProductVariationBuilderBrand.ProductID AS BuilderProductID, ProductVariationBuilderBrand.Name AS BuilderName FROM Products LEFT OUTER JOIN HomeDetails AS ProductHomeDetails ON Products.ProductID = ProductHomeDetails.ProductID LEFT OUTER JOIN Groups AS ProductGroup ON Products.GroupID = ProductGroup.GroupID LEFT OUTER JOIN ProductGroups AS ProductProductGroup ON Products.ProductGroupID = ProductProductGroup.ProductGroupID LEFT OUTER JOIN Users AS ProductModified ON Products.ModifiedBy = ProductModified.UserID LEFT OUTER JOIN Users AS ProductCreated ON Products.CreatedBy = ProductCreated.UserID LEFT OUTER JOIN Documents AS ProductImage ON Products.Image = ProductImage.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage ON Products.ThumbnailImage = ProductThumbnailImage.DocumentID LEFT OUTER JOIN Companies AS ProductSupplierCompany ON Products.SupplierCompanyID = ProductSupplierCompany.CompanyID LEFT OUTER JOIN ProductStatus AS ProductCurrentStatus ON Products.ProductStatusID = ProductCurrentStatus.ProductStatusID LEFT OUTER JOIN StatusList AS ProductStatusList ON ProductCurrentStatus.StatusID = ProductStatusList.StatusID LEFT OUTER JOIN ProductVariations AS ProductParentHomeDesign ON Products.ProductID = ProductParentHomeDesign.ChildProductID AND ProductParentHomeDesign.Type = 'Home' LEFT OUTER JOIN Products AS ProductVariationHomeDesign ON ProductParentHomeDesign.ParentProductID = ProductVariationHomeDesign.ProductID AND ProductVariationHomeDesign.ProductType = 'Home' LEFT OUTER JOIN Documents AS ProductImage_home ON ProductVariationHomeDesign.Image = ProductImage_home.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage_home ON ProductVariationHomeDesign.ThumbnailImage = ProductThumbnailImage_home.DocumentID LEFT OUTER JOIN ProductVariations AS ProductParentHomeRange ON ProductVariationHomeDesign.ProductID = ProductParentHomeRange.ChildProductID AND ProductParentHomeRange.Type = 'Home Range' LEFT OUTER JOIN Products AS ProductVariationHomeRange ON ProductParentHomeRange.ParentProductID = ProductVariationHomeRange.ProductID AND ProductVariationHomeRange.ProductType = 'Home Range' LEFT OUTER JOIN ProductVariations AS ProductParentBrandRange ON ProductVariationHomeRange.ProductID = ProductParentBrandRange.ChildProductID AND ProductParentBrandRange.Type = 'Brand' LEFT OUTER JOIN Products AS ProductVariationBrandRange ON ProductParentBrandRange.ParentProductID = ProductVariationBrandRange.ProductID AND ProductVariationBrandRange.ProductType = 'Brand' LEFT OUTER JOIN ProductVariations AS ProductParentBuilderBrand ON ProductVariationBrandRange.ProductID = ProductParentBuilderBrand.ChildProductID AND ProductParentBuilderBrand.Type = 'Builder' LEFT OUTER JOIN Products AS ProductVariationBuilderBrand ON ProductParentBuilderBrand.ParentProductID = ProductVariationBuilderBrand.ProductID AND ProductVariationBuilderBrand.ProductType = 'Builder' WHERE Products.ProductType = 'Home Plan' AND Products.Active = 'Y' AND ProductVariationHomeDesign.ProductID = '0T1K46888V26326Z14370V3N8C7F' AND ((Products.Category <> 'PlanSale') OR (Products.Category IS NULL)) ORDER BY Products.Name /* */ null Database Error at com.sok.framework.generation.Rows.getResults(Rows.java:85) at com.sok.framework.generation.Rows.getResults(Rows.java:97) at org.apache.jsp.cms.websites.jgking.includes.pages.home_005fdetails_jsp._jspService(home_005fdetails_jsp.java:182) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) ... 53 more Caused by: com.sok.framework.generation.DatabaseException: SELECT Products.ProductID, Products.Name, Products.ProductNum, Products.Description, Products.Summary, Products.Category, Products.BaseCost, Products.Margin, Products.Cost, Products.GST, Products.TotalCost, Products.CreatedDate, Products.CreatedBy, Products.ModifiedDate, Products.DripModifiedDate, Products.ModifiedBy, Products.ProductGroupID, Products.CopiedFromProductID, Products.Image, Products.ThumbnailImage, Products.ProductDetails, Products.Active, Products.VariablePrice, Products.StockLevel, Products.ProductType, Products.ProductSubType, Products.PricingType, Products.GSTExempt, Products.BaseCost AS EditBaseCost, Products.Margin*100 AS DisplayMargin, Products.Cost AS EditCost, Products.GST AS EditGST, Products.TotalCost AS EditTotalCost, Products.GroupID, Products.AvailableDate, Products.ExpiryDate, Products.SupplierCompanyID, Products.ProductStatusID, Products.LocationID, Products.RegionID, Products.ProductRating, Products.UpdateByProcess, Products.Stage, Products.URL, Products.PublishDescription, Products.DripCost, Products.DripResult, Products.HomeSummary, Products.PublishHomeDescription, Products.Name AS PlanName, Products.DisplayPriceType, Products.DisplayPrice, ProductHomeDetails.Bedrooms AS Bedrooms, ProductHomeDetails.Bathrooms AS Bathrooms, ProductHomeDetails.HomeSize AS HomeSize, ProductHomeDetails.HomeSizeSq AS HomeSizeSq, ProductHomeDetails.LotWidth AS LotWidth, ProductHomeDetails.LotDepth AS LotDepth, ProductHomeDetails.Garage AS Garage, ProductHomeDetails.Study AS Study, ProductHomeDetails.LivingRooms AS LivingRooms, ProductHomeDetails.Dimensions AS Dimensions, ProductHomeDetails.CarParks AS CarParks, ProductHomeDetails.CanFitOnDepth AS CanFitOnDepth, ProductHomeDetails.CanFitOnFrontage AS CanFitOnFrontage, ProductHomeDetails.WillFitHouseSize AS WillFitHouseSize, ProductHomeDetails.Storey AS Storey, ProductHomeDetails.GroundFloorArea AS GroundFloorArea, ProductHomeDetails.FirstFloorWindows AS FirstFloorWindows, ProductHomeDetails.EavesFacade AS EavesFacade, ProductHomeDetails.EavesGround AS EavesGround, ProductHomeDetails.EavesFirst AS EavesFirst, ProductHomeDetails.Media AS Media, ProductHomeDetails.Orientation AS Orientation, ProductGroup.SectionCode AS SectionCode, ProductProductGroup.GroupName AS GroupName, ProductGroup.Name AS SecurityGroupName, ProductModified.FirstName AS ModFirstName, ProductModified.LastName AS ModLastName, ProductCreated.FirstName AS OwnFirstName, ProductCreated.LastName AS OwnLastName, ProductImage.FileName AS ImageName, ProductImage.FilePath AS ImagePath, ProductImage.Description AS ImageDescription, ProductThumbnailImage.FileName AS ThumbnailImageName, ProductThumbnailImage.FilePath AS ThumbnailImagePath, ProductSupplierCompany.Company AS SupplierCompany, ProductStatusList.StatusID AS CurrentStatusID, ProductStatusList.Status AS CurrentStatus, ProductStatusList.StatusValue AS CurrentStatusValue, ProductVariationHomeDesign.Name AS HomeName, ProductVariationHomeDesign.ShowOnPortalFlag AS HomeShowOnPortalFlag, ProductVariationHomeDesign.ProductNum AS HomeProductNum, ProductVariationHomeDesign.Image AS HomeImage, ProductImage_home.FilePath AS HomeImagePath, ProductVariationHomeDesign.ThumbnailImage AS HomeThumbnailImage, ProductThumbnailImage_home.FilePath AS HomeThumbnailPath, ProductVariationHomeDesign.PreAvailableDate AS HomePreAvailableDate, ProductVariationHomeDesign.AvailableDate AS HomeAvailableDate, ProductVariationHomeDesign.ProductID AS HomeProductID, ProductVariationHomeRange.Name AS RangeName, ProductVariationHomeRange.ShowOnPortalFlag AS RangeShowOnPortalFlag, ProductVariationHomeRange.RangeColorHex AS RangeColorHex, ProductVariationHomeRange.ProductNum AS RangeProductNum, ProductVariationHomeRange.ProductID AS RangeProductID, ProductVariationBrandRange.ProductID AS BrandProductID, ProductVariationBrandRange.Name AS BrandName, ProductVariationBuilderBrand.ProductID AS BuilderProductID, ProductVariationBuilderBrand.Name AS BuilderName FROM Products LEFT OUTER JOIN HomeDetails AS ProductHomeDetails ON Products.ProductID = ProductHomeDetails.ProductID LEFT OUTER JOIN Groups AS ProductGroup ON Products.GroupID = ProductGroup.GroupID LEFT OUTER JOIN ProductGroups AS ProductProductGroup ON Products.ProductGroupID = ProductProductGroup.ProductGroupID LEFT OUTER JOIN Users AS ProductModified ON Products.ModifiedBy = ProductModified.UserID LEFT OUTER JOIN Users AS ProductCreated ON Products.CreatedBy = ProductCreated.UserID LEFT OUTER JOIN Documents AS ProductImage ON Products.Image = ProductImage.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage ON Products.ThumbnailImage = ProductThumbnailImage.DocumentID LEFT OUTER JOIN Companies AS ProductSupplierCompany ON Products.SupplierCompanyID = ProductSupplierCompany.CompanyID LEFT OUTER JOIN ProductStatus AS ProductCurrentStatus ON Products.ProductStatusID = ProductCurrentStatus.ProductStatusID LEFT OUTER JOIN StatusList AS ProductStatusList ON ProductCurrentStatus.StatusID = ProductStatusList.StatusID LEFT OUTER JOIN ProductVariations AS ProductParentHomeDesign ON Products.ProductID = ProductParentHomeDesign.ChildProductID AND ProductParentHomeDesign.Type = 'Home' LEFT OUTER JOIN Products AS ProductVariationHomeDesign ON ProductParentHomeDesign.ParentProductID = ProductVariationHomeDesign.ProductID AND ProductVariationHomeDesign.ProductType = 'Home' LEFT OUTER JOIN Documents AS ProductImage_home ON ProductVariationHomeDesign.Image = ProductImage_home.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage_home ON ProductVariationHomeDesign.ThumbnailImage = ProductThumbnailImage_home.DocumentID LEFT OUTER JOIN ProductVariations AS ProductParentHomeRange ON ProductVariationHomeDesign.ProductID = ProductParentHomeRange.ChildProductID AND ProductParentHomeRange.Type = 'Home Range' LEFT OUTER JOIN Products AS ProductVariationHomeRange ON ProductParentHomeRange.ParentProductID = ProductVariationHomeRange.ProductID AND ProductVariationHomeRange.ProductType = 'Home Range' LEFT OUTER JOIN ProductVariations AS ProductParentBrandRange ON ProductVariationHomeRange.ProductID = ProductParentBrandRange.ChildProductID AND ProductParentBrandRange.Type = 'Brand' LEFT OUTER JOIN Products AS ProductVariationBrandRange ON ProductParentBrandRange.ParentProductID = ProductVariationBrandRange.ProductID AND ProductVariationBrandRange.ProductType = 'Brand' LEFT OUTER JOIN ProductVariations AS ProductParentBuilderBrand ON ProductVariationBrandRange.ProductID = ProductParentBuilderBrand.ChildProductID AND ProductParentBuilderBrand.Type = 'Builder' LEFT OUTER JOIN Products AS ProductVariationBuilderBrand ON ProductParentBuilderBrand.ParentProductID = ProductVariationBuilderBrand.ProductID AND ProductVariationBuilderBrand.ProductType = 'Builder' WHERE Products.ProductType = 'Home Plan' AND Products.Active = 'Y' AND ProductVariationHomeDesign.ProductID = '0T1K46888V26326Z14370V3N8C7F' AND ((Products.Category <> 'PlanSale') OR (Products.Category IS NULL)) ORDER BY Products.Name /* */ null at com.sok.framework.generation.DatabaseFactory.retrieveResultSet(DatabaseFactory.java:471) at com.sok.framework.generation.Rows.getResults(Rows.java:71) ... 58 more Caused by: java.sql.SQLException: Got error 28 from storage engine at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at com.sok.framework.generation.DatabaseFactory.retrieveResultSet(DatabaseFactory.java:465) ... 59 more Caused By.. org.apache.jasper.JasperException: com.sok.framework.generation.DatabaseException: com.sok.framework.generation.DatabaseException: SELECT Products.ProductID, Products.Name, Products.ProductNum, Products.Description, Products.Summary, Products.Category, Products.BaseCost, Products.Margin, Products.Cost, Products.GST, Products.TotalCost, Products.CreatedDate, Products.CreatedBy, Products.ModifiedDate, Products.DripModifiedDate, Products.ModifiedBy, Products.ProductGroupID, Products.CopiedFromProductID, Products.Image, Products.ThumbnailImage, Products.ProductDetails, Products.Active, Products.VariablePrice, Products.StockLevel, Products.ProductType, Products.ProductSubType, Products.PricingType, Products.GSTExempt, Products.BaseCost AS EditBaseCost, Products.Margin*100 AS DisplayMargin, Products.Cost AS EditCost, Products.GST AS EditGST, Products.TotalCost AS EditTotalCost, Products.GroupID, Products.AvailableDate, Products.ExpiryDate, Products.SupplierCompanyID, Products.ProductStatusID, Products.LocationID, Products.RegionID, Products.ProductRating, Products.UpdateByProcess, Products.Stage, Products.URL, Products.PublishDescription, Products.DripCost, Products.DripResult, Products.HomeSummary, Products.PublishHomeDescription, Products.Name AS PlanName, Products.DisplayPriceType, Products.DisplayPrice, ProductHomeDetails.Bedrooms AS Bedrooms, ProductHomeDetails.Bathrooms AS Bathrooms, ProductHomeDetails.HomeSize AS HomeSize, ProductHomeDetails.HomeSizeSq AS HomeSizeSq, ProductHomeDetails.LotWidth AS LotWidth, ProductHomeDetails.LotDepth AS LotDepth, ProductHomeDetails.Garage AS Garage, ProductHomeDetails.Study AS Study, ProductHomeDetails.LivingRooms AS LivingRooms, ProductHomeDetails.Dimensions AS Dimensions, ProductHomeDetails.CarParks AS CarParks, ProductHomeDetails.CanFitOnDepth AS CanFitOnDepth, ProductHomeDetails.CanFitOnFrontage AS CanFitOnFrontage, ProductHomeDetails.WillFitHouseSize AS WillFitHouseSize, ProductHomeDetails.Storey AS Storey, ProductHomeDetails.GroundFloorArea AS GroundFloorArea, ProductHomeDetails.FirstFloorWindows AS FirstFloorWindows, ProductHomeDetails.EavesFacade AS EavesFacade, ProductHomeDetails.EavesGround AS EavesGround, ProductHomeDetails.EavesFirst AS EavesFirst, ProductHomeDetails.Media AS Media, ProductHomeDetails.Orientation AS Orientation, ProductGroup.SectionCode AS SectionCode, ProductProductGroup.GroupName AS GroupName, ProductGroup.Name AS SecurityGroupName, ProductModified.FirstName AS ModFirstName, ProductModified.LastName AS ModLastName, ProductCreated.FirstName AS OwnFirstName, ProductCreated.LastName AS OwnLastName, ProductImage.FileName AS ImageName, ProductImage.FilePath AS ImagePath, ProductImage.Description AS ImageDescription, ProductThumbnailImage.FileName AS ThumbnailImageName, ProductThumbnailImage.FilePath AS ThumbnailImagePath, ProductSupplierCompany.Company AS SupplierCompany, ProductStatusList.StatusID AS CurrentStatusID, ProductStatusList.Status AS CurrentStatus, ProductStatusList.StatusValue AS CurrentStatusValue, ProductVariationHomeDesign.Name AS HomeName, ProductVariationHomeDesign.ShowOnPortalFlag AS HomeShowOnPortalFlag, ProductVariationHomeDesign.ProductNum AS HomeProductNum, ProductVariationHomeDesign.Image AS HomeImage, ProductImage_home.FilePath AS HomeImagePath, ProductVariationHomeDesign.ThumbnailImage AS HomeThumbnailImage, ProductThumbnailImage_home.FilePath AS HomeThumbnailPath, ProductVariationHomeDesign.PreAvailableDate AS HomePreAvailableDate, ProductVariationHomeDesign.AvailableDate AS HomeAvailableDate, ProductVariationHomeDesign.ProductID AS HomeProductID, ProductVariationHomeRange.Name AS RangeName, ProductVariationHomeRange.ShowOnPortalFlag AS RangeShowOnPortalFlag, ProductVariationHomeRange.RangeColorHex AS RangeColorHex, ProductVariationHomeRange.ProductNum AS RangeProductNum, ProductVariationHomeRange.ProductID AS RangeProductID, ProductVariationBrandRange.ProductID AS BrandProductID, ProductVariationBrandRange.Name AS BrandName, ProductVariationBuilderBrand.ProductID AS BuilderProductID, ProductVariationBuilderBrand.Name AS BuilderName FROM Products LEFT OUTER JOIN HomeDetails AS ProductHomeDetails ON Products.ProductID = ProductHomeDetails.ProductID LEFT OUTER JOIN Groups AS ProductGroup ON Products.GroupID = ProductGroup.GroupID LEFT OUTER JOIN ProductGroups AS ProductProductGroup ON Products.ProductGroupID = ProductProductGroup.ProductGroupID LEFT OUTER JOIN Users AS ProductModified ON Products.ModifiedBy = ProductModified.UserID LEFT OUTER JOIN Users AS ProductCreated ON Products.CreatedBy = ProductCreated.UserID LEFT OUTER JOIN Documents AS ProductImage ON Products.Image = ProductImage.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage ON Products.ThumbnailImage = ProductThumbnailImage.DocumentID LEFT OUTER JOIN Companies AS ProductSupplierCompany ON Products.SupplierCompanyID = ProductSupplierCompany.CompanyID LEFT OUTER JOIN ProductStatus AS ProductCurrentStatus ON Products.ProductStatusID = ProductCurrentStatus.ProductStatusID LEFT OUTER JOIN StatusList AS ProductStatusList ON ProductCurrentStatus.StatusID = ProductStatusList.StatusID LEFT OUTER JOIN ProductVariations AS ProductParentHomeDesign ON Products.ProductID = ProductParentHomeDesign.ChildProductID AND ProductParentHomeDesign.Type = 'Home' LEFT OUTER JOIN Products AS ProductVariationHomeDesign ON ProductParentHomeDesign.ParentProductID = ProductVariationHomeDesign.ProductID AND ProductVariationHomeDesign.ProductType = 'Home' LEFT OUTER JOIN Documents AS ProductImage_home ON ProductVariationHomeDesign.Image = ProductImage_home.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage_home ON ProductVariationHomeDesign.ThumbnailImage = ProductThumbnailImage_home.DocumentID LEFT OUTER JOIN ProductVariations AS ProductParentHomeRange ON ProductVariationHomeDesign.ProductID = ProductParentHomeRange.ChildProductID AND ProductParentHomeRange.Type = 'Home Range' LEFT OUTER JOIN Products AS ProductVariationHomeRange ON ProductParentHomeRange.ParentProductID = ProductVariationHomeRange.ProductID AND ProductVariationHomeRange.ProductType = 'Home Range' LEFT OUTER JOIN ProductVariations AS ProductParentBrandRange ON ProductVariationHomeRange.ProductID = ProductParentBrandRange.ChildProductID AND ProductParentBrandRange.Type = 'Brand' LEFT OUTER JOIN Products AS ProductVariationBrandRange ON ProductParentBrandRange.ParentProductID = ProductVariationBrandRange.ProductID AND ProductVariationBrandRange.ProductType = 'Brand' LEFT OUTER JOIN ProductVariations AS ProductParentBuilderBrand ON ProductVariationBrandRange.ProductID = ProductParentBuilderBrand.ChildProductID AND ProductParentBuilderBrand.Type = 'Builder' LEFT OUTER JOIN Products AS ProductVariationBuilderBrand ON ProductParentBuilderBrand.ParentProductID = ProductVariationBuilderBrand.ProductID AND ProductVariationBuilderBrand.ProductType = 'Builder' WHERE Products.ProductType = 'Home Plan' AND Products.Active = 'Y' AND ProductVariationHomeDesign.ProductID = '0T1K46888V26326Z14370V3N8C7F' AND ((Products.Category <> 'PlanSale') OR (Products.Category IS NULL)) ORDER BY Products.Name /* */ null Database Error at org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:549) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:593) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:530) at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954) at org.apache.jsp.cms.websites.jgking.includes.formats.standard_005fformat_jsp._jspx_meth_c_005fif_005f1(standard_005fformat_jsp.java:478) at org.apache.jsp.cms.websites.jgking.includes.formats.standard_005fformat_jsp._jspService(standard_005fformat_jsp.java:393) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:593) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:530) at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954) at org.apache.jsp.cms.websites.index_jsp._jspService(index_jsp.java:200) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.sok.runway.URLFilter.doFilter(URLFilter.java:146) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: com.sok.framework.generation.DatabaseException: com.sok.framework.generation.DatabaseException: SELECT Products.ProductID, Products.Name, Products.ProductNum, Products.Description, Products.Summary, Products.Category, Products.BaseCost, Products.Margin, Products.Cost, Products.GST, Products.TotalCost, Products.CreatedDate, Products.CreatedBy, Products.ModifiedDate, Products.DripModifiedDate, Products.ModifiedBy, Products.ProductGroupID, Products.CopiedFromProductID, Products.Image, Products.ThumbnailImage, Products.ProductDetails, Products.Active, Products.VariablePrice, Products.StockLevel, Products.ProductType, Products.ProductSubType, Products.PricingType, Products.GSTExempt, Products.BaseCost AS EditBaseCost, Products.Margin*100 AS DisplayMargin, Products.Cost AS EditCost, Products.GST AS EditGST, Products.TotalCost AS EditTotalCost, Products.GroupID, Products.AvailableDate, Products.ExpiryDate, Products.SupplierCompanyID, Products.ProductStatusID, Products.LocationID, Products.RegionID, Products.ProductRating, Products.UpdateByProcess, Products.Stage, Products.URL, Products.PublishDescription, Products.DripCost, Products.DripResult, Products.HomeSummary, Products.PublishHomeDescription, Products.Name AS PlanName, Products.DisplayPriceType, Products.DisplayPrice, ProductHomeDetails.Bedrooms AS Bedrooms, ProductHomeDetails.Bathrooms AS Bathrooms, ProductHomeDetails.HomeSize AS HomeSize, ProductHomeDetails.HomeSizeSq AS HomeSizeSq, ProductHomeDetails.LotWidth AS LotWidth, ProductHomeDetails.LotDepth AS LotDepth, ProductHomeDetails.Garage AS Garage, ProductHomeDetails.Study AS Study, ProductHomeDetails.LivingRooms AS LivingRooms, ProductHomeDetails.Dimensions AS Dimensions, ProductHomeDetails.CarParks AS CarParks, ProductHomeDetails.CanFitOnDepth AS CanFitOnDepth, ProductHomeDetails.CanFitOnFrontage AS CanFitOnFrontage, ProductHomeDetails.WillFitHouseSize AS WillFitHouseSize, ProductHomeDetails.Storey AS Storey, ProductHomeDetails.GroundFloorArea AS GroundFloorArea, ProductHomeDetails.FirstFloorWindows AS FirstFloorWindows, ProductHomeDetails.EavesFacade AS EavesFacade, ProductHomeDetails.EavesGround AS EavesGround, ProductHomeDetails.EavesFirst AS EavesFirst, ProductHomeDetails.Media AS Media, ProductHomeDetails.Orientation AS Orientation, ProductGroup.SectionCode AS SectionCode, ProductProductGroup.GroupName AS GroupName, ProductGroup.Name AS SecurityGroupName, ProductModified.FirstName AS ModFirstName, ProductModified.LastName AS ModLastName, ProductCreated.FirstName AS OwnFirstName, ProductCreated.LastName AS OwnLastName, ProductImage.FileName AS ImageName, ProductImage.FilePath AS ImagePath, ProductImage.Description AS ImageDescription, ProductThumbnailImage.FileName AS ThumbnailImageName, ProductThumbnailImage.FilePath AS ThumbnailImagePath, ProductSupplierCompany.Company AS SupplierCompany, ProductStatusList.StatusID AS CurrentStatusID, ProductStatusList.Status AS CurrentStatus, ProductStatusList.StatusValue AS CurrentStatusValue, ProductVariationHomeDesign.Name AS HomeName, ProductVariationHomeDesign.ShowOnPortalFlag AS HomeShowOnPortalFlag, ProductVariationHomeDesign.ProductNum AS HomeProductNum, ProductVariationHomeDesign.Image AS HomeImage, ProductImage_home.FilePath AS HomeImagePath, ProductVariationHomeDesign.ThumbnailImage AS HomeThumbnailImage, ProductThumbnailImage_home.FilePath AS HomeThumbnailPath, ProductVariationHomeDesign.PreAvailableDate AS HomePreAvailableDate, ProductVariationHomeDesign.AvailableDate AS HomeAvailableDate, ProductVariationHomeDesign.ProductID AS HomeProductID, ProductVariationHomeRange.Name AS RangeName, ProductVariationHomeRange.ShowOnPortalFlag AS RangeShowOnPortalFlag, ProductVariationHomeRange.RangeColorHex AS RangeColorHex, ProductVariationHomeRange.ProductNum AS RangeProductNum, ProductVariationHomeRange.ProductID AS RangeProductID, ProductVariationBrandRange.ProductID AS BrandProductID, ProductVariationBrandRange.Name AS BrandName, ProductVariationBuilderBrand.ProductID AS BuilderProductID, ProductVariationBuilderBrand.Name AS BuilderName FROM Products LEFT OUTER JOIN HomeDetails AS ProductHomeDetails ON Products.ProductID = ProductHomeDetails.ProductID LEFT OUTER JOIN Groups AS ProductGroup ON Products.GroupID = ProductGroup.GroupID LEFT OUTER JOIN ProductGroups AS ProductProductGroup ON Products.ProductGroupID = ProductProductGroup.ProductGroupID LEFT OUTER JOIN Users AS ProductModified ON Products.ModifiedBy = ProductModified.UserID LEFT OUTER JOIN Users AS ProductCreated ON Products.CreatedBy = ProductCreated.UserID LEFT OUTER JOIN Documents AS ProductImage ON Products.Image = ProductImage.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage ON Products.ThumbnailImage = ProductThumbnailImage.DocumentID LEFT OUTER JOIN Companies AS ProductSupplierCompany ON Products.SupplierCompanyID = ProductSupplierCompany.CompanyID LEFT OUTER JOIN ProductStatus AS ProductCurrentStatus ON Products.ProductStatusID = ProductCurrentStatus.ProductStatusID LEFT OUTER JOIN StatusList AS ProductStatusList ON ProductCurrentStatus.StatusID = ProductStatusList.StatusID LEFT OUTER JOIN ProductVariations AS ProductParentHomeDesign ON Products.ProductID = ProductParentHomeDesign.ChildProductID AND ProductParentHomeDesign.Type = 'Home' LEFT OUTER JOIN Products AS ProductVariationHomeDesign ON ProductParentHomeDesign.ParentProductID = ProductVariationHomeDesign.ProductID AND ProductVariationHomeDesign.ProductType = 'Home' LEFT OUTER JOIN Documents AS ProductImage_home ON ProductVariationHomeDesign.Image = ProductImage_home.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage_home ON ProductVariationHomeDesign.ThumbnailImage = ProductThumbnailImage_home.DocumentID LEFT OUTER JOIN ProductVariations AS ProductParentHomeRange ON ProductVariationHomeDesign.ProductID = ProductParentHomeRange.ChildProductID AND ProductParentHomeRange.Type = 'Home Range' LEFT OUTER JOIN Products AS ProductVariationHomeRange ON ProductParentHomeRange.ParentProductID = ProductVariationHomeRange.ProductID AND ProductVariationHomeRange.ProductType = 'Home Range' LEFT OUTER JOIN ProductVariations AS ProductParentBrandRange ON ProductVariationHomeRange.ProductID = ProductParentBrandRange.ChildProductID AND ProductParentBrandRange.Type = 'Brand' LEFT OUTER JOIN Products AS ProductVariationBrandRange ON ProductParentBrandRange.ParentProductID = ProductVariationBrandRange.ProductID AND ProductVariationBrandRange.ProductType = 'Brand' LEFT OUTER JOIN ProductVariations AS ProductParentBuilderBrand ON ProductVariationBrandRange.ProductID = ProductParentBuilderBrand.ChildProductID AND ProductParentBuilderBrand.Type = 'Builder' LEFT OUTER JOIN Products AS ProductVariationBuilderBrand ON ProductParentBuilderBrand.ParentProductID = ProductVariationBuilderBrand.ProductID AND ProductVariationBuilderBrand.ProductType = 'Builder' WHERE Products.ProductType = 'Home Plan' AND Products.Active = 'Y' AND ProductVariationHomeDesign.ProductID = '0T1K46888V26326Z14370V3N8C7F' AND ((Products.Category <> 'PlanSale') OR (Products.Category IS NULL)) ORDER BY Products.Name /* */ null Database Error at com.sok.framework.generation.Rows.getResults(Rows.java:85) at com.sok.framework.generation.Rows.getResults(Rows.java:97) at org.apache.jsp.cms.websites.jgking.includes.pages.home_005fdetails_jsp._jspService(home_005fdetails_jsp.java:182) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) ... 53 more Caused by: com.sok.framework.generation.DatabaseException: SELECT Products.ProductID, Products.Name, Products.ProductNum, Products.Description, Products.Summary, Products.Category, Products.BaseCost, Products.Margin, Products.Cost, Products.GST, Products.TotalCost, Products.CreatedDate, Products.CreatedBy, Products.ModifiedDate, Products.DripModifiedDate, Products.ModifiedBy, Products.ProductGroupID, Products.CopiedFromProductID, Products.Image, Products.ThumbnailImage, Products.ProductDetails, Products.Active, Products.VariablePrice, Products.StockLevel, Products.ProductType, Products.ProductSubType, Products.PricingType, Products.GSTExempt, Products.BaseCost AS EditBaseCost, Products.Margin*100 AS DisplayMargin, Products.Cost AS EditCost, Products.GST AS EditGST, Products.TotalCost AS EditTotalCost, Products.GroupID, Products.AvailableDate, Products.ExpiryDate, Products.SupplierCompanyID, Products.ProductStatusID, Products.LocationID, Products.RegionID, Products.ProductRating, Products.UpdateByProcess, Products.Stage, Products.URL, Products.PublishDescription, Products.DripCost, Products.DripResult, Products.HomeSummary, Products.PublishHomeDescription, Products.Name AS PlanName, Products.DisplayPriceType, Products.DisplayPrice, ProductHomeDetails.Bedrooms AS Bedrooms, ProductHomeDetails.Bathrooms AS Bathrooms, ProductHomeDetails.HomeSize AS HomeSize, ProductHomeDetails.HomeSizeSq AS HomeSizeSq, ProductHomeDetails.LotWidth AS LotWidth, ProductHomeDetails.LotDepth AS LotDepth, ProductHomeDetails.Garage AS Garage, ProductHomeDetails.Study AS Study, ProductHomeDetails.LivingRooms AS LivingRooms, ProductHomeDetails.Dimensions AS Dimensions, ProductHomeDetails.CarParks AS CarParks, ProductHomeDetails.CanFitOnDepth AS CanFitOnDepth, ProductHomeDetails.CanFitOnFrontage AS CanFitOnFrontage, ProductHomeDetails.WillFitHouseSize AS WillFitHouseSize, ProductHomeDetails.Storey AS Storey, ProductHomeDetails.GroundFloorArea AS GroundFloorArea, ProductHomeDetails.FirstFloorWindows AS FirstFloorWindows, ProductHomeDetails.EavesFacade AS EavesFacade, ProductHomeDetails.EavesGround AS EavesGround, ProductHomeDetails.EavesFirst AS EavesFirst, ProductHomeDetails.Media AS Media, ProductHomeDetails.Orientation AS Orientation, ProductGroup.SectionCode AS SectionCode, ProductProductGroup.GroupName AS GroupName, ProductGroup.Name AS SecurityGroupName, ProductModified.FirstName AS ModFirstName, ProductModified.LastName AS ModLastName, ProductCreated.FirstName AS OwnFirstName, ProductCreated.LastName AS OwnLastName, ProductImage.FileName AS ImageName, ProductImage.FilePath AS ImagePath, ProductImage.Description AS ImageDescription, ProductThumbnailImage.FileName AS ThumbnailImageName, ProductThumbnailImage.FilePath AS ThumbnailImagePath, ProductSupplierCompany.Company AS SupplierCompany, ProductStatusList.StatusID AS CurrentStatusID, ProductStatusList.Status AS CurrentStatus, ProductStatusList.StatusValue AS CurrentStatusValue, ProductVariationHomeDesign.Name AS HomeName, ProductVariationHomeDesign.ShowOnPortalFlag AS HomeShowOnPortalFlag, ProductVariationHomeDesign.ProductNum AS HomeProductNum, ProductVariationHomeDesign.Image AS HomeImage, ProductImage_home.FilePath AS HomeImagePath, ProductVariationHomeDesign.ThumbnailImage AS HomeThumbnailImage, ProductThumbnailImage_home.FilePath AS HomeThumbnailPath, ProductVariationHomeDesign.PreAvailableDate AS HomePreAvailableDate, ProductVariationHomeDesign.AvailableDate AS HomeAvailableDate, ProductVariationHomeDesign.ProductID AS HomeProductID, ProductVariationHomeRange.Name AS RangeName, ProductVariationHomeRange.ShowOnPortalFlag AS RangeShowOnPortalFlag, ProductVariationHomeRange.RangeColorHex AS RangeColorHex, ProductVariationHomeRange.ProductNum AS RangeProductNum, ProductVariationHomeRange.ProductID AS RangeProductID, ProductVariationBrandRange.ProductID AS BrandProductID, ProductVariationBrandRange.Name AS BrandName, ProductVariationBuilderBrand.ProductID AS BuilderProductID, ProductVariationBuilderBrand.Name AS BuilderName FROM Products LEFT OUTER JOIN HomeDetails AS ProductHomeDetails ON Products.ProductID = ProductHomeDetails.ProductID LEFT OUTER JOIN Groups AS ProductGroup ON Products.GroupID = ProductGroup.GroupID LEFT OUTER JOIN ProductGroups AS ProductProductGroup ON Products.ProductGroupID = ProductProductGroup.ProductGroupID LEFT OUTER JOIN Users AS ProductModified ON Products.ModifiedBy = ProductModified.UserID LEFT OUTER JOIN Users AS ProductCreated ON Products.CreatedBy = ProductCreated.UserID LEFT OUTER JOIN Documents AS ProductImage ON Products.Image = ProductImage.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage ON Products.ThumbnailImage = ProductThumbnailImage.DocumentID LEFT OUTER JOIN Companies AS ProductSupplierCompany ON Products.SupplierCompanyID = ProductSupplierCompany.CompanyID LEFT OUTER JOIN ProductStatus AS ProductCurrentStatus ON Products.ProductStatusID = ProductCurrentStatus.ProductStatusID LEFT OUTER JOIN StatusList AS ProductStatusList ON ProductCurrentStatus.StatusID = ProductStatusList.StatusID LEFT OUTER JOIN ProductVariations AS ProductParentHomeDesign ON Products.ProductID = ProductParentHomeDesign.ChildProductID AND ProductParentHomeDesign.Type = 'Home' LEFT OUTER JOIN Products AS ProductVariationHomeDesign ON ProductParentHomeDesign.ParentProductID = ProductVariationHomeDesign.ProductID AND ProductVariationHomeDesign.ProductType = 'Home' LEFT OUTER JOIN Documents AS ProductImage_home ON ProductVariationHomeDesign.Image = ProductImage_home.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage_home ON ProductVariationHomeDesign.ThumbnailImage = ProductThumbnailImage_home.DocumentID LEFT OUTER JOIN ProductVariations AS ProductParentHomeRange ON ProductVariationHomeDesign.ProductID = ProductParentHomeRange.ChildProductID AND ProductParentHomeRange.Type = 'Home Range' LEFT OUTER JOIN Products AS ProductVariationHomeRange ON ProductParentHomeRange.ParentProductID = ProductVariationHomeRange.ProductID AND ProductVariationHomeRange.ProductType = 'Home Range' LEFT OUTER JOIN ProductVariations AS ProductParentBrandRange ON ProductVariationHomeRange.ProductID = ProductParentBrandRange.ChildProductID AND ProductParentBrandRange.Type = 'Brand' LEFT OUTER JOIN Products AS ProductVariationBrandRange ON ProductParentBrandRange.ParentProductID = ProductVariationBrandRange.ProductID AND ProductVariationBrandRange.ProductType = 'Brand' LEFT OUTER JOIN ProductVariations AS ProductParentBuilderBrand ON ProductVariationBrandRange.ProductID = ProductParentBuilderBrand.ChildProductID AND ProductParentBuilderBrand.Type = 'Builder' LEFT OUTER JOIN Products AS ProductVariationBuilderBrand ON ProductParentBuilderBrand.ParentProductID = ProductVariationBuilderBrand.ProductID AND ProductVariationBuilderBrand.ProductType = 'Builder' WHERE Products.ProductType = 'Home Plan' AND Products.Active = 'Y' AND ProductVariationHomeDesign.ProductID = '0T1K46888V26326Z14370V3N8C7F' AND ((Products.Category <> 'PlanSale') OR (Products.Category IS NULL)) ORDER BY Products.Name /* */ null at com.sok.framework.generation.DatabaseFactory.retrieveResultSet(DatabaseFactory.java:471) at com.sok.framework.generation.Rows.getResults(Rows.java:71) ... 58 more Caused by: java.sql.SQLException: Got error 28 from storage engine at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at com.sok.framework.generation.DatabaseFactory.retrieveResultSet(DatabaseFactory.java:465) ... 59 more Caused By.. com.sok.framework.generation.DatabaseException: com.sok.framework.generation.DatabaseException: SELECT Products.ProductID, Products.Name, Products.ProductNum, Products.Description, Products.Summary, Products.Category, Products.BaseCost, Products.Margin, Products.Cost, Products.GST, Products.TotalCost, Products.CreatedDate, Products.CreatedBy, Products.ModifiedDate, Products.DripModifiedDate, Products.ModifiedBy, Products.ProductGroupID, Products.CopiedFromProductID, Products.Image, Products.ThumbnailImage, Products.ProductDetails, Products.Active, Products.VariablePrice, Products.StockLevel, Products.ProductType, Products.ProductSubType, Products.PricingType, Products.GSTExempt, Products.BaseCost AS EditBaseCost, Products.Margin*100 AS DisplayMargin, Products.Cost AS EditCost, Products.GST AS EditGST, Products.TotalCost AS EditTotalCost, Products.GroupID, Products.AvailableDate, Products.ExpiryDate, Products.SupplierCompanyID, Products.ProductStatusID, Products.LocationID, Products.RegionID, Products.ProductRating, Products.UpdateByProcess, Products.Stage, Products.URL, Products.PublishDescription, Products.DripCost, Products.DripResult, Products.HomeSummary, Products.PublishHomeDescription, Products.Name AS PlanName, Products.DisplayPriceType, Products.DisplayPrice, ProductHomeDetails.Bedrooms AS Bedrooms, ProductHomeDetails.Bathrooms AS Bathrooms, ProductHomeDetails.HomeSize AS HomeSize, ProductHomeDetails.HomeSizeSq AS HomeSizeSq, ProductHomeDetails.LotWidth AS LotWidth, ProductHomeDetails.LotDepth AS LotDepth, ProductHomeDetails.Garage AS Garage, ProductHomeDetails.Study AS Study, ProductHomeDetails.LivingRooms AS LivingRooms, ProductHomeDetails.Dimensions AS Dimensions, ProductHomeDetails.CarParks AS CarParks, ProductHomeDetails.CanFitOnDepth AS CanFitOnDepth, ProductHomeDetails.CanFitOnFrontage AS CanFitOnFrontage, ProductHomeDetails.WillFitHouseSize AS WillFitHouseSize, ProductHomeDetails.Storey AS Storey, ProductHomeDetails.GroundFloorArea AS GroundFloorArea, ProductHomeDetails.FirstFloorWindows AS FirstFloorWindows, ProductHomeDetails.EavesFacade AS EavesFacade, ProductHomeDetails.EavesGround AS EavesGround, ProductHomeDetails.EavesFirst AS EavesFirst, ProductHomeDetails.Media AS Media, ProductHomeDetails.Orientation AS Orientation, ProductGroup.SectionCode AS SectionCode, ProductProductGroup.GroupName AS GroupName, ProductGroup.Name AS SecurityGroupName, ProductModified.FirstName AS ModFirstName, ProductModified.LastName AS ModLastName, ProductCreated.FirstName AS OwnFirstName, ProductCreated.LastName AS OwnLastName, ProductImage.FileName AS ImageName, ProductImage.FilePath AS ImagePath, ProductImage.Description AS ImageDescription, ProductThumbnailImage.FileName AS ThumbnailImageName, ProductThumbnailImage.FilePath AS ThumbnailImagePath, ProductSupplierCompany.Company AS SupplierCompany, ProductStatusList.StatusID AS CurrentStatusID, ProductStatusList.Status AS CurrentStatus, ProductStatusList.StatusValue AS CurrentStatusValue, ProductVariationHomeDesign.Name AS HomeName, ProductVariationHomeDesign.ShowOnPortalFlag AS HomeShowOnPortalFlag, ProductVariationHomeDesign.ProductNum AS HomeProductNum, ProductVariationHomeDesign.Image AS HomeImage, ProductImage_home.FilePath AS HomeImagePath, ProductVariationHomeDesign.ThumbnailImage AS HomeThumbnailImage, ProductThumbnailImage_home.FilePath AS HomeThumbnailPath, ProductVariationHomeDesign.PreAvailableDate AS HomePreAvailableDate, ProductVariationHomeDesign.AvailableDate AS HomeAvailableDate, ProductVariationHomeDesign.ProductID AS HomeProductID, ProductVariationHomeRange.Name AS RangeName, ProductVariationHomeRange.ShowOnPortalFlag AS RangeShowOnPortalFlag, ProductVariationHomeRange.RangeColorHex AS RangeColorHex, ProductVariationHomeRange.ProductNum AS RangeProductNum, ProductVariationHomeRange.ProductID AS RangeProductID, ProductVariationBrandRange.ProductID AS BrandProductID, ProductVariationBrandRange.Name AS BrandName, ProductVariationBuilderBrand.ProductID AS BuilderProductID, ProductVariationBuilderBrand.Name AS BuilderName FROM Products LEFT OUTER JOIN HomeDetails AS ProductHomeDetails ON Products.ProductID = ProductHomeDetails.ProductID LEFT OUTER JOIN Groups AS ProductGroup ON Products.GroupID = ProductGroup.GroupID LEFT OUTER JOIN ProductGroups AS ProductProductGroup ON Products.ProductGroupID = ProductProductGroup.ProductGroupID LEFT OUTER JOIN Users AS ProductModified ON Products.ModifiedBy = ProductModified.UserID LEFT OUTER JOIN Users AS ProductCreated ON Products.CreatedBy = ProductCreated.UserID LEFT OUTER JOIN Documents AS ProductImage ON Products.Image = ProductImage.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage ON Products.ThumbnailImage = ProductThumbnailImage.DocumentID LEFT OUTER JOIN Companies AS ProductSupplierCompany ON Products.SupplierCompanyID = ProductSupplierCompany.CompanyID LEFT OUTER JOIN ProductStatus AS ProductCurrentStatus ON Products.ProductStatusID = ProductCurrentStatus.ProductStatusID LEFT OUTER JOIN StatusList AS ProductStatusList ON ProductCurrentStatus.StatusID = ProductStatusList.StatusID LEFT OUTER JOIN ProductVariations AS ProductParentHomeDesign ON Products.ProductID = ProductParentHomeDesign.ChildProductID AND ProductParentHomeDesign.Type = 'Home' LEFT OUTER JOIN Products AS ProductVariationHomeDesign ON ProductParentHomeDesign.ParentProductID = ProductVariationHomeDesign.ProductID AND ProductVariationHomeDesign.ProductType = 'Home' LEFT OUTER JOIN Documents AS ProductImage_home ON ProductVariationHomeDesign.Image = ProductImage_home.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage_home ON ProductVariationHomeDesign.ThumbnailImage = ProductThumbnailImage_home.DocumentID LEFT OUTER JOIN ProductVariations AS ProductParentHomeRange ON ProductVariationHomeDesign.ProductID = ProductParentHomeRange.ChildProductID AND ProductParentHomeRange.Type = 'Home Range' LEFT OUTER JOIN Products AS ProductVariationHomeRange ON ProductParentHomeRange.ParentProductID = ProductVariationHomeRange.ProductID AND ProductVariationHomeRange.ProductType = 'Home Range' LEFT OUTER JOIN ProductVariations AS ProductParentBrandRange ON ProductVariationHomeRange.ProductID = ProductParentBrandRange.ChildProductID AND ProductParentBrandRange.Type = 'Brand' LEFT OUTER JOIN Products AS ProductVariationBrandRange ON ProductParentBrandRange.ParentProductID = ProductVariationBrandRange.ProductID AND ProductVariationBrandRange.ProductType = 'Brand' LEFT OUTER JOIN ProductVariations AS ProductParentBuilderBrand ON ProductVariationBrandRange.ProductID = ProductParentBuilderBrand.ChildProductID AND ProductParentBuilderBrand.Type = 'Builder' LEFT OUTER JOIN Products AS ProductVariationBuilderBrand ON ProductParentBuilderBrand.ParentProductID = ProductVariationBuilderBrand.ProductID AND ProductVariationBuilderBrand.ProductType = 'Builder' WHERE Products.ProductType = 'Home Plan' AND Products.Active = 'Y' AND ProductVariationHomeDesign.ProductID = '0T1K46888V26326Z14370V3N8C7F' AND ((Products.Category <> 'PlanSale') OR (Products.Category IS NULL)) ORDER BY Products.Name /* */ null Database Error at com.sok.framework.generation.Rows.getResults(Rows.java:85) at com.sok.framework.generation.Rows.getResults(Rows.java:97) at org.apache.jsp.cms.websites.jgking.includes.pages.home_005fdetails_jsp._jspService(home_005fdetails_jsp.java:182) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:593) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:530) at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954) at org.apache.jsp.cms.websites.jgking.includes.formats.standard_005fformat_jsp._jspx_meth_c_005fif_005f1(standard_005fformat_jsp.java:478) at org.apache.jsp.cms.websites.jgking.includes.formats.standard_005fformat_jsp._jspService(standard_005fformat_jsp.java:393) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:593) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:530) at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954) at org.apache.jsp.cms.websites.index_jsp._jspService(index_jsp.java:200) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.sok.runway.URLFilter.doFilter(URLFilter.java:146) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: com.sok.framework.generation.DatabaseException: SELECT Products.ProductID, Products.Name, Products.ProductNum, Products.Description, Products.Summary, Products.Category, Products.BaseCost, Products.Margin, Products.Cost, Products.GST, Products.TotalCost, Products.CreatedDate, Products.CreatedBy, Products.ModifiedDate, Products.DripModifiedDate, Products.ModifiedBy, Products.ProductGroupID, Products.CopiedFromProductID, Products.Image, Products.ThumbnailImage, Products.ProductDetails, Products.Active, Products.VariablePrice, Products.StockLevel, Products.ProductType, Products.ProductSubType, Products.PricingType, Products.GSTExempt, Products.BaseCost AS EditBaseCost, Products.Margin*100 AS DisplayMargin, Products.Cost AS EditCost, Products.GST AS EditGST, Products.TotalCost AS EditTotalCost, Products.GroupID, Products.AvailableDate, Products.ExpiryDate, Products.SupplierCompanyID, Products.ProductStatusID, Products.LocationID, Products.RegionID, Products.ProductRating, Products.UpdateByProcess, Products.Stage, Products.URL, Products.PublishDescription, Products.DripCost, Products.DripResult, Products.HomeSummary, Products.PublishHomeDescription, Products.Name AS PlanName, Products.DisplayPriceType, Products.DisplayPrice, ProductHomeDetails.Bedrooms AS Bedrooms, ProductHomeDetails.Bathrooms AS Bathrooms, ProductHomeDetails.HomeSize AS HomeSize, ProductHomeDetails.HomeSizeSq AS HomeSizeSq, ProductHomeDetails.LotWidth AS LotWidth, ProductHomeDetails.LotDepth AS LotDepth, ProductHomeDetails.Garage AS Garage, ProductHomeDetails.Study AS Study, ProductHomeDetails.LivingRooms AS LivingRooms, ProductHomeDetails.Dimensions AS Dimensions, ProductHomeDetails.CarParks AS CarParks, ProductHomeDetails.CanFitOnDepth AS CanFitOnDepth, ProductHomeDetails.CanFitOnFrontage AS CanFitOnFrontage, ProductHomeDetails.WillFitHouseSize AS WillFitHouseSize, ProductHomeDetails.Storey AS Storey, ProductHomeDetails.GroundFloorArea AS GroundFloorArea, ProductHomeDetails.FirstFloorWindows AS FirstFloorWindows, ProductHomeDetails.EavesFacade AS EavesFacade, ProductHomeDetails.EavesGround AS EavesGround, ProductHomeDetails.EavesFirst AS EavesFirst, ProductHomeDetails.Media AS Media, ProductHomeDetails.Orientation AS Orientation, ProductGroup.SectionCode AS SectionCode, ProductProductGroup.GroupName AS GroupName, ProductGroup.Name AS SecurityGroupName, ProductModified.FirstName AS ModFirstName, ProductModified.LastName AS ModLastName, ProductCreated.FirstName AS OwnFirstName, ProductCreated.LastName AS OwnLastName, ProductImage.FileName AS ImageName, ProductImage.FilePath AS ImagePath, ProductImage.Description AS ImageDescription, ProductThumbnailImage.FileName AS ThumbnailImageName, ProductThumbnailImage.FilePath AS ThumbnailImagePath, ProductSupplierCompany.Company AS SupplierCompany, ProductStatusList.StatusID AS CurrentStatusID, ProductStatusList.Status AS CurrentStatus, ProductStatusList.StatusValue AS CurrentStatusValue, ProductVariationHomeDesign.Name AS HomeName, ProductVariationHomeDesign.ShowOnPortalFlag AS HomeShowOnPortalFlag, ProductVariationHomeDesign.ProductNum AS HomeProductNum, ProductVariationHomeDesign.Image AS HomeImage, ProductImage_home.FilePath AS HomeImagePath, ProductVariationHomeDesign.ThumbnailImage AS HomeThumbnailImage, ProductThumbnailImage_home.FilePath AS HomeThumbnailPath, ProductVariationHomeDesign.PreAvailableDate AS HomePreAvailableDate, ProductVariationHomeDesign.AvailableDate AS HomeAvailableDate, ProductVariationHomeDesign.ProductID AS HomeProductID, ProductVariationHomeRange.Name AS RangeName, ProductVariationHomeRange.ShowOnPortalFlag AS RangeShowOnPortalFlag, ProductVariationHomeRange.RangeColorHex AS RangeColorHex, ProductVariationHomeRange.ProductNum AS RangeProductNum, ProductVariationHomeRange.ProductID AS RangeProductID, ProductVariationBrandRange.ProductID AS BrandProductID, ProductVariationBrandRange.Name AS BrandName, ProductVariationBuilderBrand.ProductID AS BuilderProductID, ProductVariationBuilderBrand.Name AS BuilderName FROM Products LEFT OUTER JOIN HomeDetails AS ProductHomeDetails ON Products.ProductID = ProductHomeDetails.ProductID LEFT OUTER JOIN Groups AS ProductGroup ON Products.GroupID = ProductGroup.GroupID LEFT OUTER JOIN ProductGroups AS ProductProductGroup ON Products.ProductGroupID = ProductProductGroup.ProductGroupID LEFT OUTER JOIN Users AS ProductModified ON Products.ModifiedBy = ProductModified.UserID LEFT OUTER JOIN Users AS ProductCreated ON Products.CreatedBy = ProductCreated.UserID LEFT OUTER JOIN Documents AS ProductImage ON Products.Image = ProductImage.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage ON Products.ThumbnailImage = ProductThumbnailImage.DocumentID LEFT OUTER JOIN Companies AS ProductSupplierCompany ON Products.SupplierCompanyID = ProductSupplierCompany.CompanyID LEFT OUTER JOIN ProductStatus AS ProductCurrentStatus ON Products.ProductStatusID = ProductCurrentStatus.ProductStatusID LEFT OUTER JOIN StatusList AS ProductStatusList ON ProductCurrentStatus.StatusID = ProductStatusList.StatusID LEFT OUTER JOIN ProductVariations AS ProductParentHomeDesign ON Products.ProductID = ProductParentHomeDesign.ChildProductID AND ProductParentHomeDesign.Type = 'Home' LEFT OUTER JOIN Products AS ProductVariationHomeDesign ON ProductParentHomeDesign.ParentProductID = ProductVariationHomeDesign.ProductID AND ProductVariationHomeDesign.ProductType = 'Home' LEFT OUTER JOIN Documents AS ProductImage_home ON ProductVariationHomeDesign.Image = ProductImage_home.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage_home ON ProductVariationHomeDesign.ThumbnailImage = ProductThumbnailImage_home.DocumentID LEFT OUTER JOIN ProductVariations AS ProductParentHomeRange ON ProductVariationHomeDesign.ProductID = ProductParentHomeRange.ChildProductID AND ProductParentHomeRange.Type = 'Home Range' LEFT OUTER JOIN Products AS ProductVariationHomeRange ON ProductParentHomeRange.ParentProductID = ProductVariationHomeRange.ProductID AND ProductVariationHomeRange.ProductType = 'Home Range' LEFT OUTER JOIN ProductVariations AS ProductParentBrandRange ON ProductVariationHomeRange.ProductID = ProductParentBrandRange.ChildProductID AND ProductParentBrandRange.Type = 'Brand' LEFT OUTER JOIN Products AS ProductVariationBrandRange ON ProductParentBrandRange.ParentProductID = ProductVariationBrandRange.ProductID AND ProductVariationBrandRange.ProductType = 'Brand' LEFT OUTER JOIN ProductVariations AS ProductParentBuilderBrand ON ProductVariationBrandRange.ProductID = ProductParentBuilderBrand.ChildProductID AND ProductParentBuilderBrand.Type = 'Builder' LEFT OUTER JOIN Products AS ProductVariationBuilderBrand ON ProductParentBuilderBrand.ParentProductID = ProductVariationBuilderBrand.ProductID AND ProductVariationBuilderBrand.ProductType = 'Builder' WHERE Products.ProductType = 'Home Plan' AND Products.Active = 'Y' AND ProductVariationHomeDesign.ProductID = '0T1K46888V26326Z14370V3N8C7F' AND ((Products.Category <> 'PlanSale') OR (Products.Category IS NULL)) ORDER BY Products.Name /* */ null at com.sok.framework.generation.DatabaseFactory.retrieveResultSet(DatabaseFactory.java:471) at com.sok.framework.generation.Rows.getResults(Rows.java:71) ... 58 more Caused by: java.sql.SQLException: Got error 28 from storage engine at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at com.sok.framework.generation.DatabaseFactory.retrieveResultSet(DatabaseFactory.java:465) ... 59 more Caused By.. com.sok.framework.generation.DatabaseException: SELECT Products.ProductID, Products.Name, Products.ProductNum, Products.Description, Products.Summary, Products.Category, Products.BaseCost, Products.Margin, Products.Cost, Products.GST, Products.TotalCost, Products.CreatedDate, Products.CreatedBy, Products.ModifiedDate, Products.DripModifiedDate, Products.ModifiedBy, Products.ProductGroupID, Products.CopiedFromProductID, Products.Image, Products.ThumbnailImage, Products.ProductDetails, Products.Active, Products.VariablePrice, Products.StockLevel, Products.ProductType, Products.ProductSubType, Products.PricingType, Products.GSTExempt, Products.BaseCost AS EditBaseCost, Products.Margin*100 AS DisplayMargin, Products.Cost AS EditCost, Products.GST AS EditGST, Products.TotalCost AS EditTotalCost, Products.GroupID, Products.AvailableDate, Products.ExpiryDate, Products.SupplierCompanyID, Products.ProductStatusID, Products.LocationID, Products.RegionID, Products.ProductRating, Products.UpdateByProcess, Products.Stage, Products.URL, Products.PublishDescription, Products.DripCost, Products.DripResult, Products.HomeSummary, Products.PublishHomeDescription, Products.Name AS PlanName, Products.DisplayPriceType, Products.DisplayPrice, ProductHomeDetails.Bedrooms AS Bedrooms, ProductHomeDetails.Bathrooms AS Bathrooms, ProductHomeDetails.HomeSize AS HomeSize, ProductHomeDetails.HomeSizeSq AS HomeSizeSq, ProductHomeDetails.LotWidth AS LotWidth, ProductHomeDetails.LotDepth AS LotDepth, ProductHomeDetails.Garage AS Garage, ProductHomeDetails.Study AS Study, ProductHomeDetails.LivingRooms AS LivingRooms, ProductHomeDetails.Dimensions AS Dimensions, ProductHomeDetails.CarParks AS CarParks, ProductHomeDetails.CanFitOnDepth AS CanFitOnDepth, ProductHomeDetails.CanFitOnFrontage AS CanFitOnFrontage, ProductHomeDetails.WillFitHouseSize AS WillFitHouseSize, ProductHomeDetails.Storey AS Storey, ProductHomeDetails.GroundFloorArea AS GroundFloorArea, ProductHomeDetails.FirstFloorWindows AS FirstFloorWindows, ProductHomeDetails.EavesFacade AS EavesFacade, ProductHomeDetails.EavesGround AS EavesGround, ProductHomeDetails.EavesFirst AS EavesFirst, ProductHomeDetails.Media AS Media, ProductHomeDetails.Orientation AS Orientation, ProductGroup.SectionCode AS SectionCode, ProductProductGroup.GroupName AS GroupName, ProductGroup.Name AS SecurityGroupName, ProductModified.FirstName AS ModFirstName, ProductModified.LastName AS ModLastName, ProductCreated.FirstName AS OwnFirstName, ProductCreated.LastName AS OwnLastName, ProductImage.FileName AS ImageName, ProductImage.FilePath AS ImagePath, ProductImage.Description AS ImageDescription, ProductThumbnailImage.FileName AS ThumbnailImageName, ProductThumbnailImage.FilePath AS ThumbnailImagePath, ProductSupplierCompany.Company AS SupplierCompany, ProductStatusList.StatusID AS CurrentStatusID, ProductStatusList.Status AS CurrentStatus, ProductStatusList.StatusValue AS CurrentStatusValue, ProductVariationHomeDesign.Name AS HomeName, ProductVariationHomeDesign.ShowOnPortalFlag AS HomeShowOnPortalFlag, ProductVariationHomeDesign.ProductNum AS HomeProductNum, ProductVariationHomeDesign.Image AS HomeImage, ProductImage_home.FilePath AS HomeImagePath, ProductVariationHomeDesign.ThumbnailImage AS HomeThumbnailImage, ProductThumbnailImage_home.FilePath AS HomeThumbnailPath, ProductVariationHomeDesign.PreAvailableDate AS HomePreAvailableDate, ProductVariationHomeDesign.AvailableDate AS HomeAvailableDate, ProductVariationHomeDesign.ProductID AS HomeProductID, ProductVariationHomeRange.Name AS RangeName, ProductVariationHomeRange.ShowOnPortalFlag AS RangeShowOnPortalFlag, ProductVariationHomeRange.RangeColorHex AS RangeColorHex, ProductVariationHomeRange.ProductNum AS RangeProductNum, ProductVariationHomeRange.ProductID AS RangeProductID, ProductVariationBrandRange.ProductID AS BrandProductID, ProductVariationBrandRange.Name AS BrandName, ProductVariationBuilderBrand.ProductID AS BuilderProductID, ProductVariationBuilderBrand.Name AS BuilderName FROM Products LEFT OUTER JOIN HomeDetails AS ProductHomeDetails ON Products.ProductID = ProductHomeDetails.ProductID LEFT OUTER JOIN Groups AS ProductGroup ON Products.GroupID = ProductGroup.GroupID LEFT OUTER JOIN ProductGroups AS ProductProductGroup ON Products.ProductGroupID = ProductProductGroup.ProductGroupID LEFT OUTER JOIN Users AS ProductModified ON Products.ModifiedBy = ProductModified.UserID LEFT OUTER JOIN Users AS ProductCreated ON Products.CreatedBy = ProductCreated.UserID LEFT OUTER JOIN Documents AS ProductImage ON Products.Image = ProductImage.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage ON Products.ThumbnailImage = ProductThumbnailImage.DocumentID LEFT OUTER JOIN Companies AS ProductSupplierCompany ON Products.SupplierCompanyID = ProductSupplierCompany.CompanyID LEFT OUTER JOIN ProductStatus AS ProductCurrentStatus ON Products.ProductStatusID = ProductCurrentStatus.ProductStatusID LEFT OUTER JOIN StatusList AS ProductStatusList ON ProductCurrentStatus.StatusID = ProductStatusList.StatusID LEFT OUTER JOIN ProductVariations AS ProductParentHomeDesign ON Products.ProductID = ProductParentHomeDesign.ChildProductID AND ProductParentHomeDesign.Type = 'Home' LEFT OUTER JOIN Products AS ProductVariationHomeDesign ON ProductParentHomeDesign.ParentProductID = ProductVariationHomeDesign.ProductID AND ProductVariationHomeDesign.ProductType = 'Home' LEFT OUTER JOIN Documents AS ProductImage_home ON ProductVariationHomeDesign.Image = ProductImage_home.DocumentID LEFT OUTER JOIN Documents AS ProductThumbnailImage_home ON ProductVariationHomeDesign.ThumbnailImage = ProductThumbnailImage_home.DocumentID LEFT OUTER JOIN ProductVariations AS ProductParentHomeRange ON ProductVariationHomeDesign.ProductID = ProductParentHomeRange.ChildProductID AND ProductParentHomeRange.Type = 'Home Range' LEFT OUTER JOIN Products AS ProductVariationHomeRange ON ProductParentHomeRange.ParentProductID = ProductVariationHomeRange.ProductID AND ProductVariationHomeRange.ProductType = 'Home Range' LEFT OUTER JOIN ProductVariations AS ProductParentBrandRange ON ProductVariationHomeRange.ProductID = ProductParentBrandRange.ChildProductID AND ProductParentBrandRange.Type = 'Brand' LEFT OUTER JOIN Products AS ProductVariationBrandRange ON ProductParentBrandRange.ParentProductID = ProductVariationBrandRange.ProductID AND ProductVariationBrandRange.ProductType = 'Brand' LEFT OUTER JOIN ProductVariations AS ProductParentBuilderBrand ON ProductVariationBrandRange.ProductID = ProductParentBuilderBrand.ChildProductID AND ProductParentBuilderBrand.Type = 'Builder' LEFT OUTER JOIN Products AS ProductVariationBuilderBrand ON ProductParentBuilderBrand.ParentProductID = ProductVariationBuilderBrand.ProductID AND ProductVariationBuilderBrand.ProductType = 'Builder' WHERE Products.ProductType = 'Home Plan' AND Products.Active = 'Y' AND ProductVariationHomeDesign.ProductID = '0T1K46888V26326Z14370V3N8C7F' AND ((Products.Category <> 'PlanSale') OR (Products.Category IS NULL)) ORDER BY Products.Name /* */ null at com.sok.framework.generation.DatabaseFactory.retrieveResultSet(DatabaseFactory.java:471) at com.sok.framework.generation.Rows.getResults(Rows.java:71) at com.sok.framework.generation.Rows.getResults(Rows.java:97) at org.apache.jsp.cms.websites.jgking.includes.pages.home_005fdetails_jsp._jspService(home_005fdetails_jsp.java:182) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:593) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:530) at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954) at org.apache.jsp.cms.websites.jgking.includes.formats.standard_005fformat_jsp._jspx_meth_c_005fif_005f1(standard_005fformat_jsp.java:478) at org.apache.jsp.cms.websites.jgking.includes.formats.standard_005fformat_jsp._jspService(standard_005fformat_jsp.java:393) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:593) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:530) at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954) at org.apache.jsp.cms.websites.index_jsp._jspService(index_jsp.java:200) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.sok.runway.URLFilter.doFilter(URLFilter.java:146) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: Got error 28 from storage engine at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at com.sok.framework.generation.DatabaseFactory.retrieveResultSet(DatabaseFactory.java:465) ... 59 more Caused By.. java.sql.SQLException: Got error 28 from storage engine at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2444) at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) at com.sok.framework.generation.DatabaseFactory.retrieveResultSet(DatabaseFactory.java:465) at com.sok.framework.generation.Rows.getResults(Rows.java:71) at com.sok.framework.generation.Rows.getResults(Rows.java:97) at org.apache.jsp.cms.websites.jgking.includes.pages.home_005fdetails_jsp._jspService(home_005fdetails_jsp.java:182) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:593) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:530) at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954) at org.apache.jsp.cms.websites.jgking.includes.formats.standard_005fformat_jsp._jspx_meth_c_005fif_005f1(standard_005fformat_jsp.java:478) at org.apache.jsp.cms.websites.jgking.includes.formats.standard_005fformat_jsp._jspService(standard_005fformat_jsp.java:393) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:593) at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:530) at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:954) at org.apache.jsp.cms.websites.index_jsp._jspService(index_jsp.java:200) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:684) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:471) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:402) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:329) at com.sok.runway.URLFilter.doFilter(URLFilter.java:146) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745)