<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>[mapguide-users] RE: Oracle Spatial v/s Oracle Locator with MapGuide FDO</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=437362218-08092006><FONT face=Arial
color=#0000ff size=2>Great. Yes, right now no coord sys
info.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=437362218-08092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=437362218-08092006><FONT face=Arial
color=#0000ff size=2>Haris</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Traian Stanev
[mailto:traian.stanev@autodesk.com] <BR><B>Sent:</B> Friday, September 08, 2006
8:18 PM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] New Oracle FDO provider<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=109141618-08092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=109141618-08092006><FONT face=Arial
color=#0000ff size=2>Yup, I got it to work fine now. I just tried a few
different tables until it worked. Yes, I also had to set the data extents
manually, probably because of the lack of coord sys
information.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=109141618-08092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=109141618-08092006><FONT face=Arial
color=#0000ff size=2>Traian</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=109141618-08092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Haris Kurtagic [mailto:haris@sl-king.com]
<BR><B>Sent:</B> Friday, September 08, 2006 11:57 AM<BR><B>To:</B>
users@mapguide.osgeo.org<BR><B>Subject:</B> RE: [mapguide-users] New Oracle FDO
provider<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=468175015-08092006><FONT face=Arial
color=#0000ff size=2>Right now provider is not reporting to mapguide coordinate
reference system.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=468175015-08092006><FONT face=Arial
color=#0000ff size=2>So you can use data with ( SRID NULL,
arbitrary x-y).</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Traian Stanev
[mailto:traian.stanev@autodesk.com] <BR><B>Sent:</B> Friday, September 08, 2006
5:49 PM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] New Oracle FDO provider<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=031224615-08092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=031224615-08092006><FONT face=Arial
color=#0000ff size=2>OK, if I connect with the user who owns the data, I see the
correct feature classes and attributes listed. But now, I don't see any geometry
(even after zooming to the place where I expect the data to appear). It's
probably my fault still, since my knowledge of Oracle is about 3 bits, and
I probably have messed up tables.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=031224615-08092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=031224615-08092006><FONT face=Arial
color=#0000ff size=2>Traian</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=031224615-08092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Haris Kurtagic [mailto:haris@sl-king.com]
<BR><B>Sent:</B> Friday, September 08, 2006 11:27 AM<BR><B>To:</B>
users@mapguide.osgeo.org<BR><B>Subject:</B> RE: [mapguide-users] New Oracle FDO
provider<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=468151815-08092006><FONT face=Arial
color=#0000ff size=2>Thanks for first respons.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=468151815-08092006><FONT face=Arial
color=#0000ff size=2>To see table, table has to be listed
user_sdo_geom_metadata view.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=468151815-08092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=468151815-08092006><FONT face=Arial
color=#0000ff size=2>This means that username (oracle schema) you are using
to connect to Oracle has to be owner of tables and metadata is inserted in
the metadata view.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=468151815-08092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=468151815-08092006><FONT face=Arial
color=#0000ff size=2>Righ now I am working on reading tables from
all_sdo_geom_metadata view so you will be able to see all tables you have select
permission.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=468151815-08092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=468151815-08092006><FONT face=Arial
color=#0000ff size=2>Haris</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=468151815-08092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN><SPAN class=468151815-08092006><FONT
face=Arial color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=468151815-08092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left>
<HR tabIndex=-1>
</DIV>
<DIV dir=ltr align=left><FONT face=Tahoma size=2><B>From:</B> Traian Stanev
[mailto:traian.stanev@autodesk.com] <BR><B>Sent:</B> Friday, September 08, 2006
5:17 PM<BR><B>To:</B> users@mapguide.osgeo.org<BR><B>Subject:</B> RE:
[mapguide-users] New Oracle FDO provider<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV dir=ltr align=left><SPAN class=122161415-08092006><FONT face=Arial
color=#0000ff size=2>After a quick try... I got a succesful connection in MG
Studio, but when trying to create a layer, I get no feature classes listed, so
either the tables I have in the Oracle server are all weird or something else is
going on... I'll try to call the provider directly from a test program to see if
I get any data back.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=122161415-08092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=122161415-08092006><FONT face=Arial
color=#0000ff size=2>Traian</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Haris Kurtagic [mailto:haris@sl-king.com]
<BR><B>Sent:</B> Thursday, September 07, 2006 7:59 PM<BR><B>To:</B>
users@mapguide.osgeo.org<BR><B>Subject:</B> [mapguide-users] New Oracle FDO
provider<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV dir=ltr align=left><SPAN class=343141623-07092006><FONT face=Arial
color=#0000ff size=2>Hi ,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=343141623-07092006><FONT face=Arial
color=#0000ff size=2>I am working on new FDO provider for
Oracle.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=343141623-07092006><FONT face=Arial
color=#0000ff size=2>You can read more about it and download it here: <A
href="http://www.sl-king.com/fdooracle">www.sl-king.com/fdooracle</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=343141623-07092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=343141623-07092006><FONT face=Arial
color=#0000ff size=2>It is not open source project yet, but it is free to
use.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=343141623-07092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=343141623-07092006><FONT face=Arial
color=#0000ff size=2>I would appreciate if you try it and if you give me
some feedback.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=343141623-07092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=343141623-07092006><FONT face=Arial
color=#0000ff size=2>Regards,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=343141623-07092006><FONT face=Arial
color=#0000ff size=2>Haris Kurtagic</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=343141623-07092006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV><FONT
style="BACKGROUND-COLOR: #ffffff" face=Arial color=#0000ff size=2></FONT><FONT
style="BACKGROUND-COLOR: #ffffff" face=Arial color=#0000ff size=2></FONT><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Arial
size=2></FONT> </DIV></BODY></HTML>