[Geoserver-devel] [jira] Created: (GEOS-4205) Error when querying data from SQL (com.vividsolutions.jts.io.ParseException: Expected number but found '(' )

Error when querying data from SQL (com.vividsolutions.jts.io.ParseException: Expected number but found '(' )
------------------------------------------------------------------------------------------------------------

                 Key: GEOS-4205
                 URL: http://jira.codehaus.org/browse/GEOS-4205
             Project: GeoServer
          Issue Type: Bug
          Components: SQLServer
    Affects Versions: 2.1-beta1
         Environment: gt-jdbc-sqlserver-2.7-SNAPSHOT.jar (revision 36307)
sqljdbc4.jar
SQL Server 2008 R2
Java 1.6
Windows 2003
            Reporter: Lazarev Eugene
            Assignee: Andrea Aime
         Attachments: 000F000006D6.sql, 2010_11_01.request.log, wrapper.log

when trying to render layer there are an error

Caused by: com.vividsolutions.jts.io.ParseException: Expected number but found '('
  at com.vividsolutions.jts.io.WKTReader.parseError(WKTReader.java:383)
  at com.vividsolutions.jts.io.WKTReader.getNextNumber(WKTReader.java:281)
  at com.vividsolutions.jts.io.WKTReader.getPreciseCoordinate(WKTReader.java:235)
   at com.vividsolutions.jts.io.WKTReader.getCoordinates(WKTReader.java:221)
  at com.vividsolutions.jts.io.WKTReader.readMultiPointText(WKTReader.java:517)
   at com.vividsolutions.jts.io.WKTReader.readGeometryTaggedText(WKTReader.java:440)
   at com.vividsolutions.jts.io.WKTReader.read(WKTReader.java:194)
   at com.vividsolutions.jts.io.WKTReader.read(WKTReader.java:163)
  at org.geotools.data.sqlserver.SQLServerDialect.decodeGeometry(SQLServerDialect.java:232)
  ...

it is very strange because data stores in geometry column and if we suppose wrong data, so it can't be stored in table when inserted
other layers that stored similar render great.

this is occurs also in WFS queries

you can try data in test server http://svn.ugi.ru:1580/geoserver
Login admin
Pass geoserver

http://svn.ugi.ru:1580/geoserver/wms?service=WMS&version=1.1.0&request=GetMap&layers=opengis:layer_000F000006D6&styles=&bbox=16527.551,16012.965,60888.83,124489.411&width=209&height=512&srs=EPSG:2536&format=application/openlayers

--
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