David and I have been e-mailing about this over the weekend. What I was able to narrow it down to was that as soon as you add a Filter to the a postgis layer, things seem to go wrong and you start getting the messages about expecting an int and got a string and the fields not mapping correctly.
I do a have a very small postgis table and sld file that I can post if necessary to reproduce the problem.
-----Original Message-----
From: geoserver-devel-admin@lists.sourceforge.net [mailto:geoserver-devel-admin@lists.sourceforge.net] On Behalf Of Jody Garnett
Sent: Monday, April 25, 2005 9:38 AM
To: Artie Konin
Cc: Gabriel Roldán; geoserver-devel@lists.sourceforge.net
Subject: Re: [Geoserver-devel] Troubles with PostGIS DataStore???
Artie Konin wrote:
Greetings, Gabriel,
tripped and compiled into table that will look like this:
area perimeter city_ city_id code
shp | 2.718921E11 | 2208942.0 | 3 | 374 | 2 |
postgis | 2.0 | 2.718921E11 | 2208942 | 3 | 374 |So in the second case there is no single correct attribute value,
(they are shifted one position to the right) though when I look at the
PostgreSQL table itself all values are in place.
Opps I take it back, that has nothing to do with Filter
GeoServer does maintain a separate wrapper which is used to ensure correct attribute order with the schena irrespective of column order on the back end database.
I wonder if something has gone wrong with respect to that? that would be my next suspect if this problem is limited to GeoServer.
Perhaps you need to autogenerate youe xml schema again? (I am thinking a schema leftover from shapefile is trying to be used with postgis?)
Good luck,
Jody
-------------------------------------------------------
SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel