Jrxml Report Error

Posted on February 4, 2016 at 10:45pm

Hi ,

 I have run the query the query will execuated in PRIMARY DATABASE. But the same query i have to Run in Secondary Database that time below error is accored . How to solve the problem

 

Caused by: org.postgresql.util.PSQLException: ERROR: canceling statement due to conflict with recovery
  Detail: User query might have needed to see row versions that must be removed.
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)
    at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233)

iReport Designer
mcpuram's picture
mcpuram
3
Joined: May 3 2015 - 11:07pm
Last seen: 5 years 1 month ago

1 Answer:

Posted on February 7, 2016 at 12:43pm

Not sure about your question, but there's no such thing as PRIMARY database and SECONDARY database in JasperReports. Run both sql statement in one database.

hozawa's picture
hozawa
190337
Joined: Apr 24 2010 - 4:31pm
Last seen: 4 years 3 months ago
Feedback