---Data Insertion failing using Nested CDT---

Hello,

Currently we are facing issues to insert data in Oracle database.
We are using nested CDT with OneTo Many relationship. While inserting data in the database, data get inserted in both the tables parent and child but child table has got null value in the foreign key column.
We are able to insert data with same approach in mysql database.
Any help is appreciated.

OriginalPostID-247231

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    @roshanr First of All, As per the best practices, we should not use Nested CDT rather than that we can have a column of type int and can store the generated Primary key of Parent into Child as Foreign key. Coming to your Concern, it will be easy to trace out the issue if you could share the screenshot of ri!cdt filed with data along with XSD configuration, and also the Screenshot of how actually you have stored the data using Smart Service. And Also please check the Server Log to get more details about the issue, However if you can share the screenshots, it will be easy to debug this problem statement. If you talk about MySQL, this supports AUTO_INCREMENT strategy for Primary key Generation where as Oracle do not
Reply
  • 0
    Certified Lead Developer
    @roshanr First of All, As per the best practices, we should not use Nested CDT rather than that we can have a column of type int and can store the generated Primary key of Parent into Child as Foreign key. Coming to your Concern, it will be easy to trace out the issue if you could share the screenshot of ri!cdt filed with data along with XSD configuration, and also the Screenshot of how actually you have stored the data using Smart Service. And Also please check the Server Log to get more details about the issue, However if you can share the screenshots, it will be easy to debug this problem statement. If you talk about MySQL, this supports AUTO_INCREMENT strategy for Primary key Generation where as Oracle do not
Children
No Data