Menu

#70 [Python]Rollback method can't normally work

open
nobody
None
5
2012-02-01
2012-02-01
Jira Trac
No

Test Build:CUBRID 2008 R4.1 (8.4.1.0559) (64bit release build for linux_gnu)
OS: Linux 64
Description: CUBRID 2008 R4.1 (8.4.1.0559) (64bit release build for linux_gnu)

Repro Steps:
python execute_rollback.py pydb 33012

Statements in execute_rollback.py
{noformat}
dbname=sys.argv[1]
port=sys.argv[2]
url='CUBRID:localhost:' + port + : + dbname+::?autocommit=false
print url
con=CUBRIDdb.connect(url)
#con=CUBRIDdb.connect(CUBRID:localhost:33012:pydb:dba::?autocommit=false)

cursor=con.cursor()
cursor.execute (DROP TABLE IF EXISTS rollback_tb)
cursor.execute ( CREATE TABLE rollback_tb(id int primary key, a int) )
con.commit()

cursor.execute ( insert into rollback_tb values(22, 222222) )
con.rollback()

cursor.execute (select * from rollback_tb )
result_set = cursor.fetchall ()
for row in result_set:
print %s, %s % (row[0], row[1])
print rollback and close
{noformat}

Actual result:
{noformat}
Connect to db
CUBRID:localhost:33012:pydb::?autocommit=false
22, 222222
rollback and close

reconnect
22, 222222
{noformat}

Expect result:
the result of inquiring is empty

Discussion

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.