how to trace sql statement issued by iplanet

[fox hk]

Hi All
l am migrating an application from other app server to iPlanet 6.5. l hit a hassle. My app always ran into TransactionRolledBackException as a use case deleted a record and then inserted a record with same primary key with the use of CMP. In fact, both delete / insert operations were done within same transaction. It is quite perplexing problem to me. l have enabled iPlanet 6.5's transaction monitoring and tracing feature. However, l found the info logged is not detailed enough. May l know is there any way to trace all sql statements issued by iPlanet for CMP ? It is very thankful one can share with me your knowledge on this issue.
regards
fox