GeoServer's KML implementation (and everything else) is implemented in terms
of the GeoTools DataStore and FeatureCollection API; it doesn't really work
on ResultSets directly. Similarly, GeoServer is not a library, it's an
application, so cases like yours aren't really at the forefront of
developers' minds when designing GeoServer modules.
If you would like to use the GeoServer KML code, you will probably have to
hack it apart. Perhaps ou could try to write an adapter to make a ResultSet
look like a GeoTools FeatureCollection, or modify the code to work on a
ResultSet instead of a Feature. The code is
at
http://svn.codehaus.org/geoserver/trunk/src/wms/src/main/java/org/geoserver/kml/.
Note it is GPL licensed so if you distribute a modified copy you are
obligated to distribute the sources as well.
Good luck.
--
David Winslow
OpenGeo - http://opengeo.org/
On Mon, Feb 7, 2011 at 9:43 AM, Darrell Berry <[email protected]> wrote:
> Just to clarify -- I guess I really just want to use whatever libraries are
> available from geoserver to render PostGis queries -> KML.
>
> SImple as that. OR should I be looking elsewhere (other than GeoServer?!)
>
> D
>
> On 7 Feb 2011, at 14:05, Darrell Berry wrote:
>
> > Hi -- I'm not quite sure if this falls into he Users or Developers list,
> so if this is the wrong place, please let me know!
> >
> > I have an existing Java-based web service app (POJO via Axis2 on Tomcat)
> which now needs some geospatial data rendered up to a web client as WMS (in
> fact as KML)
> >
> > I've had a look at the docs and there looks to be a pretty serious
> learning curve to get from the GeoServer tutorial samples to a working
> service.
> >
> > I'm looking for a tutorial app which demonstrates the minimum I need to
> do to go in Java from a JDBC PostGIS ResultSet of geodata to a working WMS
> layer I can return to my client. GIven that I already have a working
> webservice, I'd prefer to be using geoservre libraries to acces the PostGIS
> backend and produce the response, than have to build an actual Geoserver
> plugin, but I'm not sure if that's even an option? I am, as you can probably
> tell, a Geoserver newbie...
> >
> > My desired wrokflow looks like this:
> >
> > 1. My webclient interacts with my service. The webclient doesn't send a
> geospatial query, but other data from which the backend needs to compute a
> geospatial response
> >
> > 2. As a result, in my webservice backend, I'm computing, for example
> >
> > SELECT ST_AsText(roads_geom) AS geom
> > FROM roads
> > WHERE
> > roads_geom && SetSRID('BOX3D(191232 243117,191232 243119)'::box3d,-1);
> >
> > and getting that back as a JDBC ResultSet.
> >
> > 3. I then need the results of THAT query returned to the calling web
> service as KML.
> >
> > SImple, yes?
> >
> > All help appreciated. This feels like a FAQ, but if it is, I'm obviously
> looking in the wrong places!
> >
> > Thanks
> >
> > D
> >
> >
> >
> >
> >
> ------------------------------------------------------------------------------
> > The modern datacenter depends on network connectivity to access resources
> > and provide services. The best practices for maximizing a physical
> server's
> > connectivity to a physical network are well understood - see how these
> > rules translate into the virtual world?
> > http://p.sf.net/sfu/oracle-sfdevnlfb
> > _______________________________________________
> > Geoserver-users mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/geoserver-users
> >
>
>
>
> ------------------------------------------------------------------------------
> The modern datacenter depends on network connectivity to access resources
> and provide services. The best practices for maximizing a physical server's
> connectivity to a physical network are well understood - see how these
> rules translate into the virtual world?
> http://p.sf.net/sfu/oracle-sfdevnlfb
> _______________________________________________
> Geoserver-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
------------------------------------------------------------------------------
The modern datacenter depends on network connectivity to access resources
and provide services. The best practices for maximizing a physical server's
connectivity to a physical network are well understood - see how these
rules translate into the virtual world?
http://p.sf.net/sfu/oracle-sfdevnlfb
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
