1 Reply Latest reply on Mar 5, 2004 2:49 PM by Adrian Brock

    Oracle DataSource

    hoffz31 Newbie

      Is it possible to turn auto commit off in the data source file? I am getting an error using CMR. I keep getting can not insert null into the foreign key column after the initial insert. Does all foreign key columns have to be nullable to get CMR to work?

        • 1. Re: Oracle DataSource
          Adrian Brock Master

          This has nothing to do with auto-commit.
          It is spec defined behaviour that the insert occurs after ejbCreate and before
          ejbPostCreate. You can't even use CMR outside a transaction.

          You can delay the insert in recent versions using
          insert-after-ejb-post-create, see docs/dtd/jboss_3_2.dtd
          or use search in these forums.

          Regards,
          Adrian