Jump to content
Changes to the Jaspersoft community edition download ×

SQL Exception in filltoReport


2005 IR Help

Recommended Posts

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

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...