[mapguide-users] View on Oracle Express

[Simon Pelicon]

Hi!

If you are using King Oracle Provider try using *KingFdoClass *table to
populate view as FDO Class instead of inserting views in
USER_SDO_GEOM_METADATA.
Here are instruction on how to do this:
http://www.sl-king.com/fdooracle/KingFdoClass.htm


Simon

Instead "inserting" views in USER_SDO_GEOM_METADATA  you can USE

On Tue, Sep 7, 2010 at 9:42 AM, Francesco Sozzi <fsozzi at intercad.ch> wrote:

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20100907/5018937d/attachment.html