2005 IR Help Posted August 26, 2006 Share Posted August 26, 2006 By: Anitha - y_anitha SQL Exception in filltoReport 2004-04-11 21:25 Hai! I Have written an application similar to the web application which is shown in the demo samples. This was working fine on Windows OS and Oracle database. But when i tried the same example on Linux with PostgreSQL Database, it is throwing SQL Exception. Iam attaching the trace of the exception. The database defined and the attributes used in the Java function are case sensitive and correct. Please help at the earliest. Regards, Anitha ====================================== Exception Trace: ====================================== java.sql.SQLException: ERROR: Attribute "city" not found at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131) at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:153) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:454) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:140) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:108) at com.pramati.jsp.generated.jsp_p2f_generate_pmt_0._jspService(jsp_p2f_generate_pmt_0.java:117) at com.pramati.jsp.runtime.HttpJspSuper.service(HttpJspSuper.java:81) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.pramati.web.interceptors.ServiceInterceptor$ServiceAction.run(ServiceInterceptor.java:199) at com.pramati.security.util.JAASSecurityHelper.doAs(JAASSecurityHelper.java:148) at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.pramati.services.security.spi.SecurityHelper.doAs(SecurityHelper.java:133) at com.pramati.web.interceptors.ServiceInterceptor.preProcess(ServiceInterceptor.java:122) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:48) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:49) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.FilterInterceptor.process(FilterInterceptor.java:106) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:49) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:49) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:49) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:49) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultProcessContainer.process(DefaultProcessContainer.java:92) at com.pramati.web.core.WorkerThread.run(WorkerThread.java:69) at com.pramati.web.core.AcceptorThread.run(AcceptorThread.java:200) NESTED BY : java.sql.SQLException: ERROR: Attribute "city" not found at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131) at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:153) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:454) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:140) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:108) at com.pramati.jsp.generated.jsp_p2f_generate_pmt_0._jspService(jsp_p2f_generate_pmt_0.java:117) at com.pramati.jsp.runtime.HttpJspSuper.service(HttpJspSuper.java:81) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.pramati.web.interceptors.ServiceInterceptor$ServiceAction.run(ServiceInterceptor.java:199) at com.pramati.security.util.JAASSecurityHelper.doAs(JAASSecurityHelper.java:148) at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.pramati.services.security.spi.SecurityHelper.doAs(SecurityHelper.java:133) at com.pramati.web.interceptors.ServiceInterceptor.preProcess(ServiceInterceptor.java:122) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:48) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:49) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.FilterInterceptor.process(FilterInterceptor.java:106) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:49) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:49) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:49) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:49) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultProcessContainer.process(DefaultProcessContainer.java:92) at com.pramati.web.core.WorkerThread.run(WorkerThread.java:69) at com.pramati.web.core.AcceptorThread.run(AcceptorThread.java:200) NESTED BY : dori.jasper.engine.JRException: Error executing SQL statement for report : WebappReport at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:463) at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119) at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:140) at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:108) at com.pramati.jsp.generated.jsp_p2f_generate_pmt_0._jspService(jsp_p2f_generate_pmt_0.java:117) at com.pramati.jsp.runtime.HttpJspSuper.service(HttpJspSuper.java:81) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at com.pramati.web.interceptors.ServiceInterceptor$ServiceAction.run(ServiceInterceptor.java:199) at com.pramati.security.util.JAASSecurityHelper.doAs(JAASSecurityHelper.java:148) at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:324) at com.pramati.services.security.spi.SecurityHelper.doAs(SecurityHelper.java:133) at com.pramati.web.interceptors.ServiceInterceptor.preProcess(ServiceInterceptor.java:122) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:48) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:49) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.FilterInterceptor.process(FilterInterceptor.java:106) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:49) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:49) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:49) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultInterceptor.process(DefaultInterceptor.java:49) at com.pramati.web.interceptors.core.InterceptorChainImpl.processNext(InterceptorChainImpl.java:48) at com.pramati.web.interceptors.core.DefaultProcessContainer.process(DefaultProcessContainer.java:92) at com.pramati.web.core.WorkerThread.run(WorkerThread.java:69) at com.pramati.web.core.AcceptorThread.run(AcceptorThread.java:200) Caused by: java.sql.SQLException: ERROR: Attribute "city" not found at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131) at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48) at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:153) at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:454) ... 31 more Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now