[fdo-internals] Re: insert error control properties with KingOracle

[Simon Pelicon]

Hi!

If FDO Feature class has primary key defined and if it is of type NUMERIC
than King.Oracle provider will also check for Oracle Sequence to use for
primary key column. Sequence has to have a name like TableName_FDOSEQ to be
used by provider.
For table named RAIL sequence name of sequence is RAIL_FDOSEQ.
This sequence will be used by provider during inserts to populate value for
identity column. If value for identity is not set during insert than
provider will use next value from sequence to insert a row.
Simon


On Thu, Dec 1, 2011 at 1:58 PM, mdelsinne <mdelsinne at gmail.com> wrote:

> Hi,
>
> I have an improvement, although I get to build the structure in oracle with
> the primary key column and geometric, yet I still can not insert the values
> in other fields, and also I have a problem ID. I declare my property
> autogenerated ID but it says incorrect NULL value for the ID. I continued
> to
> look I'll let you know.
>
> Otherwise it looks in Oracle:
>
> ID (PK, NOT NULL, NUMBER(19))
> SDFKEY (VARCHAR2(255byte))
> NAME (VARCHAR2(255byte))
> URL (VARCHAR2(255byte))
> GEOM (SDO_GEOMETRY)
>
> This is normal?
>
>
> --
> View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/insert-error-control-properties-with-KingOracle-tp7046704p7050418.html
> Sent from the FDO Internals mailing list archive at Nabble.com.
> _______________________________________________
> fdo-internals mailing list
> fdo-internals at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/fdo-internals
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-internals/attachments/20111201/590cf7d1/attachment.html