[OpenLayers-Users] How to display PostGIS data through Openlayers and JSP

[George Matt]

Hi all,

Is it possible to show postgis data in openlayers?

If yes can some body points me to some links or upload a working example to 
illustrate.

A usecase can be:
Consider a road table (road_id, geom, road_name) in the postgre/postgis 
database. In SQL the select statement can be [SELECT road_id, 
ST_AsText(road_geom) AS geom, road_name FROM roads;] to select all the roads. 
Now how to give it to openlayers to show them on the map.


Thanks,
--
Matt


      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/openlayers-users/attachments/20100724/d42b6cb6/attachment.html