Why my sql doesn't execute?

Question

I have a python script that needs to update a database information. So, in my init() method, I start the connection. But when I call the update method, the script does not give me any answer, it seems like it is into an infinite loop.

def update(self,id,newDescription):
     try:
         sql="""UPDATE table SET table.new_string=:1 WHERE table.id=:2"""                                                                               
         con=self.connection.cursor()
         con.execute(sql,(newDescription,id))
         con.close()
     except Exception,e:
         self.errors+=[str(e)]

What I've tried so far:

Change the query, just to see if the connection is alright. When I did that (I used 'SELECT info from table'), the script worked.
I thought that my query was wrong, but when I execute it in SQLDeveloper program, it goes right.

What can be happening?

Thanks

First, have you checked if you get any exceptions?

Lasse V. Karlsen
– Lasse V. Karlsen

2011-03-18 11:21:01 +00:00
Commented Mar 18, 2011 at 11:21 — Lasse V. Karlsen
– Lasse V. Karlsen, Commented Mar 18, 2011 at 11:21

Klaus Byskov Pedersen · Accepted Answer · 2011-03-18 11:22:03Z

2

You are forgetting to call commit.

answered Mar 18, 2011 at 11:22

Klaus Byskov Pedersen

122k31 gold badges192 silver badges222 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Frias Over a year ago

The script stops in the con.execute line.

dsmoljanovic · Accepted Answer · 2011-03-18 11:23:43Z

1

Not sure about how to do it in python script, but i think you need to call a "commit" before closing connection. Otherwise oracle rollsback your transaction.

Try adding con.commit() before close()

answered Mar 18, 2011 at 11:23

dsmoljanovic

1231 silver badge7 bronze badges

Collectives™ on Stack Overflow

Why my sql doesn't execute?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related