A Query when using EJB Container Manestaged Transaction

[Ravi Kiran Va]

Hi
I am sorry for the haeding of the question ( I could not think better).

I am using EJB ContainerManaged Transaction suppourt on to my Application .
Hi i am doing a insert operation.This insert operation involves inserting into two tables .

For example :

insert into buses('ds'.'dsa')
insert into DTR('ds'.'dsa')

The requirement is
Insertion for the buses table should be done first and then insertion into DTR table should happen.(Both of these statemets are in the same method.)

The scenario is that , if the insert for the DTR table fails due to Runtime data passed , i want to rollback the insertion that happened on to the buses table .
How can i do this
(If it is related to JDBC i would have set

con.setAutoCommit(flase) 

But what in this case??
Please suggest your ideas .

[Jaikiran Pai]

Are you using a transaction aware resource (like a datasource) to do the database operations in the EJB method? Or are you using plain JDBC APIs to do the operations?

[Ravi Kiran Va]

Hi

My application is related to JPA , and i am using DataSource for this .