[fdo-internals] King Oracle Issue
Haris Kurtagic
haris at sl-king.com
Wed Jun 10 17:00:37 EDT 2009
For tables which are not in sdo_geom_metadata you need to add them using
"KingFdoClass" table
(http://www.sl-king.com/fdooracle/KingFdoClass.htm).
One reason I can remember right now for not working, would be because
FDO schema is cached. You would need to restart provider ( there is also
non-standard FDO function in King.Oracle connection).
Haris
From: fdo-internals-bounces at lists.osgeo.org
[mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Thomas
Knoell
Sent: Wednesday, June 10, 2009 10:13 PM
To: 'FDO Internals Mail List'
Subject: RE: [fdo-internals] King Oracle Issue
Hi Haris,
Here are the answers to your questions:
>> How did you applied schema ? You mention feature and non-feature
class ?
I executed the apply schema command (see below) from the FDO
application. The schema that is defined and then applied contains a
FdoFeatureClass and FdoClass. The application has to work with data
stores that contain tables with and without spatial information and must
be able to maintain them. That is why the test schema contains both
classes.
>> You applied Autodesk schema , metadata tables?
The original data store did not contain any tables. However, since you
mentioned it here, I added the f_* tables and tried it again - same
result.
>> In King.Oracle for Oracle Table to become available as FDO class the
table has to be in sdo_geom_metadata . You did that ?
>> Of 'course Oracle user you are using to connect has to see those
tables etc...
Since the schema was applied with the FdoIApplySchema interface, this
should have been taken care of automatically. I checked and the feature
class table does show up in sdo_geom_metadata. Obviously, the non
feature class does not. And the Oracle user the application is
connecting to can see those tables. So, are you saying that if I connect
to an Oracle data store that does have tables without spatial
information, I would not be able to use the insert/delete/update
commands to maintain them when working with the King Oracle provider?
Thanks
Thomas
FdoPtr<FdoIApplySchema> apply_schema_cmd =
(FdoIApplySchema*) fdo_connection->CreateCommand(
FdoCommandType_ApplySchema);
FdoPtr<FdoFeatureSchemaCollection> schemas =
FdoFeatureSchemaCollection::Create(NULL);
FdoPtr<FdoFeatureSchema> schema =
FdoFeatureSchema::Create(L"TestSchema", L"Test Schema");
FdoPtr<FdoClassCollection> classes = schema->GetClasses();
printf(" -> Defining feature class fc \n");
FdoPtr<FdoFeatureClass> fc_class =
FdoFeatureClass::Create(L"fc", L"fc");
fc_class->SetIsAbstract(false);
FdoPropertyDefinitionCollection *data_property_definitions =
fc_class->GetProperties();
FdoDataPropertyDefinitionCollection *id_property_definitions =
fc_class->GetIdentityProperties();
FdoDataPropertyDefinition *data_property_definition =
FdoDataPropertyDefinition::Create(L"IdProp",
L"IdProp");
data_property_definition->SetDataType(FdoDataType_Int64);
data_property_definition->SetNullable(false);
data_property_definition->SetIsAutoGenerated(true);
data_property_definitions->Add(data_property_definition);
id_property_definitions->Add(data_property_definition);
FDO_SAFE_RELEASE(data_property_definition);
data_property_definition =
FdoDataPropertyDefinition::Create(L"Prop1",
L"Prop1");
data_property_definition->SetDataType(FdoDataType_Int32);
data_property_definition->SetNullable(true);
data_property_definition->SetIsAutoGenerated(false);
data_property_definitions->Add(data_property_definition);
FDO_SAFE_RELEASE(data_property_definition);
FdoGeometricPropertyDefinition *geometric_property_definition =
FdoGeometricPropertyDefinition::Create(L"GProp",L"GProp");
geometric_property_definition->SetGeometryTypes(
FdoGeometricType_Point
|
FdoGeometricType_Curve
|
FdoGeometricType_Surface
|
FdoGeometricType_Solid
);
geometric_property_definition->SetHasElevation(true);
data_property_definitions->Add(geometric_property_definition);
fc_class->SetGeometryProperty(geometric_property_definition);
FDO_SAFE_RELEASE(geometric_property_definition);
FDO_SAFE_RELEASE(id_property_definitions);
FDO_SAFE_RELEASE(data_property_definitions);
fc_class->SetBaseClass(NULL);
classes->Add(fc_class);
printf(" -> Defining non feature class nfc \n");
FdoPtr<FdoClass> nfc_class = FdoClass::Create(L"nfc", L"nfc");
nfc_class->SetIsAbstract(false);
data_property_definitions = nfc_class->GetProperties();
id_property_definitions = nfc_class->GetIdentityProperties();
data_property_definition =
FdoDataPropertyDefinition::Create(L"IdProp",
L"IdProp");
data_property_definition->SetDataType(FdoDataType_Int32);
data_property_definition->SetNullable(false);
data_property_definition->SetIsAutoGenerated(false);
data_property_definitions->Add(data_property_definition);
id_property_definitions->Add(data_property_definition);
FDO_SAFE_RELEASE(data_property_definition);
data_property_definition =
FdoDataPropertyDefinition::Create(L"Prop1",
L"Prop1");
data_property_definition->SetDataType(FdoDataType_Int32);
data_property_definition->SetNullable(true);
data_property_definition->SetIsAutoGenerated(false);
data_property_definitions->Add(data_property_definition);
FDO_SAFE_RELEASE(data_property_definition);
FDO_SAFE_RELEASE(id_property_definitions);
FDO_SAFE_RELEASE(data_property_definitions);
nfc_class->SetBaseClass(NULL);
classes->Add(nfc_class);
schemas->Add(schema);
printf(" -> Applying the schema \n");
apply_schema_cmd->SetFeatureSchema(schema);
apply_schema_cmd->Execute();
From: fdo-internals-bounces at lists.osgeo.org
[mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Haris
Kurtagic
Sent: June-10-09 3:28 PM
To: FDO Internals Mail List
Subject: RE: [fdo-internals] King Oracle Issue
How did you applied schema ? You mention feature and non-feature class ?
You applied Autodesk schema , metadata tables?
In King.Oracle for Oracle Table to become available as FDO class the
table has to be in sdo_geom_metadata . You did that ?
Of 'course Oracle user you are using to connect has to see those tables
etc...
Haris
From: fdo-internals-bounces at lists.osgeo.org
[mailto:fdo-internals-bounces at lists.osgeo.org] On Behalf Of Thomas
Knoell
Sent: Wednesday, June 10, 2009 8:42 PM
To: fdo-internals at lists.osgeo.org
Subject: [fdo-internals] King Oracle Issue
Hi,
I am working on a FDO based application that should use the King Oracle
Provider to connect to a data source on an Oracle 11g instance. The
application currently connects fine to an empty data store (the data
store does not contain any tables) and successfully applies a test
schema that consists of a feature and a non feature class. The problem
arises in the following step where a describe schema request is
executed. In this case, the result is one schema named KingOra and no
classes. I expected the test schema and its corresponding classes being
reported.
The application has access to all the DLLs that come with FDO. The DLLs
were created by compiling the projects from the trunk in release mode.
Due to the fact that I use MS Visual Studio C++ 2008 Express Edition, I
had to open each solution and compile it separately as some of the
projects referenced MFC files that are not available with the Express
Edition. Those issues were corrected in the shadow and all builds
succeeded.
Besides the changes to eliminate MFC references, one additional change
was required in the King Oracle provider project in that the references
to Oracle 10 libs were replaced by the corresponding Oracle 11 ones.
Using the command built.bat -c=release -a=install -o=c:\FdoHome on the
FDO and ThirdParty directory, all DLLs were copied into the specified
folder and hence made accessible to the FDO application.
The providers.xml file was modified to include the following statement
for the King Oracle Provider:
<FeatureProvider>
<Name>King.Oracle.3.5</Name>
<DisplayName>King Provider for Oracle</DisplayName>
<Description>Read/write access to spatial and attribute data in an
Oracle Spatial.</Description>
<IsManaged>False</IsManaged>
<Version>3.5.0.0</Version>
<FeatureDataObjectsVersion>3.5.0.0</FeatureDataObjectsVersion>
<LibraryPath>.\KingOracleProvider.dll</LibraryPath>
</FeatureProvider>
I did perform some debugging on the code. When following the statement
that retrieves the schema name (see code below), I noted that it does
not hit the function that implements the retrieval of the schema name
but ends up in the function FdoCollection::GetCount() (file
FDO\Unmanaged\Inc\Common\Collection.h). However, following other
requests like the apply schema execute or the describe schema execute
call, the correct functions are hit and executed. I also did some
dependency checks on some DLLs and executables and nothing missing was
reported.
I assume that this may be just a simple setup issue but after trying
multiple things now, I reached a point where I am not sure what to try
next. If someone has any suggestions I would appreciate the feedback.
Also, if there are additional questions, please let me know.
Thanks
Thomas
FdoPtr<FdoIDescribeSchema> describe_schema_cmd =
(FdoIDescribeSchema*) fdo_connection->CreateCommand(
FdoCommandType_DescribeSchema);
FdoFeatureSchemasP schema_collection =
describe_schema_cmd->Execute();
FdoInt32 schema_count = schema_collection->GetCount();
if (schema_count == 0)
printf(" -> No schemas found \n");
else
for (int s = 0; s < schema_count; s++) {
FdoFeatureSchemaP curr_schema = schema_collection->GetItem(s);
FdoStringP curr_schema_name = curr_schema->GetName();
printf(" -> Schema[%d]: %ls \n", s, (FdoString
*)curr_schema_name);
FdoPtr<FdoClassCollection> curr_schema_classes =
curr_schema->GetClasses();
FdoInt32 curr_schema_class_count =
curr_schema_classes->GetCount();
if (curr_schema_class_count == 0)
printf(" -> No classes found for current schema \n");
else
for (int sc = 0; sc < curr_schema_class_count; sc++) {
FdoPtr<FdoClassDefinition> curr_schema_class =
curr_schema_classes->GetItem(sc);
FdoStringP curr_schema_class_name =
curr_schema_class->GetName();
printf(" -> Class[%d]: %ls \n",
sc,
(FdoString *)curr_schema_class_name);
} // for (int sc = 0; ...
} // for (int s = 0; ...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-internals/attachments/20090610/33167e6a/attachment-0001.html
More information about the fdo-internals
mailing list