That error looks more like networking problem then MG&King.Oracle.<div><br></div><div>I guess googling for it would be first step ::)</div><div><br></div><div>Haris<br><br><div class="gmail_quote">On Mon, Jan 25, 2010 at 3:33 PM, BojanFranc@FER <span dir="ltr"><<a href="mailto:bojan.franc@fer.hr">bojan.franc@fer.hr</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div><font size="2" face="Arial">Thx for info, I can select it now.</font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">Now, another problem... </font></div>
<div><font size="2" face="Arial">I created the JOIN, restarted MGOS just in
case...</font></div>
<div><font size="2" face="Arial">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).</font></div>
<div><font size="2" face="Arial">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...</font></div>
<div><font size="2" face="Arial"></font> </div>
<div>An exception occurred in FDO component. ORA-12520: TNS:listener could not
find available handler for requested type of server </div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">I am using MGOS 2.1 and King.Oracle version
0.8.8</font></div>
<div> </div>
<blockquote style="border-left:#000000 2px solid;padding-left:5px;padding-right:0px;margin-left:5px;margin-right:0px"><div class="im">
<div style="font:10pt arial">----- Original Message ----- </div>
<div style="font:10pt arial;background:#e4e4e4"><b>From:</b>
<a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4454203&i=0" rel="nofollow" target="_blank">[hidden email]</a> </div>
<div style="font:10pt arial"><b>To:</b> <a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4454203&i=1" rel="nofollow" target="_blank">[hidden email]</a> </div>
<div style="font:10pt arial"><b>Sent:</b> Monday, January 25, 2010 2:19
PM</div>
<div style="font:10pt arial"><b>Subject:</b> Re: [mapguide-users] King.Oracle
provider - how to create join with table without geometry data?</div>
<div><br></div>If I am not mistaken you can use KingFdoClass metadata table to
add non-geometry tables.
<div><br></div>
</div><div>Haris<br><br>
<div class="gmail_quote"><div class="im">On Mon, Jan 25, 2010 at 2:10 PM, <a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4454203&i=2" rel="nofollow" target="_blank">[hidden email]</a> <span dir="ltr"><<a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4453862&i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a>></span> wrote:<br>
</div><blockquote style="border-left:#ccc 1px solid;margin:0px 0px 0px 0.8ex;padding-left:1ex" class="gmail_quote"><div class="im"><br>Hi,<br><br>I have a data warehouse with a FACT table
containing a lot of points (GPS<br>locations). And I have a DATE dimension
table.<br>I want to draw a layer containing all locations within 1 day (or a
period of<br>days).<br><br>I was thinking of doing a JOIN with King.Oracle
of that FACT and DIMENSION<br>table, exporting it to XML and then in PHP
editing the filter tag with "DATE<br>= YYYY.MM.DD". After modifying the
layer, I would insert the new layer into<br>map and draw it.<br>It should
also work fast enough for users to be able to go BACK and
FORWARD<br>displaying maps for each day.<br><br>The problem is, in
King.Oracle provider, I see only tables and views with<br>geometry fields.
And I need to join my DATE dimension which has no
geometry<br>(logicaly).<br>Is it possible?<br><br>Also, has anyone a better
solution for my problem?<br><br>I have round 10 Mil GPS locations for every
year.<br><br>Thx!<br></div><font color="#888888"><div class="im">--<br>View this message in context:
<a href="http://n2.nabble.com/King-Oracle-provider-how-to-create-join-with-table-without-geometry-data-tp4453820p4453820.html" rel="nofollow" link="external" target="_blank">http://n2.nabble.com/King-Oracle-provider-how-to-create-join-with-table-without-geometry-data-tp4453820p4453820.html</a><br>
Sent
from the MapGuide Users mailing list archive at
Nabble.com.<br>_______________________________________________<br>mapguide-users
mailing list<br></div><a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4453862&i=1" rel="nofollow" link="external" target="_blank">[hidden email]</a><div class="im"><br><a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
</div></font></blockquote></div><br></div><br>_______________________________________________
<br>mapguide-users mailing list <br><a href="http://n2.nabble.com/user/SendEmail.jtp?type=node&node=4453862&i=2" rel="nofollow" link="external" target="_blank">[hidden email]</a> <br><div class="im"><a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" rel="nofollow" link="external" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
</div></blockquote>
<br><hr align="left" width="300">
View this message in context: <a href="http://n2.nabble.com/King-Oracle-provider-how-to-create-join-with-table-without-geometry-data-tp4453820p4454203.html" target="_blank">Re: [mapguide-users] King.Oracle provider - how to create join with table without geometry data?</a><div>
<div></div><div class="h5"><br>
Sent from the <a href="http://n2.nabble.com/MapGuide-Users-f1803227.html" target="_blank">MapGuide Users mailing list archive</a> at Nabble.com.<br>
</div></div><br>_______________________________________________<br>
mapguide-users mailing list<br>
<a href="mailto:mapguide-users@lists.osgeo.org">mapguide-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/mapguide-users</a><br>
<br></blockquote></div><br></div>