Hi Jukka,
Thanks for the detailed response. I will look into your suggestions,
esp. tracking down the SQL queries. I was trying to find out is there any
sort of limitation of geoserver in rendering some sort of curved lines
represented as SDO_GEOMETRY 2002(lines), which is what I could see missing.
Regards,
Praveen
On Wed, Nov 27, 2013 at 6:41 PM, Rahkonen Jukka
<jukka.rahko...@mmmtike.fi>wrote:
> Hi,
>
>
>
> It is impossible to say what happens by this information. I would begin
> by capturing the SQL select that is used for reading data from Oracle and
> studying that. You should be able to find it from Geoserver logs if you set
> the logging level to “geotools developer”. Or then the Oracle admin can
> gather and send log data for you. When you have the SQL in your hands,
> send it with SQL developer, SQL Plus or whatever tools you are using and
> check if all the linestrings get selected. If yes, you can consider that
> the data side is OK. If some lines are not selected, select the geometries
> by a handwritten SQL and try to find what is special in those. Check at
> least if the geometry type and SRID are the same as for other geometries.
>
>
>
> If SQL selects all that you want to render then there can be something in
> the rendering rules that makes that some features are not painted even they
> are selected.
>
>
>
> There are often some oddities in real world data. I would suggest to
> import first some simple demo datasets into your Oracle and play first with
> them. Once you can render them nicely you will trust that Geoserver works
> and you will be generally on a much better mood for facing the possible
> troubles with your own data.
>
> When importing the demo data try to keep things simple:
>
> - Have a primary key in a column of type NUMBER
>
> - Don’t forget to insert a valid row into USER_SDO_GEOM_METADATA
>
> - Create a spatial index
>
>
>
> -Jukka Rahkonen-
>
>
>
> Praveen Rajendra Babu wrote:
>
>
>
> Hi,
>
> Absolutely new to GeoServer, but finding it very interesting by
> comparing to other map servers.
>
> I am trying to serve line geometry from Oracle database. Some lines are
> rendered and some don't.
>
> Attaching a screen-shot of how it looks. What is the reason for this
> happening with GeoServer?
>
> The SDO_GEOMETRY type is 2002 for both the rendered and unrendered lines.
>
>
>
> Trying to use any other map servers (like MapGuide) the rendering is fine.
>
>
>
> Appreciate some suggestions to try out.
>
>
>
> Warm Regards,
> Praveen
>
------------------------------------------------------------------------------
Rapidly troubleshoot problems before they affect your business. Most IT
organizations don't have a clear picture of how application performance
affects their revenue. With AppDynamics, you get 100% visibility into your
Java,.NET, & PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro!
http://pubads.g.doubleclick.net/gampad/clk?id=84349351&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
