[Geotools-devel] [jira] (GEOT-4194) Bad indexOf on applyLimitOffset in SQLServerDialect.java

Thu, 05 Jul 2012 15:53:46 -0700

Issue Type: Bug Bug
Affects Versions: 2.7.5
Assignee: Unassigned
Components: jdbc-sqlserver plugin
Created: 05/Jul/12 5:53 PM
Description:

Line 354 of SQLServerDialect.java

int fromStart = sql.indexOf("FROM");

is causing problems in queries containing valid column names that include the "FROM" string (eg. SG_DATEFROM). A sample exception message is

<?xml version="1.0" ?>
<ServiceExceptionReport
version="1.2.0"
xmlns="
http://www.opengis.net/ogc
"
xmlns:xsi="
http://www.w3.org/2001/XMLSchema-instance
"
xsi:schemaLocation="
http://www.opengis.net/ogc http://schemas.opengis.net/wfs/1.0.0/OGC-exception.xsd
">
<ServiceException>
java.lang.RuntimeException: java.io.IOException
java.io.IOException
null
El nombre de columna 'SG_DAT, ROW_NUMBER() OVER (ORDER BY CURRENT_TIMESTAMP) AS _GT_ROW_NUMBER EFROM' no es v�lido.
</ServiceException></ServiceExceptionReport>
Project: GeoTools
Priority: Critical Critical
Reporter: Esteban Picone
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators.
For more information on JIRA, see: http://www.atlassian.com/software/jira 
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
GeoTools-Devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Reply via email to