# transaction.rb: How to use transactions
require 'config.rb'

# Create connections to Oracle
conn1 = OCI8.new(DB_USER, DB_PASSWORD, DB_SERVER)
conn2 = OCI8.new(DB_USER, DB_PASSWORD, DB_SERVER)

conn1.exec("DELETE FROM test_transaction")
conn1.exec("INSERT INTO test_transaction VALUES(1, 'old value')")
conn1.commit

#conn1.autocommit = true
puts "OCI8.autocommit = " + conn1.autocommit.to_s
puts "conn1 updated the name to 'something new'";
conn1.exec("UPDATE test_transaction SET name = 'something new' WHERE id = 1");
#conn1.commit

puts "conn2 got the name as '" + 
		conn2.exec('SELECT name FROM test_transaction WHERE id = 1').fetch[0] + "'"
	
conn1.logoff
conn2.logoff

puts '-'*80