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?
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.