[jboss-jira] [JBoss JIRA] Closed: (JBCACHE-987) Deleting a large tree from JDBC creates too many expressions for Oracle

[Manik Surtani (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBCACHE-987?page=all ]

Manik Surtani closed JBCACHE-987.
---------------------------------

    Fix Version/s: 2.0.0.BETA1
                   2.0.0.GA
       Resolution: Done

>From BETA1 onwards, the JDBCCacheLoader has been substantially rewritten (by Mircea Markus) mainly to flatten out recursion which does a lot to improve performance (no more recursive JDBC calls!)

As a part of this rewrite, this "too many expressions" problem has been fixed as well.

> Deleting a large tree from JDBC creates too many expressions for Oracle
> -----------------------------------------------------------------------
>
>                 Key: JBCACHE-987
>                 URL: http://jira.jboss.com/jira/browse/JBCACHE-987
>             Project: JBoss Cache
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>    Affects Versions: 2.0.0.ALPHA2
>            Reporter: Elias Ross
>         Assigned To: Manik Surtani
>             Fix For: 2.0.0.BETA1, 2.0.0.GA
>
>
> User sees "ORA-01795: maximum number of expressions in a list is 1000".
> Maybe this is fixed in a more recent version?

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira