my transaction is not working

[OmarB]

i tried to create a transaction using java:

try {
myConnection.setAutoCommit(false) ;
...
myConnection.commit() ;
}
catch(Exception exc) {
myConnection.rollback() ;
}
rollback isn't working ? why