SQL Syntax Error when using IncludeFilter or ExcludeFilter
----------------------------------------------------------
Key: GEOT-1992
URL: http://jira.codehaus.org/browse/GEOT-1992
Project: GeoTools
Issue Type: Bug
Components: data db2
Affects Versions: 2.5-RC0, 2.6-M0
Reporter: Christian Mueller
DB2SqlEncoder has no methods handling IncludeFilter and ExcludeFilter. This
results in Sql Statements using
"WHERE FALSE"
"WHERE TRUE"
Solution:
Add 2 Methods
@Override
public Object visit(ExcludeFilter filter, Object extraData) {
try {
out.write("1=0");
} catch (java.io.IOException ioe) {};
return extraData;
}
@Override
public Object visit(IncludeFilter filter, Object extraData) {
try {
out.write("1=1");
} catch (java.io.IOException ioe) {};
return extraData;
}
which result in
"WHERE 1=1"
"WHERE 0=1"
--
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
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geotools-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel
