Hello, Exactly this extension I already had installed at my GeoServer 2.0.2. And there I get in conflict with the spatial extension. At GeoServer I can choose between three different options to configure a new data source. * Oracle NG - Oracle Database * Oracle NG (JNDI) - Oracle Database (JNDI) * Oracle NG (OCI) - Oracle Database (OCI) Currently I use the first option. Is perhaps this the reason for my Problem? Would the other two options be better not to come in conflict with spatial?
Thanks so far, Moritz Strangmann -----Ursprüngliche Nachricht----- Von: Ben Caradoc-Davies [mailto:[email protected]] Gesendet: Freitag, 17. September 2010 08:50 An: Strangmann, Moritz Cc: [email protected] Betreff: Re: [Geoserver-users] Spatial and Locator Features in Oracle Extension gt-jdbc-oracle is included in the Oracle plugin download for GeoServer: http://geoserver.org/display/GEOS/Download (select your GeoServer version, and see lower down the page for Oracle) On 17/09/10 14:39, Strangmann, Moritz wrote: > Hello, > > Thanks for the links, Pedro. > > Can you say me, where I can get the gt-jdbc-oracle Extension ready to start? > I thought about a jar file. > If I understood it right, gt-jdbc-oracle is part of Geotools. But there I > just found the source code with a .pom instruction for installing with maven. > And I think there should be an easier way. > > Thanks, > Moritz Strangmann > > > -----Ursprüngliche Nachricht----- > Von: Pedro Mendes [mailto:[email protected]] > Gesendet: Donnerstag, 16. September 2010 15:32 > An: [email protected] > Cc: Strangmann, Moritz > Betreff: RE: [Geoserver-users] Spatial and Locator Features in Oracle > Extension > > Hello, > > Only Oracle Locator features are used in the gt-jdbc-oracle extension. > > You can clear your doubts about "locator vs spatial" issue reading the > following articles: > http://www.matttopper.com/?p=26 > http://www.spatialdbadvisor.com/oracle_spatial_tips_tricks/55/oracle-locator > -vs-enterprise-licensing-the-sdogeom-package > > > Cheers, > Pedro Mendes > > >> -----Mensagem original----- >> De: Strangmann, Moritz [mailto:[email protected]] >> Enviada: quinta-feira, 16 de Setembro de 2010 11:17 >> Para: [email protected] >> Assunto: [Geoserver-users] Spatial and Locator Features in Oracle > Extension >> >> Hi, >> >> At first I want to excuse for my English. But I will try my very best. >> >> I actually assumed that the Oracle extension for GeoServer only uses >> locator features of the Oracle DB. Well, my DB Admin has said that this >> is not the case. >> So I have to find out what parts of my App are using spatial features. >> >> On a first view at the source code I noticed that the class >> OracleFilterToSQL uses the function SDO_RELATE. This is according to the >> following page only for Spatial allowed: >> http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28400/sdo_locat >> or.htm#i632018 >> >> >> Is there a simple way to eliminate or disable all the spatial features? >> I considered commenting out the parts where I know that spatial features >> are used. But first I don't know if I have found every request that's >> forbidden for the oracle locator and second I don't even know if the >> extension is still running. >> Any ideas? >> >> Thanks, >> Moritz Strangmann >> >> > ---------------------------------------------------------------------------- > -- >> Start uncovering the many advantages of virtual appliances >> and start using them to simplify application deployment and >> accelerate your shift to cloud computing. >> http://p.sf.net/sfu/novell-sfdev2dev >> _______________________________________________ >> Geoserver-users mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/geoserver-users > > > ------------------------------------------------------------------------------ > Start uncovering the many advantages of virtual appliances > and start using them to simplify application deployment and > accelerate your shift to cloud computing. > http://p.sf.net/sfu/novell-sfdev2dev > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > -- Ben Caradoc-Davies <[email protected]> Software Engineering Team Leader CSIRO Earth Science and Resource Engineering Australian Resources Research Centre ------------------------------------------------------------------------------ Start uncovering the many advantages of virtual appliances and start using them to simplify application deployment and accelerate your shift to cloud computing. http://p.sf.net/sfu/novell-sfdev2dev _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
