Hi Thomas, I am looking for workarounds to the bugs previously reported. (I sent you the test code for the same.) To avoid the crash on freeing a connection that has timed out.(bug 1) I can either:
a> Execute a dummy query on the connection and let the auto reconnect happen and then try freeing it. b> Never free the connection. I believe this would cause a memory leak. Can u suggest workarounds?? Will an updated driver be available?? Regards, Ajit -----Original Message----- From: Ajit Aranha [mailto:[EMAIL PROTECTED] Sent: Thursday, July 15, 2004 7:00 PM To: 'Koetter, Thomas Theodor' Subject: RE: ODBC bugs/ crashes Hi Thomas, I attach the test code to reproduce both bugs. Within each zip is the code,a sqltrace of running the code on my system and the output on my system. Also Bug 1: On further testing I determined that the crash was not due to disconnecting the connection in another thread. It is due to disconnecting a connection that has timed out. Bug 2: The bug occurs when running an ORACLE MODE query (SQLExecDirect) on a timed out connection. The query seems to be executed in internal mode. Also the bug occurs when the query has a "where" and "order by" clause. I have got to different error messages "unknown function name" and "unknown column name sysdate" using different queries.(Please see char* query1 and char* query in source.) Interestingly I could reproduce this error in SQLStudio.( Using ORACLE Mode and allowing the connection to timeout in sqlstudio) Regards, Ajit P.S. Note that for testing I set SESSION_TIMEOUT to 40 and sleep for 60 seconds in my code. -----Original Message----- From: Koetter, Thomas Theodor [mailto:[EMAIL PROTECTED] Sent: Thursday, July 15, 2004 2:17 PM To: 'Ajit Aranha'; [EMAIL PROTECTED] Subject: RE: ODBC bugs/ crashes Hi Ajit > -----Original Message----- > From: Ajit Aranha [mailto:[EMAIL PROTECTED] > Sent: Donnerstag, 15. Juli 2004 09:13 > To: [EMAIL PROTECTED] > Subject: ODBC bugs/ crashes > > > Hi, > I am attempting to reuse ODBC connections (pooling) > I'm encountering some problems: > 1. The exe crashes if I allocate a connection from one thread and > disconnect it from different thread > 2. Also a variation of this earlier bug still exists in the latest > 7.4 driver Please send me your traces, tell me which version you use and a short program reproducing the problem. Regards Thomas ---------------------------------------------- Dr. Thomas K�tter SAP AG, SAP Labs Berlin Do you know SAP^H^H^H MaxDB ? www.sapdb.org -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
