Hi there, this is not really an Zope Questions, I just hope somebody of you cold give me a hint. I already asked egenix (as we are using mxODBC) they could not think of a good reason. (but said to try a comercial odbc bridge).
thanks for any pointers. robert using mxOdbc our database application embeded in zope often blocks when executing a simple statement as the following: query = "select fieldValue from tblATicketDetailDynamicForm \ where ticketDetailNoFk in (1683)" calling sql_q_nil(query) (from the following class) sometimes just never returns. The problem seems to be, that after a certain amount of queries MsSQL is in a state, that it does not allow any access to the querried database. what we do in our application is: - get a RedDbQuery object (class at the end of the posting) - execute the statement with RedDbQuery.sql_q_nil(query) - release the connection. this approach worked fine using MySQL. However we did not cross any OS bounderies and did not use ODBC. we are using: mxODBC Zope DA 1.0.8 License Information: 1 Zope Instance License for redcor <[EMAIL PROTECTED]> [6522021#1] SuSE 9.3 UnixOdbc 2.8.8 freetds 0.64 class RedDbQuery: "All queries are routed through this class." def __init__( self ): self._connection = getConnection() #print 'getConnection() returns', _connection self._cursor = self._connection.cursor() #print 'cursor() returns', _cursor def dispose( self ): releaseConnection( self._connection, self._cursor ) def cursor( self ): return self._cursor # # query level zero -- the one and only query execution method: # def sql_q_nil( self, query, verbose = None ): "Generic SQL query, expecting no return." if verbose: print( query ) r = self._cursor.execute( query ) #print 'execute() returns', r return r more methods ..
begin:vcard fn:robert rottermann n:rottermann;robert email;internet:[EMAIL PROTECTED] tel;work:031 333 10 20 tel;fax:031 333 10 23 tel;home:031 333 36 03 x-mozilla-html:FALSE version:2.1 end:vcard
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )