Re: [Geoserver-users] Re: Joining tables ub WFS ?

[Chris H. <ch...@op...>]

Quoting Alexander Petkov <gre...@gm...>:

> On 12/21/05, Javier de la Torre <ja...@gm...> wrote:
> > Uhmmm... that is interesting for me too..
> > I remember to have tried this and I also found that Geoserver was
> not
> > recognizing the geometries inside a view...
> >
> > Javier.
>
> Is that when using Oracle? I know it is definitely possible with
> PostGis.

I believe people have got it working with oracle.  You have to add it by
hand (like modify the xml files), since our datastore won't recognize
views.  And the view needs an entry in the geom meta table.  If you dig
into the code I think you should find a way to make it work, like
there's no huge deal breakers afaik.

Thijs is one of our most experienced oracle users.  Do you have any
hints on how to get views working?  Or if you never did, where it fell
short?

Also, Alex, if it's not done already, could you add a little section to
the Postgis DataStore on how to get views working?  I think the key
trick is to name one of your columns 'oid', and everything works fine.

Chris

>
> Alex
> =13=86+=12=16w=ADzf=A2=96+,=A6=89=EC=A2=B7=9Do$=A9=96=E9=E4"w=03=A3*.=82=
=B7=A9=B6=1A=E8=BA=08e=A2=07=E2=95=EB=1F=A2=BAk=A1=B9^=9A=C4=AD=A2=90=E8=C2=
yhi=DBazw=B0

----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/