Oracle DataSource

[hoffz31]

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?

[adrian.brock]

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