Re: [Geoserver-users] Using the new oracleNG plugin

[Kris G. <kge...@xe...>]

Hi Jukka,

If you want to use the all_sdo_geom_metadata table geoserver must know at least the owner to get the correct row. I don't think this is supported in the config yet?

Cheers Kris

-----Original Message-----
From: Rahkonen Jukka [mailto:Juk...@mm...] 
Sent: Tuesday, March 10, 2009 3:40 PM
To: Andrea Aime; Kris Geusebroek
Cc: geo...@li...
Subject: Re: [Geoserver-users] Using the new oracleNG plugin

Hi,

Just wondering, perhaps synonym all_sdo_geom_metadata should be used instead of user_sdo_geom_metadata?  At least in our environment Geoserver user account is used just for queries, and indexes, metadata rows etc. are created by another account having manager rights.

-Jukka Rahkonen-


 

> -----Alkuperäinen viesti-----
> Lähettäjä: Andrea Aime [mailto:aa...@op...] 
> Lähetetty: 10. maaliskuuta 2009 15:50
> Vastaanottaja: Kris Geusebroek
> Kopio: geo...@li...
> Aihe: Re: [Geoserver-users] Using the new oracleNG plugin
> 
> Kris Geusebroek ha scritto:
> > I made some progress myself.
> > 
> > I can see in the sourcecode of the oracle plugin that a 
> query is done 
> > to the table USER_SDO_GEOM_)METADAT to get the SRID for the table
> > 
> > In my config this table is empty because we use a table 
> from another 
> > user by public synonym.
> > 
> >  
> > 
> > So I think I need to update the USER SDO GEOM METADATA 
> table for this 
> > user too.
> > 
> > Any other options are appreciated
> 
> There is none that I know of, Oracle pretends that the srs of 
> the bbox and whatever else used in a spatial index is equal 
> to the one of the indexed geometries.
> You say that the old oracle spatial datastore was working 
> properly for you? I'm wondering how, the old datastore was 
> getting the srid in pretty much the same way and was encoding 
> the srid as well.
> 
> Humm... I see the old was encoding NULL as the srid when it 
> was not known, whilst I guess the new one is encoding -1. 
> That is probably the relevant difference? Can you try running 
> manually a query that uses NULL and see if Oracle complains about it?
> 
> Cheers
> Andrea
> 
> --
> Andrea Aime
> OpenGeo - http://opengeo.org
> Expert service straight from the developers.
> 
> --------------------------------------------------------------
> ----------------
> _______________________________________________
> Geoserver-users mailing list
> Geo...@li...
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>