多用户并发时,似乎是插入错!
使用weblogic6.1自带的petstore+oracle9i
单用户使用不会出错,当多用户时,出错。
错误
resultCount = stmt.executeUpdate();
执行结果为resultCount=10,执行的是insert语句
queryString is: INSERT INTO orders(orderid,userid,orderdate,shipaddr1,shipaddr2,
shipcity,shipstate,shipzip,shipcountry,billaddr1,billaddr2,billcity,billstate,bi
llzip,billcountry,courier,totalprice, shiptofirstname,shiptolastname,billtofirst
name,billtolastname,creditcard,exprdate,cardtype, locale)VALUES (ordernum.nextva
l,'j2ee',to_date('09/11/2003','mm/dd/yyyy'),'901 San Antonio Road','MS UCUP02-20
6','Palo Alto','California','94303','USA','901 San Antonio Road','MS UCUP02-206'
,'Palo Alto','California','94303','USA','UPS',18.5,'ABC','XYX','ABC','XYX','9999
9999 9999 9999','01/2001','Visa', 'US_en' )