[mapguide-users] King.Oracle provider - how to create join with table without geometry data?

[Haris Kurtagic]

That error looks more like networking problem then MG&King.Oracle.

I guess googling for it would be first step ::)

Haris

On Mon, Jan 25, 2010 at 3:33 PM, BojanFranc at FER <bojan.franc at fer.hr> wrote:

> Thx for info, I can select it now.
>
> Now, another problem...
> I created the JOIN, restarted MGOS just in case...
> In MG Studio I can edit the features, it lists the feature values (means it
> reads data from the new join) but the layer is empty (nothing shown on map).
> In FeatureSource editor in MG Studio I can preview my other tables and
> views, but when I try to preview (data and features) my JOIN I get an
> error...
>
> An exception occurred in FDO component. ORA-12520: TNS:listener could not
> find available handler for requested type of server
>
> I am using MGOS 2.1 and King.Oracle version 0.8.8
>
>
> ----- Original Message -----
> *From:* [hidden email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4454203&i=0>
> *To:* [hidden email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4454203&i=1>
> *Sent:* Monday, January 25, 2010 2:19 PM
> *Subject:* Re: [mapguide-users] King.Oracle provider - how to create join
> with table without geometry data?
>
> If I am not mistaken you can use KingFdoClass metadata table to add
> non-geometry tables.
>
> Haris
>
> On Mon, Jan 25, 2010 at 2:10 PM, [hidden email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4454203&i=2>
> <[hidden email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4453862&i=0>
> > wrote:
>
>>
>> Hi,
>>
>> I have a data warehouse with a FACT table containing a lot of points (GPS
>> locations). And I have a DATE dimension table.
>> I want to draw a layer containing all locations within 1 day (or a period
>> of
>> days).
>>
>> I was thinking of doing a JOIN with King.Oracle of that FACT and DIMENSION
>> table, exporting it to XML and then in PHP editing the filter tag with
>> "DATE
>> = YYYY.MM.DD". After modifying the layer, I would insert the new layer
>> into
>> map and draw it.
>> It should also work fast enough for users to be able to go BACK and
>> FORWARD
>> displaying maps for each day.
>>
>> The problem is, in King.Oracle provider, I see only tables and views with
>> geometry fields. And I need to join my DATE dimension which has no
>> geometry
>> (logicaly).
>> Is it possible?
>>
>> Also, has anyone a better solution for my problem?
>>
>> I have round 10 Mil GPS locations for every year.
>>
>> Thx!
>> --
>> View this message in context:
>> http://n2.nabble.com/King-Oracle-provider-how-to-create-join-with-table-without-geometry-data-tp4453820p4453820.html
>> Sent from the MapGuide Users mailing list archive at Nabble.com.
>> _______________________________________________
>> mapguide-users mailing list
>> [hidden email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4453862&i=1>
>>
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>
>
> _______________________________________________
> mapguide-users mailing list
> [hidden email]<http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4453862&i=2>
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>
> ------------------------------
> View this message in context: Re: [mapguide-users] King.Oracle provider -
> how to create join with table without geometry data?<http://n2.nabble.com/King-Oracle-provider-how-to-create-join-with-table-without-geometry-data-tp4453820p4454203.html>
>
> Sent from the MapGuide Users mailing list archive<http://n2.nabble.com/MapGuide-Users-f1803227.html>at Nabble.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/20100125/a3052697/attachment.html