recursive associations in LiveCycle Data Services

[Former Community Member]

I have a recursive associations in my table

    CREATE TABLE TMPADNAN
    (
      ID    NUMBER(10)                              NOT NULL,
      NAME  VARCHAR2(255 CHAR),
      MID   NUMBER(10)
    )
    ALTER TABLE TMPADNAN ADD (
      CONSTRAINT TMPADNAN_R01 
     FOREIGN KEY (MID) 
     REFERENCES TMPADNAN (ID));

I include it in my model and deploy it, next I add a datagrid and and generate a model driven form backed up by LCDS.

When ever I try to add a record I get this error as a popup in Flex:

    Error occurred completing a transaction
    null

and the following error in tomcat;

    [testAdnan]06/21/2010 18:22:27.679 [ERROR] [Service.Data.Transaction] Error whil
    e completing transaction: org.omg.CORBA.BAD_INV_ORDER: The Servant has not been
    associated with an ORB instance  vmcid: 0x0  minor code: 0  completed: No stackt
    race=org.omg.CORBA.BAD_INV_ORDER: The Servant has not been associated with an OR
    B instance  vmcid: 0x0  minor code: 0  completed: No
            at org.omg.PortableServer.Servant._get_delegate(Servant.java:35)
            at org.omg.PortableServer.Servant._poa(Servant.java:99)
            at org.objectweb.jotm._SubCoordinator_Tie.deactivate(Unknown Source)

I have populated the table by adding few rows directly into the table.

I use LCDS3.1/TOMCAT6/Flex4/ORACLE.

All help is appriciated

[TomCoppock]

Check in the source view for your data model - do you have any transaction settings?

Find the DMS annotation for the table in the model, and add / update the transactions settings to be:

        <annotation name="DMS" Table="dbo.table_name">
            <item name="use-transactions">false</item>
        </annotation>

This will instruct the Data Management Service not to use transactions when updating this table, avoiding the transaction is "null" error.

For more information on using Transactions in LCDS data models, see:

http://help.adobe.com/en_US/LiveCycleDataServicesES/3.1/Developing/WSc3ff6d0ea77859461172e0811f00f70...