Struct (templateCode, activityCode, activityId, sendRoundId, arrangeDate, expireDate, messageId, mobile, requestId, senderId, depName, depId, flag, level, struct, systemName, mtime, ctime) values (# {item. templateCode}, # {item. activityC... multi-thread mybatismysql primary key
Insert into sequence (templateCode, activityCode, activityId, sendRoundId, arrangeDate, expireDate, messageId, mobile, requestId, senderId, depName, depId, flag, level, interval, systemName, mtime, ctime)
Values
(# {Item. templateCode}, # {item. activityCode}, # {item. activityId}, # {item. sendRoundId}, # {item. arrangeDate}, # {item. expireDate}, # {item. messageId}, # {item. mobile },# {item. requestId}, # {item. senderId}, # {item. depName}, # {item. depId}, # {item. flag}, # {item. level}, # {item. smsTemplateVar}, # {item. systemName}, # {item. mtime}, # {item. ctime })
The preceding is my SQL statement. a primary key conflict exception is reported in a multi-threaded request, and the larger the concurrency, the more frequent the primary key conflict exception.