AutoGenarated in Integration Studio is not working on Oracle DB?

AutoGenarated in Integration Studio is not working on Oracle DB?

  

Hi there,


I was trying to connect external DB and do Create action.

My problem is, In integration Studio, I set one of the column as identifier and set it as AutoGenarated.

And when I tried to create a new data on Service Studio with indentifier as Nullidentifier(), 

it's return error as my Id is NULL. 

I am using the default CreateOrUpdate action that automatically created when consume the entity.


My column identifier Original Type is NUMBER(9,0) set DataType as Integer.


So my questions are, 

1. Is AutoGenerated funtion in integration Studio support in Oracle DB?

2. If the above question's answer is 'Yes', please tell me how to set up Identifier.


Thank you in advance.


Yes,

I think you have done everything correctly.

can you provide a screenshot?


Solution

Hi Chaiwat,


Setting the AutoGenerated in a attribute of an external database means that the table in the external database will have either an identity or on before insert trigger that will automatically calculate the identifier for you. So when AutoGenerated is set the platform does not attempt to fill that attribute.


Regards,
João Rosado

Solution

João Rosado wrote:

Hi Chaiwat,


Setting the AutoGenerated in a attribute of an external database means that the table in the external database will have either an identity or on before insert trigger that will automatically calculate the identifier for you. So when AutoGenerated is set the platform does not attempt to fill that attribute.


Regards,
João Rosado

Thank you very much. It's work like a charm.