Id/Fid filter can geneate invalid SQL on Oracle
-----------------------------------------------
Key: GEOT-1213
URL: http://jira.codehaus.org/browse/GEOT-1213
Project: GeoTools
Issue Type: Bug
Components: data arcsde
Reporter: Shaun Forbes
Assigned To: Gabriel Roldán
When generating the where clause for an Id filter (or Fid filter on older
releases) the default is to generate an IN clause that just lists all of the
supplied ids, but Oracle can have problems processing an IN clause that
contains more than 1000 ids.
A option could be to break the clause into multiple IN sections and join then
with an OR.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Geotools-devel mailing list
Geotools-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
