Hi Mark I would appreciate if we can define Under_extreme_conditions as you have mentioned in this link below
http://archives.neohapsis.com/archives/mysql/2005-q3/0163.html I would appreciate if you can give us a workaround for this, which can eliminate this set autocommit =1 command being sent to the MYSQL DB. Regards Sandeep Below is the log generated by Mysql ------------------------------------------------- 37 Query SET autocommit=1 37 Query SET autocommit=0 77 Connect [EMAIL PROTECTED] on b_08_11_2006 77 Init DB b_08_11_2006 77 Query SET NAMES latin1 77 Query SET character_set_results = NULL 77 Query select round('inf'), round('-inf'), round('nan') 77 Query SHOW VARIABLES 77 Query SHOW COLLATION 77 Query SET autocommit=1 77 Query select query.... 77 Quit 37 Query insert into channel(ChannelName,ChannelShortName,ChannelDescription,CreatedBy,Chan nelShortDescription,Status,CreatedOn) values('test','t','t','66','t',502, CURRENT_TIMESTAMP()) 37 Query insert into channelsPerType(idchannel,idchannelTypes) values((select max(idchannel) from channel),'5') 37 Query select max(idchannel) from channel 37 Query insert into channelMetaDataFields(idchannel,idSystemDataType,MetadatafieldName,sho rtName,Description,Searchable,Suggest,Status,Sortable,Required,Default Value,ParentID,relationshipType,shortDescription) select 45,idSystemDataType,MetadatafieldName,shortName,Description,Searchable ,Suggest,501,Sortable,Required,DefaultValue,ParentID,relationshipType, shortDescription from channelMetaDataFields where idchannelTypes = 5 and idchannel is NULL 37 Query commit 37 Query rollback 37 Query SET autocommit=1 37 Query SET autocommit=1 ------------------------------------------------- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
