[fdo-users] Oracle KINGFdo new feature saving problem

[tomislav.obad]

Hi.

I have problem with saving new data into Oracle view.

I'm using following setup:
Oracle 10g XE
AutoCAD Map 2010
metadata table used for KINGFdo (like myfdoclass)
Oracle view with insert and update triggers (I had to make triggers because
AutoCAD and other tools are trying to update all tables that are in view
instead of only base table).

When I'm editing geometry in view and make a check-in table updates without
problem.
But when I'm trying to save feature that I've drawed in AutoCAD, filled its
alphanumeric attributes I get the following error:

<Error code="200" type="5" dispensation="3" sId="2" occurrence="1">
  Feature was not saved in the target feature source. 
- <Parameters>
- <Parameter classId="0" position="0">
  <Message>2=c_KgOraFeatureReaderInsert::GetDouble DataType not
FdoDataType_Int64!</Message> 
  <SQL /> 
  </Parameter>
- <Parameter classId="0" position="0">
  <Message>1=Failed to execute Fdo command.</Message> 
  <SQL /> 
  </Parameter>
- <Parameter classId="0" position="0">
  <Message>Failed to insert feature.</Message> 
  <SQL /> 
  </Parameter>
- <Parameter classId="0" position="0">
  <Message>KingOra:PP_OBJEKT_V (), Rev# <0></Message> 
  <SQL /> 
  </Parameter>
  </Parameters>
  <Entry code="1" type="15" sId="3" occurrence="1">Failed to save some
features.</Entry> 
  <Entry code="1" type="15" sId="4" occurrence="1">Failed to save edit
set.</Entry> 
  </Error>

When I try to do the same thing in Kosmo (OpenJump) it works.

Interesting is that actually the feature gets saved into database. But I
have to delete layer from AutoCAD and re-add the view into map.

Thanks in advance

Tomislav Obad
-- 
View this message in context: http://n2.nabble.com/Oracle-KINGFdo-new-feature-saving-problem-tp4162987p4162987.html
Sent from the FDO Users mailing list archive at Nabble.com.