[Sqlrelay-discussion] Re: ZSQLRelayDA and freeing connections

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

Oh yeah, I can make as many queries as I want using sqlrsh, so it seems 
that the sqlrelay machinery is itself OK.

-- Jean

Jean Lagarde wrote:

> 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
>
>
>