+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Transaction module issue (/showthread.php?tid=12341)
Transaction module issue - El Forum - 10-15-2008
[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.
Transaction module issue - El Forum - 01-20-2009
[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.
Transaction module issue - El Forum - 01-27-2009
[eluser]Unknown[/eluser]
Thanks GabrielCavalari for the reply.