FDO King.Oracle provider 0.3
Joel Carranza
jec at gatekeeper.com
Fri Oct 20 16:25:04 EDT 2006
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#a69
>>> 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#a692
>> 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#a69238
> 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#a6924589
Sent from the OSGeo MapGuide mailing list archive at Nabble.com.
More information about the Mapguide-users
mailing list