Skip to Content (Press Enter)
UserImage.jpg
Chaiwat Meetanatharvorn
41Views
3Comments
Solved
AutoGenarated in Integration Studio is not working on Oracle DB?
Question
IntegrationStudio

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.


0
0
31 Mar 2017
Copy Link
2012-03-16 12-21-09
João Rosado
Staff
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

See solution in context
0
0
01 Apr 2017
Copy Link
UserImage.jpg
Chaiwat Meetanatharvorn

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.


0
0
14 Apr 2017
Copy Link
2016-04-21 20-09-55
J.
 
MVP

Yes,

I think you have done everything correctly.

can you provide a screenshot?


0
0
31 Mar 2017
Copy Link
2012-03-16 12-21-09
João Rosado
Staff
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

0
0
01 Apr 2017
Copy Link
UserImage.jpg
Chaiwat Meetanatharvorn

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.


0
0
14 Apr 2017
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.