[egenix-users] access to MsSQL blocks
robert at redcor.ch
Thu Aug 31 13:49:20 CEST 2006
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 <robert at redcor.ch> [6522021#1]
for hints how to fix this problems I would be extreemly gratefull.
"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 ):
# 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
more methods ..
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 200 bytes
Desc: not available
Url : /mailman-archives/egenix-users/attachments/20060831/9ad48cc7/robert.vcf
More information about the egenix-users