[mapguide-users] View on Oracle Express

Wed Sep 8 06:01:19 EDT 2010

Could it be as simple as permissions on the view?

-----Original message-----
From: Zac Spitzer zac.spitzer at gmail.com
Date: Tue, 07 Sep 2010 23:39:30 -0700
To: MapGuide Users Mail List mapguide-users at lists.osgeo.org
Subject: Re: [mapguide-users] View on Oracle Express

> also remember that mapguide caches the schema info,
> so once you have accessed a schema, mapguide won't read the
> schema until that cache expires... so no changes will show up
> 
> you can flush the cache by simply opening and saving the feature
> source defintion
> 
> z
> 
> On Wed, Sep 8, 2010 at 2:30 PM, VOLZ Mark (FN) <Mark.Volz at ergon.com.au> wrote:
> > Francesco,
> >
> > That all seems very strange (that it is working on tables but not
> > views). Are you changing the geometry in anyway in your views? i.e. are
> > you using any of cs_transform, aggr, sdo functions/procedures, custom
> > packages/functions/procedures, etc? certain ones will null and void your
> > index.
> >
> > Are the entries in your user_sdo_geom_metadata for your views exactly
> > the same as the ones for the tables i.e. you haven't changed accuracies
> > or x & y column names.
> >
> > Have your tried running a sdo_relate query on your view, shown below (it
> > will test the above questions)?
> > Select *
> > >From xe.view v
> > Where sdo_relate (v.geomtry_column,
> > sdo_geometry(2003,8311,null,sdo_elem_info_array(1,1003,3),sdo_ordinate_a
> > rray(145.683622,-16.88905,145.6925,-16.880274)), 'mask=ANYINTERACT') =
> > 'TRUE';
> >
> > Unless you are in Australia that code shouldn't return any records but
> > it will test that your view supports spatial queries (its actually a
> > snippet of sql that Mapguide sent to our database about 5 minutes ago).
> >
> > Have you tried materialized view?
> >
> > How did you add the primary key to the view? Did you use a statement
> > similar to this after creating the view;?
> > ALTER VIEW XE.VIEW ADD (
> >  CONSTRAINT VIEW_PK
> >  PRIMARY KEY
> >  (column_name) DISABLE);
> >
> >
> > Sorry if I am asking you to check simple things but I had similar
> > problems getting my oracle setup going so I'm just running through all
> > the different problems I ran into using views in XE and mapguide.
> >
> > Mark.
> >
> > -----Original Message-----
> > From: mapguide-users-bounces at lists.osgeo.org
> > [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Francesco
> > Sozzi
> > Sent: Tuesday, 7 September 2010 5:42 PM
> > To: MapGuide Users Mail List
> > Subject: Re: [mapguide-users] View on Oracle Express
> >
> > Hi Mark,
> >
> > Thanks for answer.
> >
> > I confirm primary key and spatial index for both tables and views.
> > On Oracle Express I manage small data. Tablespaces are smaller that
> > 100MB.
> > I tried to drop and recreate all keys and spatial index. Oracle did the
> > job with no warnings or errors, so I am sure all index are ok.
> >
> > For the moment my workaround is to create side tables with the content
> > of views, a sort of snapshots on views I need to publish data. With
> > these tables (populated with data from views) MG works as expected.
> > Please note that I need views (or these "side" tables) to show joined
> > data in the property panel.
> >
> > Best regard
> >
> > Francesco
> >
> >
> > ----- Original Message -----
> > From: "VOLZ Mark (FN)" <Mark.Volz at ergon.com.au>
> > To: "MapGuide Users Mail List" <mapguide-users at lists.osgeo.org>
> > Sent: Monday, September 06, 2010 8:00 PM
> > Subject: RE: [mapguide-users] View on Oracle Express
> >
> >
> > Francesco,
> >
> > Can you confirm that the geometry columns (in the underlying table(s))
> > you
> > are trying to use in the views have a spatial index built on them?
> >
> > The second thing to look at is the size of the database. A spatial index
> >
> > takes up table space so if you have a data set of about 4.5gb and then
> > try
> > and build a spatial index it will fail due to the size restriction on
> > XE.
> > This may be why the imported schema works in Standard/enterprise but not
> > in
> > XE.
> >
> > Mapguide always sends a spatial query when querying the data from oracle
> >
> > (which will fail if you don't have a spatial index), Autocad map doesn't
> >
> > always do this.
> >
> > Mark
> >
> >
> >
> > -----Original Message-----
> > From: mapguide-users-bounces at lists.osgeo.org
> > [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Zac Spitzer
> > Sent: Tuesday, 7 September 2010 11:27 AM
> > To: MapGuide Users Mail List
> > Subject: Re: [mapguide-users] View on Oracle Express
> >
> > have you tried the latest king oracle provider?
> >
> > http://www.sl-king.com/fdooracle/
> >
> > Also it's always helpful to state versions of the various software
> >
> > z
> >
> > On Mon, Sep 6, 2010 at 10:38 PM, Francesco Sozzi <fsozzi at intercad.ch>
> > wrote:
> >> Hi All,
> >>
> >> I have an Oracle schema with views to render on Mapguide Open Source.
> >> If I load this schema on an Oracle Standard or Enterprise, views are
> >> rendered.
> >> If I load on Mapguide from express, they are not rendered (I can
> >> render the table with geometry field, but not the view).
> >>
> >> All views are in USER_SDO_GEOM_METADATA and all views have primary
> > keys.
> >> I can load and render on Autodesk Map from Oracle Express without
> >> problems.
> >> From Maestro I can see them in the list, if I try to create a layer,
> >> but they are not rendered at all.
> >>
> >> Any idea or suggstions?....
> >>
> >> Best regards
> >>
> >> Francesco
> >>
> >> __________ Information from ESET NOD32 Antivirus, version of virus
> >> signature database 5426 (20100906) __________
> >>
> >> The message was checked by ESET NOD32 Antivirus.
> >>
> >> http://www.eset.com
> >>
> >> _______________________________________________
> >> mapguide-users mailing list
> >> mapguide-users at lists.osgeo.org
> >> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> >>
> >>
> >
> >
> >
> > --
> > Zac Spitzer
> > Solution Architect / Director
> > Ennoble Consultancy Australia
> > http://www.ennoble.com.au
> > http://zacster.blogspot.com
> > +61 405 847 168
> > _______________________________________________
> > mapguide-users mailing list
> > mapguide-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To report this email as spam, please forward to spam at mailcontrol.com
> > ---------------------------------------------------------------------
> >
> >
> > ************************************************************************
> > *
> > This e-mail (including any attachments) may contain confidential or
> > privileged information and is intended for the sole use of the person(s)
> > to
> > whom it is addressed. If you are not the intended recipient, or the
> > person
> > responsible for delivering this message to the intended recipient,
> > please
> > notify the sender of the message or send an e-mail to
> > mailto:help.desk at ergon.com.au immediately, and delete all copies. Any
> > unauthorised review, use, alteration, disclosure or distribution of this
> > e-mail by an unintended recipient is prohibited. Ergon Energy accepts no
> > responsibility for the content of any e-mail sent by an employee which
> > is of
> > a personal nature.
> >
> > Ergon Energy Corporation Limited      ABN 50 087 646 062
> > ************************************************************************
> > *
> > _______________________________________________
> > mapguide-users mailing list
> > mapguide-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> >
> > __________ Information from ESET NOD32 Antivirus, version of virus
> > signature
> > database 5429 (20100906) __________
> >
> > The message was checked by ESET NOD32 Antivirus.
> >
> > http://www.eset.com
> >
> >
> >
> >
> > __________ Information from ESET NOD32 Antivirus, version of virus
> > signature database 5429 (20100906) __________
> >
> > The message was checked by ESET NOD32 Antivirus.
> >
> > http://www.eset.com
> >
> >
> >
> > _______________________________________________
> > mapguide-users mailing list
> > mapguide-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> > _______________________________________________
> > mapguide-users mailing list
> > mapguide-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> >
> 
> 
> 
> -- 
> Zac Spitzer
> Solution Architect / Director
> Ennoble Consultancy Australia
> http://www.ennoble.com.au
> http://zacster.blogspot.com
> +61 405 847 168
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 