Dear developers!<br><br>I'm trying to read project annotations from the annotation table. There are many large text annotations to single projects, in total they could become a few MB and I ran into Ice::MemoryLimitExceptions. I tried to only load the link definition and loop through the list on the application level in order to fetch single annotations. The code in Python is similar to this:<br>
<br> query = '''<br> select pal from ProjectAnnotationLink pal<br> left join pal.parent p<br> where <a href="http://p.id">p.id</a> = %i''' % projectId<br><br> annotationLinks = queryService.findAllByQuery(query, None)<br>
<br> for link in annotationLinks:<br> query = '''<br> select pal from ProjectAnnotationLink pal<br> left join fetch pal.child a<br> left outer join fetch a.details.creationEvent<br>
where <a href="http://pal.id">pal.id</a> = %i''' % link.id.val<br> l = self.querys.findByQuery(query, None)<br> yield l.child<br><br>However, I still get an Ice::MemoryLimitExcpetion during the execution of the first query. Is this expected, how can I avoid this? Changing the Ice.MessageSizeMax property to large values (several MB) didn't solve the problem.<br>
<br>Thanks for help! Bernhard<br>