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

[Rahkonen J. <Juk...@mm...>]

Well, I can see that it used to be that way.
http://geoserver.org/display/GEOSDOC/Oracle+DataStore

-Jukka-

> -----Alkuperäinen viesti-----
> Lähettäjä: Kris Geusebroek [mailto:kge...@xe...] 
> Lähetetty: 10. maaliskuuta 2009 16:45
> Vastaanottaja: Rahkonen Jukka; Andrea Aime
> Kopio: geo...@li...
> Aihe: RE: [Geoserver-users] Using the new oracleNG plugin
> 
> 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
> > 
>