[Geoserver-users] Viewing Oracle data in GeoServer-OpenLayers

Hello,

Absolutely new to Geo-Server and I am in here to evaluate how good its performance and stability when compared to other mapping engines available. In this process I am trying to load large Oracle data (around 750K polygon records) via a layer/Feature. The connection to Oracle 11G is fine and the OpenLayers viewer even shows the attributes at the bottom when clicked on the map. But I can’t see any polygons on the viewer?! I have populated the Oracle geometry object with the SRS of 28355 and GeoServer admin picks these values correctly and after around 10-15 mins. it generates the ‘Bounding Box” correctly.

I am struck here and not sure how to proceed further. Any suggestions to move forward would be highly appreciated. FYI, the spatial indexes also exist in the database.

Best regards,

Praveen

Hi Praveen,

If wfs requests are resulting fine the wms requests should too.
The featureType SLD you’re applying is a default one that comes with
Geoserver or you built a new one? If so, try to apply a default one in the
wms request, maybe the default_polygon.sld (polygon fill set to #AAAAAA and
stroke to black with 1 pixel width) or capitals (you’ll see circles instead
of the polygon geometries).

Hope this helps,
Pedro Mendes

Praveen-22 wrote:

Hello,
     Absolutely new to Geo-Server and I am in here to evaluate how good
its performance and stability when compared to other mapping engines
available. In this process I am trying to load large Oracle data (around
750K polygon records) via a layer/Feature. The connection to Oracle 11G is
fine and the OpenLayers viewer even shows the attributes at the bottom
when clicked on the map. But I can't see any polygons on the viewer?! I
have populated the Oracle geometry object with the SRS of 28355 and
GeoServer admin picks these values correctly and after around 10-15 mins.
it generates the 'Bounding Box" correctly.
     I am struck here and not sure how to proceed further. Any suggestions
to move forward would be highly appreciated. FYI, the spatial indexes also
exist in the database.

Best regards,
Praveen

------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
View this message in context: http://www.nabble.com/Viewing-Oracle-data-in-GeoServer-OpenLayers-tp21489559p21496353.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

Thanks for your response, Pedro.

I am using the “polygon” SLD which came along with Geoserver. No changes done. I can’t see a “default_polygon” as part off the “Additional Styles” listbox?

The WMS URL request is:

http://ossup1:8080/geoserver/wms?bbox=261094.19701362215,5785552.355577179,332702.2716097879,5845206.345511841&styles=&Format=application/openlayers&request=GetMap&version=1.1.1&layers=CWW:CWW_PARCEL&width=800&height=625&srs=EPSG:28355

Anything else can I try?!

Thanks and regards,

Praveen

From: Pedro Mendes [mailto:pmendes@anonymised.com]
Sent: Friday, 16 January 2009 9:18 PM
To: Praveen Rajendra Babu
Subject: RE: [Geoserver-users] Viewing Oracle data in GeoServer-OpenLayers

Hi Praveen,

If wfs requests are resulting fine the wms requests should too.

The featureType SLD you’re applying is a default one that comes with Geoserver or you built a new one? If so, try to apply a default one in the wms request, maybe the default_polygon.sld (polygon fill set to #AAAAAA and stroke to black with 1 pixel width) or capitals (you’ll see circles instead of the polygon geometries).

Hope this helps,

Pedro Mendes

De: Praveen Rajendra Babu [mailto:prbabu@anonymised.com]
Enviada: quinta-feira, 15 de Janeiro de 2009 23:38
Para: geoserver-users@lists.sourceforge.net
Assunto: [Geoserver-users] Viewing Oracle data in GeoServer-OpenLayers

Hello,

Absolutely new to Geo-Server and I am in here to evaluate how good its performance and stability when compared to other mapping engines available. In this process I am trying to load large Oracle data (around 750K polygon records) via a layer/Feature. The connection to Oracle 11G is fine and the OpenLayers viewer even shows the attributes at the bottom when clicked on the map. But I can’t see any polygons on the viewer?! I have populated the Oracle geometry object with the SRS of 28355 and GeoServer admin picks these values correctly and after around 10-15 mins. it generates the ‘Bounding Box” correctly.

I am struck here and not sure how to proceed further. Any suggestions to move forward would be highly appreciated. FYI, the spatial indexes also exist in the database.

Best regards,

Praveen