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

[Bart v. d. E. <BE...@Sy...>]

I have been using Oracle Spatial views with the 1.3 series and it works =
fine, even the admin tool recognizes the spatial views if you make sure =
they are advertized in SDO_GEOM_METADATA_TABLE.

I have also used purely administrative views without geometry (also =
through the admin tool).

Best regards,
Bart

Bart van den Eijnden
Syncera IT Solutions
Postbus 270
2600 AG  DELFT

tel.nr.: 015-7512436
email: BE...@Sy...

>>> Thijs Brentjens <thi...@ge...> 12/22/2005 10:34:34 AM >>>
Hi Alexander,

For support of views, it depends on the version (Geoserver) you're =
using.=20
If that is 1.2.3 or an earlier version, views are not supported. But as=20
Chris says, you could configure it manually. As far as I can recall I:
1. created a table with the exact same name and definition as the view =
I=20
wanted (create table my_view as select... etc)
2. made an entry in user_sdo_geom_metadata for that table
3. created a spatial index on the geometry column of the table
4. then configured Geoserver (manually or with the web-admin, both should =
work)
5. dropped the table
6. created the view: create or replace view my_view as select ...etc =
(so=20
with the same select-statement as the table and the same name)

Configuring it manually (i.e. write the info.xml) should work, but I =
don't=20
know why I didn't do that. Anyway, it worked. But I'm sure there are =
more=20
elegant ways of doing it...

However, with an Oracle datastore it's far better to use one of the=20
1.3.0.RCx versions of Geoserver. Because with these versions views are=20
supported (for all JDBC-datastores, I think). I'm using them a lot =
actually=20
and I'm not using 1.2.3 anymore, since support for Oracle has been =
improved=20
(better SQL) for 1.3.0.RCx. Note that you still need to "register" the =
view=20
in user_sdo_geom_metadata. And the geometry column of the table that =
you're=20
using in the view should have a spatial index on it.

This email is a bit messy, but maybe it helps. If not, then please tell =
me=20
what database and which version of Geoserver you are using.

Best regards,
Thijs

PS @Chris: I've still got plans to add something to the docs on the =
Oracle=20
datastore, but time has been the problem and documenting isn't one of =
my=20
favorite things to do... Sorry for that.

At 00:54 22-12-2005, Chris Holmes wrote:
>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
> > *+w-zf=A2-+,|*=EC=A2=B7 o$=A9-=E9=E4"w=A3*.*=B7=A9=B6





-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log =
files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_idv37&alloc_id865&op=3Dclick=20
_______________________________________________
Geoserver-users mailing list
Geo...@li...=20
https://lists.sourceforge.net/lists/listinfo/geoserver-users