Re: [Ebxmlrr-tech] Too many cursors errors

[Farrukh N. <far...@su...>]

Andy Nauli wrote:

>Hi ebxml users,
>
>After inserting hundreds of nodes into the
>Registry, I am starting to get too many cursors
>Open or maximum cursors exceeded error in
>The catalina.out when I performed the queries
>
>Any idea why such thing happened ?
>
>We are using oracle and the latest build 2.1.beta-3
>
We found that Oracle driver required more explicit closing of cursors 
than PostgreSQL. Fixes were committed to CVS post 2.1beta3. Is it 
possible for you to try latest CVS bits and report back on the findings?

>
>Also how scalable is the ebxml registry for handling
>Large number of objects ?
>
>  
>
No testing has been done for scalability. The main scalability issue we 
are aware of is in signing a very large request (e.g. loadUNSPS target). 
The issue there is in some wierd ineffciency is the Apache xmlsec.jar or 
one of its dependencies. The workaround to that problem is to submit 
large requests in chunks.

-- 
Farrukh