[
http://mifosforge.jira.com/browse/MIFOSDEPLOY-166?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ramya Toshniwal resolved MIFOSDEPLOY-166.
-----------------------------------------
Resolution: Fixed
The connection pool issue has been resolved.Following is the anlysis of this
issue.
This all I found out through net about this error.
http://forums.pentaho.com/showthread.php?62003-Please-explain-how-to-create-subreport-from-reporting-designer
1. This is a well-known well-hated MySQL issue. When creating a connection,
make sure you append the connection-parameter
"holdResultsOpenOverStatementClose" and set it to true.
jdbc:mysql://localhost/sampledata?holdResultsOpenOverStatementClose=true
Without the parameter, MySQL closes the resultset for the master report as soon
as we try to fire the query for the first subreport. This driver behavior is
against the JDBC specs, but database vendors all over the world have committed
atrocities much worse than that.
And
There ia a bug locked for the same logs you are getting at your end
http://jira.pentaho.com/browse/PRD-1465?page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#issue-tabs
As per this, whenever there is a MYSQL connection in both main and sub report.
The report fails at the first query of first sub-report. This is what happening
in your case too. So finally what I did I have added each and every query in
main report only and inherited the same in the sub-reports. Just giving you the
details section and total (footer) section missing in this report. Just check
and let me know if you are still facing the same error.
Please check on your designer first.
> Running Loan and CBU Ledger is triggering issue with connections
> ----------------------------------------------------------------
>
> Key: MIFOSDEPLOY-166
> URL: http://mifosforge.jira.com/browse/MIFOSDEPLOY-166
> Project: mifos deployments
> Issue Type: Bug
> Components: Reporting
> Reporter: Ryan Whitney
> Assignee: Ramya Toshniwal
> Priority: Blocker
> Attachments: Error from Pentaho Designer.log
>
>
> Trying to run the loan and cbu ledger keeps triggering an issue with the
> connections timing out.
> MAX Connections on server is set to 500
> Tried setting max connections on JNDI connection to 100 and 200, still
> getting the issue.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://mifosforge.jira.com/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Mifos-issues mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mifos-issues
