<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:windowtext;
font-weight:normal;
font-style:normal;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:#1F497D;
font-weight:normal;
font-style:normal;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:#1F497D;
font-weight:normal;
font-style:normal;}
span.EmailStyle23
{mso-style-type:personal;
font-family:"Times New Roman","serif";
color:#1F497D;
font-weight:normal;
font-style:normal;}
span.EmailStyle24
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:481697453;
mso-list-type:hybrid;
mso-list-template-ids:1425941898 269025291 269025283 269025285 269025281 269025283 269025285 269025281 269025283 269025285;}
@list l0:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:\F0D8;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;
font-family:Wingdings;
mso-fareast-font-family:"Times New Roman";
mso-bidi-font-family:"Times New Roman";}
@list l0:level2
{mso-level-tab-stop:1.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level3
{mso-level-tab-stop:1.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level4
{mso-level-tab-stop:2.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level5
{mso-level-tab-stop:2.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level6
{mso-level-tab-stop:3.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level7
{mso-level-tab-stop:3.5in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level8
{mso-level-tab-stop:4.0in;
mso-level-number-position:left;
text-indent:-.25in;}
@list l0:level9
{mso-level-tab-stop:4.5in;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>Hi Tomas,<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Regarding names of FDO classes and
their representation in underlying data store is something which could be pain
but I don't see right solution (other then use of additional metadata to describe
generated name for FDO class). It is not only problem of King.Oracle or rdbms providers
but also files. There are some steps in King.Oracle that could create names of
FDO classes which would more look like original, but no 100% solution.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>KingFdoClass is metadata table
which works and we use it a lot. You need to add row to it after creating table
in Oracle. Row in KingFdoClass metadata table will not be auto added with apply
schema command. <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>- Schema is cached because of
performance reasons. Right now it is necessary because of extensive use of DescribeSchema
command by current FDO clients. I would much more prefer that schema would not
be cached but right now it would not be practical.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>- Perhaps we changed something. As
far as I remember it was different schema. <o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>- I was thinking about auto-updating
metadata table with apply schema. But there are few scenarios in which it would
not be possible. Also trough our experience of use of provider in our projects
we realized we don't need it.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Haris<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-internals-bounces@lists.osgeo.org
[mailto:fdo-internals-bounces@lists.osgeo.org] <b>On Behalf Of </b>Thomas
Knoell<br>
<b>Sent:</b> Monday, June 15, 2009 9:43 PM<br>
<b>To:</b> 'FDO Internals Mail List'<br>
<b>Subject:</b> RE: [fdo-internals] King Oracle Issue<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:10.0pt;font-family:"Times New Roman","serif"'>Hi Haris,<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:10.0pt;font-family:"Times New Roman","serif"'>I got by the
describe schema issue I had with the King Oracle provider. Executing the
describe schema command after applying the schema now works fine.<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:10.0pt;font-family:"Times New Roman","serif"'>One thing that
is unpleasant is the fact that the describe-schema implementation in the
provider returns class names for feature classes that do not match the original
class name: the new name is a combination of data store, class and geometry
property name, all concatenated by a hyphen (for example <i>DB1~MYCLASS~GEOM</i>).
That means that the application needs a provider specific implementation where
the original class name can be mapped to the one the King Oracle provider uses.
<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:10.0pt;font-family:"Times New Roman","serif"'>The link you
provided in a previous mail describes a possibility to define a new class name
of an existing geometry table using a King Oracle meta data table and hence
providing a workaround to the fact that feature class names are altered. I
applied this to the feature classes I created with the apply-schema command but
it did not work: rather than replacing the name (for example) <i>DB1~MYCLASS~GEOM</i>
with <i>NewClass</i>, it actually returns two classes now: <i>DB1~MYCLASS~GEOM</i>
and <i>NewClass</i> (for which no table actually exists). Since the site you
point to mentions that this option is in a BETA release status, I assume that
either this may not be supported yet or I had an incorrect expectation. Could
you please comment on this.<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:10.0pt;font-family:"Times New Roman","serif"'>There are a
couple of other issues with this meta data table:<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2;
text-autospace:none'><![if !supportLists]><span lang=EN-CA style='font-size:
10.0pt;font-family:Wingdings'><span style='mso-list:Ignore'>Ø<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'>I
updated the meta data table from the application after successfully applying
the schema. Unfortunately, to have those changes take effect, I have to close
and re-open the connection. before executing the describe schema command. I
believe this should not be necessary.<o:p></o:p></span></p>
<p class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo2;
text-autospace:none'><![if !supportLists]><span lang=EN-CA style='font-size:
10.0pt;font-family:Wingdings'><span style='mso-list:Ignore'>Ø<span
style='font:7.0pt "Times New Roman"'> </span></span></span><![endif]><span
lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'>Your site
states that non feature classes identified via the meta data table belong to a
schema named <i>KingFdoClass</i>. This is currently not the case as those
classes are listed as members of the schema <i>KingOra</i>. Will this change
for the final release?<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:10.0pt;font-family:"Times New Roman","serif"'>In my last mail
I asked whether or not you plan to automatically maintain the meta data table
if a schema is applied. Can you please comment on this as well?<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:10.0pt;font-family:"Times New Roman","serif"'>Thanks<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:10.0pt;font-family:"Times New Roman","serif"'> Thomas<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-internals-bounces@lists.osgeo.org
[mailto:fdo-internals-bounces@lists.osgeo.org] <b>On Behalf Of </b>Thomas
Knoell<br>
<b>Sent:</b> June-10-09 5:21 PM<br>
<b>To:</b> 'FDO Internals Mail List'<br>
<b>Subject:</b> RE: [fdo-internals] King Oracle Issue<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><span lang=EN-CA><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>Hi Haris,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>Thanks for the provided link, that is helpful.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>I created the table, added the information to the connection
string and executed the test. I noted that the ApplySchema command is not
adding any specified non feature classes to that table. Since the link you
provided indicates that this is in Beta release at this point, is your final
version enhancing your ApplySchema command implementation to automatically
update this table for non feature classes?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>Thanks<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'> Thomas<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-internals-bounces@lists.osgeo.org
[mailto:fdo-internals-bounces@lists.osgeo.org] <b>On Behalf Of </b>Haris
Kurtagic<br>
<b>Sent:</b> June-10-09 5:01 PM<br>
<b>To:</b> FDO Internals Mail List<br>
<b>Subject:</b> RE: [fdo-internals] King Oracle Issue<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><span lang=EN-CA><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>For tables which are not in
sdo_geom_metadata you need to add them using "KingFdoClass" table (</span><a
href="http://www.sl-king.com/fdooracle/KingFdoClass.htm">http://www.sl-king.com/fdooracle/KingFdoClass.htm</a>)<span
style='color:#1F497D'>.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>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).<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Haris<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> fdo-internals-bounces@lists.osgeo.org
[mailto:fdo-internals-bounces@lists.osgeo.org] <b>On Behalf Of </b>Thomas
Knoell<br>
<b>Sent:</b> Wednesday, June 10, 2009 10:13 PM<br>
<b>To:</b> 'FDO Internals Mail List'<br>
<b>Subject:</b> RE: [fdo-internals] King Oracle Issue<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>Hi Haris,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>Here are the answers to your questions:<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>>> </span><span style='color:#1F497D'>How did you applied
schema ? You mention feature and non-feature class ?</span><span
style='font-size:10.0pt;font-family:"Times New Roman","serif";color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>>> </span><span style='color:#1F497D'>You applied Autodesk
schema , metadata tables?</span><span style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>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. <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>>> </span><span style='color:#1F497D'>In King.Oracle for
Oracle Table to become available as FDO class the table has to be in
sdo_geom_metadata . You did that ?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>>> Of 'course Oracle user
you are using to connect has to see those tables etc...<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>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?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'>Thanks<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'> Thomas<o:p></o:p></span></p>
<div style='border:none;border-bottom:double windowtext 2.25pt;padding:0in 0in 1.0pt 0in'>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoPtr<FdoIApplySchema> apply_schema_cmd = <o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
(FdoIApplySchema*) fdo_connection->CreateCommand(<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoCommandType_ApplySchema);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoPtr<FdoFeatureSchemaCollection> schemas =<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoFeatureSchemaCollection::Create(NULL);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoPtr<FdoFeatureSchema> schema =<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoFeatureSchema::Create(L"TestSchema", L"Test Schema");<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoPtr<FdoClassCollection> classes = schema->GetClasses();<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
printf(" -> Defining feature class fc \n");<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoPtr<FdoFeatureClass> fc_class = FdoFeatureClass::Create(L"fc",
L"fc");<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
fc_class->SetIsAbstract(false);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoPropertyDefinitionCollection *data_property_definitions =<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
fc_class->GetProperties();<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoDataPropertyDefinitionCollection *id_property_definitions =<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
fc_class->GetIdentityProperties();<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoDataPropertyDefinition *data_property_definition =<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoDataPropertyDefinition::Create(L"IdProp", L"IdProp");<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definition->SetDataType(FdoDataType_Int64);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definition->SetNullable(false);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definition->SetIsAutoGenerated(true);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definitions->Add(data_property_definition);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
id_property_definitions->Add(data_property_definition);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FDO_SAFE_RELEASE(data_property_definition);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definition =<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoDataPropertyDefinition::Create(L"Prop1", L"Prop1");<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definition->SetDataType(FdoDataType_Int32);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definition->SetNullable(true);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definition->SetIsAutoGenerated(false);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definitions->Add(data_property_definition);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FDO_SAFE_RELEASE(data_property_definition);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoGeometricPropertyDefinition *geometric_property_definition =<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoGeometricPropertyDefinition::Create(L"GProp",L"GProp");<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
geometric_property_definition->SetGeometryTypes(<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoGeometricType_Point | <o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoGeometricType_Curve | <o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoGeometricType_Surface | <o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoGeometricType_Solid );<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
geometric_property_definition->SetHasElevation(true);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definitions->Add(geometric_property_definition);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
fc_class->SetGeometryProperty(geometric_property_definition);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FDO_SAFE_RELEASE(geometric_property_definition);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FDO_SAFE_RELEASE(id_property_definitions);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FDO_SAFE_RELEASE(data_property_definitions);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
fc_class->SetBaseClass(NULL);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
classes->Add(fc_class);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
printf(" -> Defining non feature class nfc \n");<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoPtr<FdoClass> nfc_class = FdoClass::Create(L"nfc",
L"nfc");<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
nfc_class->SetIsAbstract(false);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definitions = nfc_class->GetProperties();<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
id_property_definitions = nfc_class->GetIdentityProperties();<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definition =<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoDataPropertyDefinition::Create(L"IdProp", L"IdProp");<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definition->SetDataType(FdoDataType_Int32);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definition->SetNullable(false);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definition->SetIsAutoGenerated(false);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definitions->Add(data_property_definition);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
id_property_definitions->Add(data_property_definition);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FDO_SAFE_RELEASE(data_property_definition);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definition =<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoDataPropertyDefinition::Create(L"Prop1", L"Prop1");<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definition->SetDataType(FdoDataType_Int32);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definition->SetNullable(true);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definition->SetIsAutoGenerated(false);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
data_property_definitions->Add(data_property_definition);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FDO_SAFE_RELEASE(data_property_definition);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FDO_SAFE_RELEASE(id_property_definitions);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FDO_SAFE_RELEASE(data_property_definitions);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
nfc_class->SetBaseClass(NULL);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
classes->Add(nfc_class);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
schemas->Add(schema);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
printf(" -> Applying the schema \n");<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
apply_schema_cmd->SetFeatureSchema(schema);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
apply_schema_cmd->Execute();<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-internals-bounces@lists.osgeo.org
[mailto:fdo-internals-bounces@lists.osgeo.org] <b>On Behalf Of </b>Haris
Kurtagic<br>
<b>Sent:</b> June-10-09 3:28 PM<br>
<b>To:</b> FDO Internals Mail List<br>
<b>Subject:</b> RE: [fdo-internals] King Oracle Issue<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><span lang=EN-CA><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>How did you applied schema ? You
mention feature and non-feature class ? You applied Autodesk schema , metadata
tables?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>In King.Oracle for Oracle Table
to become available as FDO class the table has to be in sdo_geom_metadata . You
did that ?<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Of 'course Oracle user you are
using to connect has to see those tables etc...<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Haris<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
fdo-internals-bounces@lists.osgeo.org [mailto:fdo-internals-bounces@lists.osgeo.org]
<b>On Behalf Of </b>Thomas Knoell<br>
<b>Sent:</b> Wednesday, June 10, 2009 8:42 PM<br>
<b>To:</b> fdo-internals@lists.osgeo.org<br>
<b>Subject:</b> [fdo-internals] King Oracle Issue<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'>Hi,<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'>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 <i>KingOra</i> and no classes. I expected the test schema and its
corresponding classes being reported.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'>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. <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'>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. <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'>Using
the command <i>built.bat –c=release –a=install –o=c:\FdoHome</i>
on the FDO and ThirdParty directory, all DLLs were copied into the specified folder
and hence made accessible to the FDO application.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'>The
providers.xml file was modified to include the following statement for the King
Oracle Provider:<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:9.0pt;font-family:"Courier New"'>
<FeatureProvider><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:9.0pt;font-family:"Courier New"'>
<Name>King.Oracle.3.5</Name> <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:9.0pt;font-family:"Courier New"'>
<DisplayName>King Provider for Oracle</DisplayName> <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:9.0pt;font-family:"Courier New"'>
<Description>Read/write access to spatial and attribute data
in an Oracle Spatial.</Description> <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:9.0pt;font-family:"Courier New"'>
<IsManaged>False</IsManaged> <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:9.0pt;font-family:"Courier New"'>
<Version>3.5.0.0</Version> <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:9.0pt;font-family:"Courier New"'>
<FeatureDataObjectsVersion>3.5.0.0</FeatureDataObjectsVersion>
<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:9.0pt;font-family:"Courier New"'>
<LibraryPath>.\KingOracleProvider.dll</LibraryPath> <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:9.0pt;font-family:"Courier New"'>
</FeatureProvider><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'>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 <i>FdoCollection::GetCount()</i> (file <i>FDO\Unmanaged\Inc\Common\Collection.h</i>).
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.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'>Thanks<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'>
Thomas<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<div style='border:none;border-bottom:double windowtext 2.25pt;padding:0in 0in 1.0pt 0in'>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
</div>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoPtr<FdoIDescribeSchema> describe_schema_cmd = <o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
(FdoIDescribeSchema*) fdo_connection->CreateCommand(<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoCommandType_DescribeSchema);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoFeatureSchemasP schema_collection = describe_schema_cmd->Execute();<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoInt32 schema_count = schema_collection->GetCount();<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
if (schema_count == 0)<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
printf(" -> No schemas found \n");<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
else<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
for (int s = 0; s < schema_count; s++) {<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoFeatureSchemaP curr_schema = schema_collection->GetItem(s);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoStringP curr_schema_name = curr_schema->GetName();<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
printf(" -> Schema[%d]: %ls \n", s, (FdoString
*)curr_schema_name);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoPtr<FdoClassCollection> curr_schema_classes =<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
curr_schema->GetClasses();<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoInt32 curr_schema_class_count = curr_schema_classes->GetCount();<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
if (curr_schema_class_count == 0)<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
printf(" -> No classes found for current schema
\n");<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
else <o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
for (int sc = 0; sc < curr_schema_class_count; sc++) {<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoPtr<FdoClassDefinition> curr_schema_class =<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
curr_schema_classes->GetItem(sc);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
FdoStringP curr_schema_class_name = curr_schema_class->GetName();<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
printf(" -> Class[%d]: %ls \n",<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
sc,<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
(FdoString *)curr_schema_class_name);<o:p></o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
} <span style='color:green'>// for (int sc = 0; ...<o:p></o:p></span></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New";color:green'><o:p> </o:p></span></p>
<p class=MsoNormal style='text-autospace:none'><span lang=EN-CA
style='font-size:9.0pt;font-family:"Courier New"'>
} <span style='color:green'>// for (int s = 0; ...<o:p></o:p></span></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-CA style='font-size:10.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
</div>
</body>
</html>