Nested table in BIRT opens too meny db cursors, causing cursor error
Asked 1 month ago
Modified 2 days ago
Viewed 174
times
Asked By Kishore B Buchepalli
0
Im designing a report in BIRT, where I have 2 data sets and one parent table and under that a child table. For each parent row, I'm firing child table, so it's hitting database everytime. For example if I'm having 100 rows of parent records, for each I'm processing child table. So child table query is executed 100 times. Thus 100 cursors are opened, and after 4/5 runs I'm getting maximum cursor open error. Is there any better approach ?
Answers
0
Which version of BIRT are you using? Maybe you are hitting a bug:
https://github.com/eclipse/birt/issues/875
This was fixed in March 2022.
Answered by Sai Kishore 1 month ago
Your Answer
Please login to join the live discussion.
Latest Topics
💬 0 Answers • 👁️
1506 Views
💬 0 Answers • 👁️
136 Views
💬 0 Answers • 👁️
169 Views
💬 0 Answers • 👁️
213 Views
💬 0 Answers • 👁️
182 Views
