[api] set the transaction isolation level for test api

This should get some more tests through - the multiple forks
of the API are a bigger problem than anticipated. Hopefully
this will soon fade out