Welcome Guest, Not a member yet? Register   Sign In
Transaction module issue
#1

[eluser]Unknown[/eluser]
Does any body know the answer to this?

I am trying to use the CI transaction feature using Oracle (oci8_driver). No matter how I set up the code, the record always gets committed. Any body knows why that may be. I placed some debug codes inside the oci8_driver and can see that the program reached the trans methods.
For example, the following lines does not work for me. The query always gets committed even though I explicitly roll back. Any advise.

Code:
$conn->trans_begin();
$conn->query($query, $array); //binding params

$conn->trans_rollback();

Please let me know if you need to see the actual query.

Also, please point me to other posts if you think this issue has been addressed elsewhere. Thank you.
#2

[eluser]Unknown[/eluser]
Hi I was with the same problem.
I solved this by removing all 'Select' statements that was inside the transaction.
I think this is something about the way the php oci8 driver works with transactions.
#3

[eluser]Unknown[/eluser]
Thanks GabrielCavalari for the reply.




Theme © iAndrew 2016 - Forum software by © MyBB