[Sqlrelay-discussion] ZSQLRelayDA and freeing connections

[Jean L. <jla...@bi...>]

Hi all,

sqlrelay-0.35, Zope 2.7, Python 2.3, FreeBSD 5.0, FreeTDS

I've got everything working up to this point: I can execute test 
queries, or run ZSQL methods, but only up to the "connections" parameter 
in the sqlrelay.conf file. For example, if connections="3", I can call 
the same ZSQL method three times, and the fourth time, Zope hangs until 
I run sqlr-stop and restart. Once I stop sqlrelay, the query that was 
hanging Zope returns with "failed to get cursor id". I went as far as 
checking that _finish() in db.py does seem to successfully call close() 
in PySQLRDB, but somehow I guess the previous connections/cursors aren't 
freed?

Any ideas?

Cheers,

Jean