Rollback not working with JDBC when error occur

[Kapil Dhakad]

Hi,

I am using MySQL with JDBC. For connectivity I am using MySQL ConnectorJ
I have to execute group of statements. Like

insert into table1 ( pri_key, val1, val2, ...... );
insert into table 2 (pri_key_of_table1, ....... );
insert into table 3 (pri_key_of_table1, ....... );
insert into table 4 (pri_key_of_table1, ....... );

I am not interested in making batch of these statement because result of first query will use for insertion of record in other tables.

My question is...
============
During insertion using JDBC.. if any error occur then all insertion should rollback. Currently code is like

try {
con.setAutoCommit(false);
.
.
pst1.executeUpdate(insert_statement_1);
.
.
pst2.executeUpdate(inserst_statement_2);
.
.
con.commit();
}
catch(Exception e)
{
con.rollback();
e.printStatckTrace();
}

But it seems that above code for rollback is not working.
Please require help urgently

Thanks in advance
- Kapil Dhakad