maximum open cursors exceeded on Jython and Oracle
|Reported by:||stephanekonstantaropoulos||Owned by:||xoror|
|Component:||Database layer (models, ORM)||Version:||master|
|Has patch:||yes||Needs documentation:||no|
|Needs tests:||yes||Patch needs improvement:||yes|
I am hitting an Oracle error frequently when running Django 1.1.2 from Jython:
ORA-01000: maximum open cursors exceeded
It never does it from cPython, I don't know if it is the driver or maybe it is the way Jython and Java clear the unused objects which is less efficient than Python's.
I fixed it myself by calling systematically cursor.close() everywhere a new cursor is created.
That is in django.db.models.sql.query and in django.db.models.fields.related