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, bojanfr...@fer <[email protected]> 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 > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > >
_______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
