Hi,
We're currently running geoserver 1.7.6 to produce WFS and WMS from various sources. I'm hoping to add the ability to do WFS from a plain non-spatial database table (Oracle or SQL Server) that includes fields with x and y coordinates but no actual geometry object ... no SDE or Oracle Spatial involved. I've read about the geometryless/locationsxy work in geotools that it seems never made it to supported status. And I see in the previous generation of docs that this can be accomplished with the "community schemas" build of 1.6 that Rob Atkinson has put up. But we moved up to 1.7 because we were having trouble with 1.6 giving us slow performance accessing ArcSDE. I also see that "community schemas" has morphed into app-schemas and become an official extension in 2.0. But I don't see in the present iteration of the docs anything about the geometryless part. So, the following questions:
Is it possible using 2.0 and the app-schemas extension to produce a WFS from a geometryless data store? (And if so, I'd love any pointers as to how to accomplish that in terms of configuration language. I do have 2.0-rc1 installed and running with the extension, but I'm kind of at sea in terms of putting together the configuration for the data store.)
If not, what would it take for me to add the geometryless data store capability into 1.7.6? Just build it with some additional code? (Again, pointers as to how would be very welcome, which extra code to grab, how to plug it into the build, and how to configure the data store.)
If both of those turn out to be too difficult, I suppose I will just grab the community schemas war file and run a separate instance just for the geometryless tables, and continue using 1.7.6 for everything else.)
I appreciate any help! Thanks.
-Andy Rowan
NJ Office of GIS