[mapguide-users] RE: RE: RE: FDO King.Oracle provider 0.3
Haris Kurtagic
haris at sl-king.com
Fri Oct 20 16:35:06 EDT 2006
Thank you.
Default is used for NULL srid and also should have correct extents if
there are tables with NULL srid. That one always exits (perhaps that
could be change if not NULL srid - to exclude this default).
Problem was with MG 1.0.1 that it is not changing spatial context for
different layers (using just first one in list) but if I unterstood
correctly it should be corrected in MG 1.0.2. I haven't tested it.
You don't need to have primary key do display.
You need to have it to edit in MAP for example.
I could imagine wrong extents in case there are only views in that
oracle schema or not calculated index extents ( not sure if that is even
possible to happen in oracle) or a bug in a provider.
If you can share your data I am willing to setup on my db and tested it.
Haris
-----Original Message-----
From: Joel Carranza [mailto:jec at gatekeeper.com]
Sent: Friday, October 20, 2006 10:25 PM
To: users at mapguide.osgeo.org
Subject: [mapguide-users] RE: RE: RE: FDO King.Oracle provider 0.3
Haris,
Cool. I just wanted to mention how jazzed we are that you are developing
this. Its looking great....
Now back to the problems :)
The coordinate system which is reported is correct. However, i would
mention that actually there are actually 2 spatial contexts which are
being returned. One is nad83, and one called "Default" is just a local
Meter coordinate system. Don't know if that is supposed to be there or
not.
However, both return extents:
<LowerLeftCoordinate>
<X>-10000000</X>
<Y>-10000000</Y>
</LowerLeftCoordinate>
<UpperRightCoordinate>
<X>10000000</X>
<Y>10000000</Y>
</UpperRightCoordinate>
Does a table require a primary key column to be used as a layer?
Regarding supporting views, I assume one problem would be determining
the primary key column of a view, no?
Joel
haris kurtagic wrote:
>
>
> Regarding 9.2 I have not tested that, but I will tested it and
> supported it.
> This SDO_TOPO_OBJECT is reason for it. Topology object starting from
> 10g.
>
> I suppose you are thinking of this wrong bounds (default values for
> provider).
> I could imagine that this is because it is coming from view and
> extents are read from table indexes.
> I am just thinking about this not sure, need to check.
>
> I suppose if you manually setup view extens in the map, it should
> display data.
>
> Coordinate system reported is correct one ?
>
> Haris
>
>
> -----Original Message-----
> From: Joel Carranza [mailto:jec at gatekeeper.com]
> Sent: Friday, October 20, 2006 9:40 PM
> To: users at mapguide.osgeo.org
> Subject: [mapguide-users] RE: RE: FDO King.Oracle provider 0.3
>
>
> I found the problem. There was an oracle installation (linking?)
> problem, and that problem was causing problems in FDO. The
> GetFeatureProviders function was returning the FDO info but without
> any connection properties. Very strange.
>
> Now I've gotten further, i'm seeing some layers to choose from. My
> views still aren't showing up (even through they are setup in
> USER_SDO_GEOM_METADATA) Haven't seen any actual data displayed on the
> map though.
>
> Attempting to figure things out, Get Spatial Contexts returns
> something a little weird.
>
> <SpatialContext IsActive="true">
> <Name>Longitude / Latitude (NAD 83)</Name> <Description/>
> <CoordinateSystemName>Longitude / Latitude (NAD
> 83)</CoordinateSystemName> <CoordinateSystemWkt> GEOGCS [ "Longitude /
> Latitude (NAD 83)", DATUM ["NAD 83", SPHEROID ["GRS 80", 6378137,
> 298.257222101]], PRIMEM [ "Greenwich", 0.000000 ], UNIT ["Decimal
> Degree", 0.01745329251994330]] </CoordinateSystemWkt>
> <ExtentType>Static</ExtentType> <Extent>
> <LowerLeftCoordinate>
> <X>-10000000</X>
> <Y>-10000000</Y>
> </LowerLeftCoordinate>
> <UpperRightCoordinate>
> <X>10000000</X>
> <Y>10000000</Y>
> </UpperRightCoordinate>
> </Extent>
> <XYTolerance>0.001000</XYTolerance>
> <ZTolerance>0.000000</ZTolerance>
> </SpatialContext>
>
> Shouldn't this be returning something that resembles my data?
>
> A connection to my 9.2 DB fails with
>
> An exception occurred in FDO component. OCI-22303: type
> "MDSYS"."SDO_TOPO_OBJECT" not found
>
> Any intention to support 9.2 ?
>
> Joel
>
>
> haris kurtagic wrote:
>>
>>
>> :)
>> Are you using Autodesk MapGuide Studio - list should be easy editable
>> in it :).
>>
>> Haris
>>
>> -----Original Message-----
>> From: Joel Carranza [mailto:jec at gatekeeper.com]
>> Sent: Friday, October 20, 2006 7:03 PM
>> To: users at mapguide.osgeo.org
>> Subject: [mapguide-users] RE: FDO King.Oracle provider 0.3
>>
>>
>> I got that. I did read the readme before I started this, I promise :)
>>
>> My problem is that I literally can't figure out how to edit the
>> property list. I am sure my brain is just running slow or something.
>> But, how do I specify these connection properties? Should the list be
>> editable, because it isnt. Do I have to put these properties in the
>> "configuration file" What is the format of that file?
>>
>>
>> haris kurtagic wrote:
>>>
>>> Hi,
>>>
>>> there should be four properties:
>>> Username - you enter username to connect to Oracle ( oracle user you
>>> created in database ) Password - password of user Service - this is
>>> service name for Oracle database, depends of type of client and
>>> configuration
>>> for example for xe you can enter: //localhost/xe
>>> or tns name if you configured it in your oracle client
>> software
>>> there is more in readme.txt on download page
>>>
>>> OracleSchema - leave it empty and it will show all spatial tables,
>>> or
>
>>> you enter Oracle schema name and you got tables just from that
> schema.
>>>
>>> If I wasn't clear enough, please ask again :)
>>>
>>> Haris
>>>
>>> -----Original Message-----
>>> From: Joel Carranza [mailto:jec at gatekeeper.com]
>>> Sent: Friday, October 20, 2006 6:20 PM
>>> To: users at mapguide.osgeo.org
>>> Subject: [mapguide-users] FDO King.Oracle provider 0.3
>>>
>>>
>>> I have downloaded and installed the new Open Source v1.0.2 release
>>> of
>
>>> MapGuide, along with the King.Oracle FDO. FDO shows up in my list of
>>> providers, but when I get to the "Configure Feature Resource using
>>> Generic Editor" screen, I can't figure out how to specify my
>>> connection properties.
>>> There is a list in the window with Property/Value pairs, but I can't
>>> seem to figure out how to edit that list.
>>>
>>> Am I missing something obvious here?
>>>
>>> Thanks
>>> Joel
>>> --
>>> View this message in context:
>>> http://www.nabble.com/FDO-King.Oracle-provider-0.3-tf2481642.html#a6
>>> 9
>>> 2
>>> 01
>>> 21
>>> Sent from the OSGeo MapGuide mailing list archive at Nabble.com.
>>>
>>>
>>> --------------------------------------------------------------------
>>> - To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
>>> For additional commands, e-mail: users-help at mapguide.osgeo.org
>>>
>>>
>>> --------------------------------------------------------------------
>>> - To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
>>> For additional commands, e-mail: users-help at mapguide.osgeo.org
>>>
>>>
>>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/FDO-King.Oracle-provider-0.3-tf2481642.html#a69
>> 2
>> 09
>> 60
>> Sent from the OSGeo MapGuide mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
>> For additional commands, e-mail: users-help at mapguide.osgeo.org
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
>> For additional commands, e-mail: users-help at mapguide.osgeo.org
>>
>>
>>
>
> --
> View this message in context:
> http://www.nabble.com/FDO-King.Oracle-provider-0.3-tf2481642.html#a692
> 38
> 39
> Sent from the OSGeo MapGuide mailing list archive at Nabble.com.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
> For additional commands, e-mail: users-help at mapguide.osgeo.org
>
>
>
--
View this message in context:
http://www.nabble.com/FDO-King.Oracle-provider-0.3-tf2481642.html#a69245
89
Sent from the OSGeo MapGuide mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org
More information about the Mapguide-users
mailing list