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.
using mxOdbc our database application embeded in zope often blocks when
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]
"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 ..
tel;work:031 333 10 20
tel;fax:031 333 10 23
tel;home:031 333 36 03
Zope maillist - Zope@zope.org
** No cross posts or HTML encoding! **
(Related lists -