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

[BojanFranc at FER]

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: Haris Kurtagic [via OSGeo.org] 
  To: BojanFranc at FER 
  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, BojanFranc at FER <[hidden email]> 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://lists.osgeo.org/mailman/listinfo/mapguide-users




  _______________________________________________ 
  mapguide-users mailing list 
  [hidden email] 
  http://lists.osgeo.org/mailman/listinfo/mapguide-users



------------------------------------------------------------------------------

  View message @ http://n2.nabble.com/King-Oracle-provider-how-to-create-join-with-table-without-geometry-data-tp4453820p4453862.html 
  To unsubscribe from King.Oracle provider - how to create join with table without geometry data?, click here. 


-- 
View this message in context: 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 at Nabble.com.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20100125/a12422f2/attachment.html