[Springpython-developer] Query commits

[Robert Y. <ry...@mo...>]

I am attempting to implement the spring-python framework specifically the database templates piece.  I can get the select sql statements to work, but insert/update statements fail to commit.  I have noticed that in springpython.database.core.DatabaseTemplate methods update() and execute() never explicitly issue a commit() on the connection.  I am using PostgreSQL as the database.  I have implemented my own connection factory.  I have tried to use psycopg2 and pgdb both with the sqlAlchemy pooling, but I can't get the insert/update statements to commit.  If I modify the springpython code and insert a __db.commit() then I can get the cursor to commit.

Am I missing something?  How do I get the records to commit?