transaction in stored procedure

[arun parajuli]

I am trying to write a stored procedure , which uses transaction,in MySql 5.0.2 alpha.

the following is a sample code.

create procedure test_db.test_proc(IN id int,IN name varchar(20) )
begin
start transaction;
--insert into table test1;

-- use some SQL which generates error.
commit;
end;

the table test is InnoDB

my broblem is
1) when error occurs, the procedure exits without rolling back( no commit either)the modifications and when i do rollback manually, it rolls back ( i.e the insertsion in the table test1 is undone). I want this automatic.
2)how can I know if any error occured or not ? I want to write a handler which can trap all errors, warnings etc so that i can use a rollback statement there

please somebody suggest me a solution.. Its killing me