http://dev.helma.org/bugs/show_bug.cgi?id=664 Summary: prefetching lots of nodes hits oracle IN-list maximum
Product: Helma
Version: CVS trunk
Platform: Other
OS/Version: Linux
Status: NEW
Severity: enhancement
Priority: P5
Component: Database Layer
AssignedTo:
helma-dev@...
ReportedBy:
nostalgiker@...
collection.list(0,2000) throws this error against oracle
[2009/05/12 12:22:43] [ERROR] [ws2fm4-1] Error in prefetchNodes()
java.sql.SQLException: ORA-01795: maximum number of expressions in a list is
1000
query triggering the error:
{{{
SQL SELECT_PREFETCH T_COMMENT 427: SELECT T_COMMENT.* FROM T_COMMENT WHERE
T_COMMENT.CMT_ID in (51002840, .... <cut very long list >)
}}}
the internet tells me that the error message is wrong for earlier versions of
oracle. i tested with oracle10 and list(0,1000) really was the highest working
value.
--
Configure bugmail:
http://dev.helma.org/bugs/userprefs.cgi?tab=email------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Helma-dev mailing list
Helma-dev@...
http://helma.org/mailman/listinfo/helma-dev
