SAPDB 7.3.30 with ODBC 7.3.00.00 Bug Description: When the ODBC connection times out the sqlmode setting is lost (the driver seems to auto reconnect but loses the SQLMODE ORACLE setting) See the attached ODBC driver trace. Note: Connection was established using SQLMODE ORACLE/Committed.
<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body ><PRE><PLAINTEXT> PRODUCT : SAP DB C-PreComp Runtime VERSION : 7.3.0 BUILD : 028-000-000-000 DATASOURCE: mmp SESSION : 1; SQLMODE : INTERN SERVERDB : mmp SERVERNODE: 192.168.21.37 CONNECT "ONMOBILE " IDENTIFIED BY :A ISOLATION LEVEL 1 START : DATE : 2003-10-28 TIME : 0014:35:53 END : DATE : 2003-10-28 TIME : 0014:35:53 STMMODE : ORACLE INSERT INTO VM_MISSEDCALLS_ORANGE VALUES (?,?,? ,to_date(?,'YYYYMMDDHHMISSMSAM') , 'N', NULL) PARSE : CMD : mfIndex init : 1 PARSEID: OUTPUT: 00003DAC 00000201 0A000000 01000000 START : DATE : 2003-10-28 TIME : 0014:35:55 END : DATE : 2003-10-28 TIME : 0014:35:55 STMMODE : ORACLE INSERT INTO VM_MISSEDCALLS_ORANGE VALUES (?,?,? ,to_date(?,'YYYYMMDDHHMISSMSAM') , 'N', NULL) EXECUTE: CMD : PARSEID: INPUT : 00003DAC 00000201 0A000000 01000000 WARNING: W1-------------- INPUT : 1: COLUMN1 : +919810000000 WARNING: W1-------------- INPUT : 2: COLUMN2 : +919210000000 WARNING: W1-------------- INPUT : 3: COLUMN3 : B WARNING: W1-------------- INPUT : 4: COLUMN4 : 2003102802355502PM SQLCODE: 700 Command inactivity timeout (work rolled back) (bad RTE retu START : DATE : 2003-10-28 TIME : 0014:37:26 END : DATE : 2003-10-28 TIME : 0014:37:26 DATASOURCE: mmp (//MY comment ?this connection was not initiated by the ODBC code. Was auto reconnected by the odbc driver.) SESSION : 1; SQLMODE : INTERN SERVERDB : mmp SERVERNODE: 192.168.21.37 CONNECT "ONMOBILE " IDENTIFIED BY :A ISOLATION LEVEL 1 START : DATE : 2003-10-28 TIME : 0014:37:29 END : DATE : 2003-10-28 TIME : 0014:37:29 INSERT INTO VM_MISSEDCALLS_ORANGE VALUES (?,?,? ,to_date(?,'YYYYMMDDHHMISSMSAM') , 'N', NULL) PARSE : CMD : SQLCODE: -4006 Unknown domain name:TO_DATE (//MY comment ?this failed because this stmt was not executed in SQLMODE ORACLE) PARSEID: OUTPUT: 00000000 00000000 00000000 00000000 SQLERRD(INDEX_6) : 50 ERROR NEAR ^ : S (?,?,? ,^to_date(?, START : DATE : 2003-10-28 TIME : 0014:37:29 END : DATE : 2003-10-28 TIME : 0014:37:29 INSERT INTO VM_MISSEDCALLS_ORANGE VALUES (?,?,? ,to_date(?,'YYYYMMDDHHMISSMSAM') , 'N', NULL) EXECUTE: CMD : PARSEID: INPUT : 00000000 00000000 00000000 00000000 INPUT : 1: COLUMN1 : +919810000000 INPUT : 2: COLUMN2 : +919210000000 INPUT : 3: COLUMN3 : B INPUT : 4: COLUMN4 : 2003102802355502PM SQLCODE: -3005 Invalid SQL statement SQLERRD(INDEX_6) : 1 START : DATE : 2003-10-28 TIME : 0014:37:29 END : DATE : 2003-10-28 TIME : 0014:37:29 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
