Re: [Geoserver-users] SLD-Style for oracle's data

[Andrey M. <asm...@gm...>]

My problem is the columns of oracle tables have lowercase names, because I
imported tables from postgresql via ogr2ogr. But oracle tables must have the
uppercase column names. Does anyone know what I should to do that the
propertiesname parameter would be like "COLUMNNAME" (with Double inverted
commas) something like this:
<ogc:PropertyIsEqualTo>
            <ogc:PropertyName>*"*place*"*</ogc:PropertyName>
            <ogc:Literal>city</ogc:Literal>
           </ogc:PropertyIsEqualTo>




2011/8/29 Harikumar Reddy <har...@gm...>

> Hi,
>
> It may help you.
>
> http://docs.geoserver.org/stable/en/user/styling/sld-cookbook/index.html
>
> Regards,
> Hari.
>
> On Mon, Aug 29, 2011 at 2:17 PM, Andrey Maraev <asm...@gm...> wrote:
>
>> Hello list!
>>
>> Could you please help me? First, I imported osm data in oracle and got
>> some tables like (planet_osm_line,planet_osm_point,planet_osm_polygon).
>> Then  I connected to oracle spatial base via geoserver and saw some picture.
>>
>> Finally I want to create some style for my tables(point,polygon,line). Can
>> you show me an example of SLD-style or something else how I can use
>> geoserver with oracle base?
>> I have some style like:
>> ....
>> <ogc:PropertyIsEqualTo>
>>             <ogc:PropertyName>place</ogc:PropertyName>
>>             <ogc:Literal>city</ogc:Literal>
>>            </ogc:PropertyIsEqualTo>
>> ....
>>  But I get the error:
>> code:"internalError"rendering process failed java.io.IOExeption null
>>          ORA-00904: PLACE invalid indentifier
>>
>> But I see the place in Feature Type Details of Layer's settings
>>
>> --
>> lernen,lernen und lernen
>>
>>
>>
>> ------------------------------------------------------------------------------
>> EMC VNX: the world's simplest storage, starting under $10K
>> The only unified storage solution that offers unified management
>> Up to 160% more powerful than alternatives and 25% more efficient.
>> Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev
>> _______________________________________________
>> Geoserver-users mailing list
>> Geo...@li...
>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>
>>
>


-- 
lernen,lernen und lernen