<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18865">
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2 face=Arial>Seems like the table is too big for the provider to
read it and it timed out.</FONT></DIV>
<DIV><FONT size=2 face=Arial>Also, seems like I need a different aproach
for my problem.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Was thinking of creating a SQL statement to fetch
the data needed (SELECT ... FROM ... LEFT OUTER JOIN ... ON ... WHERE day =
To_Date(...) ).</FONT></DIV>
<DIV><FONT size=2 face=Arial>Then creating features of that data, inserting it
in a new layer and adding it to an existing map.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>My concern is, there could be up to 150 000
GPS locations per day and I think it's a bit too much to handle on the fly DB -
PHP - MG.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; PADDING-LEFT: 5px; PADDING-RIGHT: 0px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="FONT: 10pt arial; BACKGROUND: #e4e4e4; font-color: black"><B>From:</B>
<A title=haris@sl-king.com href="mailto:haris@sl-king.com">Haris Kurtagic</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=mapguide-users@lists.osgeo.org
href="mailto:mapguide-users@lists.osgeo.org">MapGuide Users Mail List</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Monday, January 25, 2010 3:37
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>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, <A
href="mailto:BojanFranc@FER">BojanFranc@FER</A> <SPAN dir=ltr><<A
href="mailto:bojan.franc@fer.hr">bojan.franc@fer.hr</A>></SPAN> wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>
<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 target=_blank link="external">[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 target=_blank
link="external">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 target=_blank link="external">[hidden email]</A>
<DIV class=im><BR><A
href="http://lists.osgeo.org/mailman/listinfo/mapguide-users"
rel=nofollow target=_blank
link="external">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 target=_blank link="external">[hidden email]</A> <BR>
<DIV class=im><A
href="http://lists.osgeo.org/mailman/listinfo/mapguide-users" rel=nofollow
target=_blank
link="external">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>
<P>
<HR>
<P></P>_______________________________________________<BR>mapguide-users
mailing
list<BR>mapguide-users@lists.osgeo.org<BR>http://lists.osgeo.org/mailman/listinfo/mapguide-users<BR></BLOCKQUOTE></BODY></HTML>