SQL Exception in filltoReport

[2005 IR Help]

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