You have to investigate the reason it is rolling back... Is the process taking too long? Do the process have rights to update the database? Check SOA *diagnostic* log files...
Are you calling any procedure from DB?
I am actually pooling the database for inserts.