`
kevindurant
  • 浏览: 8796 次
  • 性别: Icon_minigender_1
  • 来自: 广州
最近访客 更多访客>>
文章分类
社区版块
存档分类
最新评论

两万条数据插入测试

阅读更多
         昨天做了个测试向oracle10G 使用hibernate 通过webserive调用 插入两万条数据,

       并且启动JBPM 工作流。仅仅是启动了工作流,在构造插入的对象的时候有两个字段是通过webserivce 查询其他系统的数据来的 。。。每次插入hibernate 要向数据库9个表插入数据

    总共耗时58分钟,,,,,大家看看我应该如何优化。。


是用笔记本测试 T8300 cpu  2G内存


          大家看看这段webservice 测试代码,



private DeliverWebService deliverService;

@Override
protected String[] getConfigLocations() {
                                                                              setAutowireMode(AbstractDependencyInjectionSpringContextTests.AUTOWIRE_BY_NAME);
return new String[] { "classpath:client-context.xml" };
}

public void setDeliverService(DeliverWebService deliverService) {
this.deliverService = deliverService;
}

public void testGetOrigins() {
List<OriginDTO> list = deliverService.getAllOrigin();
assertNotNull(list.size());
/*
for (OriginDTO o : list) {
System.out.println(o.getId() + ":" + o.getTitle());
}
System.out.println("list.size():" + list.size());
*/
}


public void testCreateDeliver() {
DeliverDTO deliver = new DeliverDTO();
deliver.setAddress("广州市广州大道368号");

for(int i=320;i<320+20000;i++) {
deliver.setBusinessKind(deliverService.getAllBusinessKind().get(0));

deliver.setCustomerName("王新" + i);
deliver.setIdCode(new Long(36242619850305L + i).toString());//最长20位,web service需提示错误
deliver.setMemberCard(new Long(1111 + i).toString());
deliver.setMobile("13689284112");
deliver.setOrderDescn("请XXXXXXXXXXX");
deliver.setOrderId(new Long(50000 + i));

deliver.setRanks(deliverService.getAllRanks().get(2));
deliver.setOrigin(deliverService.getAllOrigin().get(0));
deliver.setPhone("020-12344322");
deliver.setPostcode("345324");
deliver.setSubscribeTime(new Date());
// deliver.setSubscribeTime(DatatypeFactory.newInstance().newXMLGregorianCalendar(new GregorianCalendar()));
deliver.setTotalPrice(new Double(60.5 + i));
deliver.setType(DeliverType.投递单);
deliverService.createDeliver(deliver);
}
}







        下面是被调用的 webservice 服务:




public Boolean createDeliver(DeliverDTO deliver) throws FaultException {

try {
//校验请求参数
if (deliver == null) {
throw new FaultException(Constant.PARAMETER_ERROR, "deliver为空");
}
if (deliver.getOrderId() == null) {
throw new FaultException(Constant.PARAMETER_ERROR, "deliver.orderId为空");
}
if (deliver.getOrigin() == null) {
throw new FaultException(Constant.PARAMETER_ERROR, "deliver.Origin为空");
}
if(deliver.getRanks() ==null ||deliver.getRanks().equals("")){
throw new FaultException(Constant.PARAMETER_ERROR, "deliver.Ranks为空");
}
if(StringUtils.isNotBlank(deliver.getPostcode())){

if(!StringUtils.isNumeric(deliver.getPostcode())){

throw new FaultException(Constant.PARAMETER_ERROR, "postcode邮政编码必须是数字");
}

if(deliver.getPostcode().length()>6){
throw new FaultException(Constant.PARAMETER_ERROR, "postcode邮政编码不能大于6位");
}
}


// 从DTO转换到Deliver
if (deliver.getId() != null && deliver.getId() == 0) {
deliver.setId(null);
}
Deliver deliverEntity = (Deliver) dozer.map(deliver, Deliver.class);

//初始化一些值
deliverEntity.setAcceptDate(new Date());
deliverEntity.setStatus(DeliverStatus.未分拣);
deliverEntity.setFhStatus(DeliverFhStatus.未复核);
deliverEntity.setAcceptDepId(deliver.getRanks().getStarter());


// 保存Deliver
jbpmManager.saveDeliver(deliverEntity);

return true;
} catch (RuntimeException e) {
throw unknownException(e, Constant.SYSTEM_ERROR);
}
}






       //jbpmManager.saveDeliver(deliverEntity); 的实现如下



public void saveDeliver(final Deliver deliver) {
jbpmTemplate.execute(new JbpmCallback() {
public Object doInJbpm(JbpmContext jbpmContext) throws JbpmException {
deliverDao.save(deliver);
Map<String, Object> variables = new HashMap<String, Object>();
variables.put("deliverId", deliver.getId());//用于标识工作流实例
variables.put("acceptDepId", deliver.getAcceptDepId());
ProcessInstance pi = createProcessInstance(jbpmContext, variables);

pi.signal();
return null;
}
});
}










下面是后台输出:


[DEBUG]com.gzpost.lantou.support.OSCache:Get from cache [Key:originList]
[DEBUG]com.gzpost.lantou.support.OSCache:Get from cache [Key:businessKindList]
Hibernate: select this_.ID as ID32_0_, this_.DESCN as DESCN32_0_, this_.RANKSNAME as RANKSNAME32_0_, this_.STARTER as STARTER32_0_ from RANKS this_
[DEBUG]com.gzpost.lantou.support.OSCache:Get from cache [Key:originList]
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select * from ( select processdef0_.ID_ as ID1_13_, processdef0_.NAME_ as NAME3_13_, processdef0_.DESCRIPTION_ as DESCRIPT4_13_, processdef0_.VERSION_ as VERSION5_13_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_13_, processdef0_.STARTSTATE_ as STARTSTATE7_13_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc ) where rownum <= ?
Hibernate: select exceptionh0_.PROCESSDEFINITION_ as PROCESSD7_1_, exceptionh0_.ID_ as ID1_1_, exceptionh0_.GRAPHELEMENTINDEX_ as GRAPHELE6_1_, exceptionh0_.ID_ as ID1_11_0_, exceptionh0_.EXCEPTIONCLASSNAME_ as EXCEPTIO2_11_0_, exceptionh0_.TYPE_ as TYPE3_11_0_, exceptionh0_.GRAPHELEMENT_ as GRAPHELE4_11_0_ from JBPM_EXCEPTIONHANDLER exceptionh0_ where exceptionh0_.PROCESSDEFINITION_=?
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select definition0_.PROCESSDEFINITION_ as PROCESSD4_1_, definition0_.ID_ as ID1_1_, definition0_.NAME_ as NAME3_1_, definition0_.ID_ as ID1_23_0_, definition0_.NAME_ as NAME3_23_0_, definition0_.PROCESSDEFINITION_ as PROCESSD4_23_0_, definition0_.STARTTASK_ as STARTTASK5_23_0_, definition0_.CLASS_ as CLASS2_23_0_ from JBPM_MODULEDEFINITION definition0_ where definition0_.PROCESSDEFINITION_=?
Hibernate: select events0_.PROCESSDEFINITION_ as PROCESSD6_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_10_0_, events0_.EVENTTYPE_ as EVENTTYPE2_10_0_, events0_.TYPE_ as TYPE3_10_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_10_0_ from JBPM_EVENT events0_ where events0_.PROCESSDEFINITION_=?
Hibernate: select node0_.ID_ as ID1_12_0_, node0_.NAME_ as NAME3_12_0_, node0_.DESCRIPTION_ as DESCRIPT4_12_0_, node0_.PROCESSDEFINITION_ as PROCESSD5_12_0_, node0_.ISASYNC_ as ISASYNC6_12_0_, node0_.ISASYNCEXCL_ as ISASYNCE7_12_0_, node0_.ACTION_ as ACTION8_12_0_, node0_.SUPERSTATE_ as SUPERSTATE9_12_0_, node0_.DECISIONEXPRESSION_ as DECISIO10_12_0_, node0_.DECISIONDELEGATION as DECISIO11_12_0_, node0_.SUBPROCNAME_ as SUBPROC12_12_0_, node0_.SCRIPT_ as SCRIPT13_12_0_, node0_.SUBPROCESSDEFINITION_ as SUBPROC14_12_0_, node0_.SIGNAL_ as SIGNAL15_12_0_, node0_.CREATETASKS_ as CREATET16_12_0_, node0_.ENDTASKS_ as ENDTASKS17_12_0_, node0_.CLASS_ as CLASS2_12_0_ from JBPM_NODE node0_ where node0_.ID_=?
processInstance   null
Hibernate: select leavingtra0_.FROM_ as FROM5_1_, leavingtra0_.ID_ as ID1_1_, leavingtra0_.FROMINDEX_ as FROMINDEX8_1_, leavingtra0_.ID_ as ID1_14_0_, leavingtra0_.NAME_ as NAME2_14_0_, leavingtra0_.DESCRIPTION_ as DESCRIPT3_14_0_, leavingtra0_.PROCESSDEFINITION_ as PROCESSD4_14_0_, leavingtra0_.FROM_ as FROM5_14_0_, leavingtra0_.TO_ as TO6_14_0_, leavingtra0_.CONDITION_ as CONDITION7_14_0_ from JBPM_TRANSITION leavingtra0_ where leavingtra0_.FROM_=?
Hibernate: select exceptionh0_.TRANSITION_ as TRANSITION8_1_, exceptionh0_.ID_ as ID1_1_, exceptionh0_.GRAPHELEMENTINDEX_ as GRAPHELE6_1_, exceptionh0_.ID_ as ID1_11_0_, exceptionh0_.EXCEPTIONCLASSNAME_ as EXCEPTIO2_11_0_, exceptionh0_.TYPE_ as TYPE3_11_0_, exceptionh0_.GRAPHELEMENT_ as GRAPHELE4_11_0_ from JBPM_EXCEPTIONHANDLER exceptionh0_ where exceptionh0_.TRANSITION_=?
Hibernate: select events0_.NODE_ as NODE5_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_10_0_, events0_.EVENTTYPE_ as EVENTTYPE2_10_0_, events0_.TYPE_ as TYPE3_10_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_10_0_ from JBPM_EVENT events0_ where events0_.NODE_=?
Hibernate: select events0_.TRANSITION_ as TRANSITION7_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_10_0_, events0_.EVENTTYPE_ as EVENTTYPE2_10_0_, events0_.TYPE_ as TYPE3_10_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_10_0_ from JBPM_EVENT events0_ where events0_.TRANSITION_=?
Hibernate: select actions0_.EVENT_ as EVENT9_1_, actions0_.ID_ as ID1_1_, actions0_.EVENTINDEX_ as EVENTINDEX17_1_, actions0_.ID_ as ID1_9_0_, actions0_.NAME_ as NAME3_9_0_, actions0_.ISPROPAGATIONALLOWED_ as ISPROPAG4_9_0_, actions0_.ACTIONEXPRESSION_ as ACTIONEX5_9_0_, actions0_.ISASYNC_ as ISASYNC6_9_0_, actions0_.REFERENCEDACTION_ as REFERENC7_9_0_, actions0_.ACTIONDELEGATION_ as ACTIONDE8_9_0_, actions0_.EVENT_ as EVENT9_9_0_, actions0_.PROCESSDEFINITION_ as PROCESS10_9_0_, actions0_.TIMERNAME_ as TIMERNAME11_9_0_, actions0_.DUEDATE_ as DUEDATE12_9_0_, actions0_.REPEAT_ as REPEAT13_9_0_, actions0_.TRANSITIONNAME_ as TRANSIT14_9_0_, actions0_.TIMERACTION_ as TIMERAC15_9_0_, actions0_.EXPRESSION_ as EXPRESSION16_9_0_, actions0_.class as class9_0_ from JBPM_ACTION actions0_ where actions0_.EVENT_=?
Hibernate: select delegation0_.ID_ as ID1_20_0_, delegation0_.CLASSNAME_ as CLASSNAME2_20_0_, delegation0_.CONFIGURATION_ as CONFIGUR3_20_0_, delegation0_.CONFIGTYPE_ as CONFIGTYPE4_20_0_, delegation0_.PROCESSDEFINITION_ as PROCESSD5_20_0_ from JBPM_DELEGATION delegation0_ where delegation0_.ID_=?
StartActionHandler=================
揽投单204151开始流程
Hibernate: select node0_.ID_ as ID1_12_0_, node0_.NAME_ as NAME3_12_0_, node0_.DESCRIPTION_ as DESCRIPT4_12_0_, node0_.PROCESSDEFINITION_ as PROCESSD5_12_0_, node0_.ISASYNC_ as ISASYNC6_12_0_, node0_.ISASYNCEXCL_ as ISASYNCE7_12_0_, node0_.ACTION_ as ACTION8_12_0_, node0_.SUPERSTATE_ as SUPERSTATE9_12_0_, node0_.DECISIONEXPRESSION_ as DECISIO10_12_0_, node0_.DECISIONDELEGATION as DECISIO11_12_0_, node0_.SUBPROCNAME_ as SUBPROC12_12_0_, node0_.SCRIPT_ as SCRIPT13_12_0_, node0_.SUBPROCESSDEFINITION_ as SUBPROC14_12_0_, node0_.SIGNAL_ as SIGNAL15_12_0_, node0_.CREATETASKS_ as CREATET16_12_0_, node0_.ENDTASKS_ as ENDTASKS17_12_0_, node0_.CLASS_ as CLASS2_12_0_ from JBPM_NODE node0_ where node0_.ID_=?
Hibernate: select events0_.NODE_ as NODE5_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_10_0_, events0_.EVENTTYPE_ as EVENTTYPE2_10_0_, events0_.TYPE_ as TYPE3_10_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_10_0_ from JBPM_EVENT events0_ where events0_.NODE_=?
Hibernate: select tasks0_.TASKNODE_ as TASKNODE13_1_, tasks0_.ID_ as ID1_1_, tasks0_.ID_ as ID1_26_0_, tasks0_.NAME_ as NAME2_26_0_, tasks0_.DESCRIPTION_ as DESCRIPT3_26_0_, tasks0_.PROCESSDEFINITION_ as PROCESSD4_26_0_, tasks0_.ISBLOCKING_ as ISBLOCKING5_26_0_, tasks0_.ISSIGNALLING_ as ISSIGNAL6_26_0_, tasks0_.CONDITION_ as CONDITION7_26_0_, tasks0_.DUEDATE_ as DUEDATE8_26_0_, tasks0_.PRIORITY_ as PRIORITY9_26_0_, tasks0_.ACTORIDEXPRESSION_ as ACTORID10_26_0_, tasks0_.POOLEDACTORSEXPRESSION_ as POOLEDA11_26_0_, tasks0_.TASKMGMTDEFINITION_ as TASKMGM12_26_0_, tasks0_.TASKNODE_ as TASKNODE13_26_0_, tasks0_.STARTSTATE_ as STARTSTATE14_26_0_, tasks0_.ASSIGNMENTDELEGATION_ as ASSIGNM15_26_0_, tasks0_.SWIMLANE_ as SWIMLANE16_26_0_, tasks0_.TASKCONTROLLER_ as TASKCON17_26_0_ from JBPM_TASK tasks0_ where tasks0_.TASKNODE_=?
[WARN]org.hibernate.engine.StatefulPersistenceContext.ProxyWarnLog:Narrowing proxy to class org.jbpm.graph.node.TaskNode - this operation breaks ==
Hibernate: select exceptionh0_.TASK_ as TASK9_1_, exceptionh0_.ID_ as ID1_1_, exceptionh0_.GRAPHELEMENTINDEX_ as GRAPHELE6_1_, exceptionh0_.ID_ as ID1_11_0_, exceptionh0_.EXCEPTIONCLASSNAME_ as EXCEPTIO2_11_0_, exceptionh0_.TYPE_ as TYPE3_11_0_, exceptionh0_.GRAPHELEMENT_ as GRAPHELE4_11_0_ from JBPM_EXCEPTIONHANDLER exceptionh0_ where exceptionh0_.TASK_=?
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select taskcontro0_.ID_ as ID1_27_0_, taskcontro0_.TASKCONTROLLERDELEGATION_ as TASKCONT2_27_0_ from JBPM_TASKCONTROLLER taskcontro0_ where taskcontro0_.ID_=?
Hibernate: select variableac0_.TASKCONTROLLER_ as TASKCONT6_1_, variableac0_.ID_ as ID1_1_, variableac0_.INDEX_ as INDEX7_1_, variableac0_.ID_ as ID1_6_0_, variableac0_.VARIABLENAME_ as VARIABLE2_6_0_, variableac0_.ACCESS_ as ACCESS3_6_0_, variableac0_.MAPPEDNAME_ as MAPPEDNAME4_6_0_ from JBPM_VARIABLEACCESS variableac0_ where variableac0_.TASKCONTROLLER_=?
Hibernate: select events0_.TASK_ as TASK8_1_, events0_.ID_ as ID1_1_, events0_.EVENTTYPE_ as EVENTTYPE2_1_, events0_.ID_ as ID1_10_0_, events0_.EVENTTYPE_ as EVENTTYPE2_10_0_, events0_.TYPE_ as TYPE3_10_0_, events0_.GRAPHELEMENT_ as GRAPHELE4_10_0_ from JBPM_EVENT events0_ where events0_.TASK_=?
Hibernate: select delegation0_.ID_ as ID1_20_0_, delegation0_.CLASSNAME_ as CLASSNAME2_20_0_, delegation0_.CONFIGURATION_ as CONFIGUR3_20_0_, delegation0_.CONFIGTYPE_ as CONFIGTYPE4_20_0_, delegation0_.PROCESSDEFINITION_ as PROCESSD5_20_0_ from JBPM_DELEGATION delegation0_ where delegation0_.ID_=?
SortAssignmentHandler=================
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [DELIVER]
Hibernate: insert into DELIVER (ACCEPTDATE, ACCEPTDEPID, ADDRESS, BUSIKIND_ID, CUSTOMERNAME, DELIVERDATE, DELIVERDEPID, DELIVERUSER, FHSTATUS, IDCODE, MEMBERCARD, MOBILE, MODIFYDATE, MODIFYUSER, ORDERDESCN, ORDER_ID, ORIGIN_ID, PHONE, POSTCODE, RANKS_ID, RECEIVEDATE, SECTIONCODE, SORTDATE, STATUS, SUBSCRIBETIME, TOTALPRICE, TYPE, WTSBHDESCN, ID) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_TOKEN]
Hibernate: insert into JBPM_TOKEN (VERSION_, NAME_, START_, END_, NODEENTER_, NEXTLOGINDEX_, ISABLETOREACTIVATEPARENT_, ISTERMINATIONIMPLICIT_, ISSUSPENDED_, LOCK_, NODE_, PROCESSINSTANCE_, PARENT_, SUBPROCESSINSTANCE_, ID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_PROCESSINSTANCE]
Hibernate: insert into JBPM_PROCESSINSTANCE (VERSION_, KEY_, START_, END_, ISSUSPENDED_, PROCESSDEFINITION_, ROOTTOKEN_, SUPERPROCESSTOKEN_, ID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?)
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_TASKINSTANCE]
Hibernate: insert into JBPM_TASKINSTANCE (VERSION_, NAME_, DESCRIPTION_, ACTORID_, CREATE_, START_, END_, DUEDATE_, PRIORITY_, ISCANCELLED_, ISSUSPENDED_, ISOPEN_, ISSIGNALLING_, ISBLOCKING_, TASK_, TOKEN_, PROCINST_, SWIMLANINSTANCE_, TASKMGMTINSTANCE_, CLASS_, ID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'T', ?)
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_MODULEINSTANCE]
Hibernate: insert into JBPM_MODULEINSTANCE (VERSION_, PROCESSINSTANCE_, TASKMGMTDEFINITION_, CLASS_, ID_) values (?, ?, ?, 'T', ?)
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_MODULEINSTANCE]
Hibernate: insert into JBPM_MODULEINSTANCE (VERSION_, PROCESSINSTANCE_, CLASS_, ID_) values (?, ?, 'C', ?)
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_TOKENVARIABLEMAP]
Hibernate: insert into JBPM_TOKENVARIABLEMAP (VERSION_, TOKEN_, CONTEXTINSTANCE_, ID_) values (?, ?, ?, ?)
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_VARIABLEINSTANCE]
Hibernate: insert into JBPM_VARIABLEINSTANCE (VERSION_, NAME_, CONVERTER_, TOKEN_, TOKENVARIABLEMAP_, PROCESSINSTANCE_, STRINGVALUE_, CLASS_, ID_) values (?, ?, ?, ?, ?, ?, ?, 'S', ?)
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_VARIABLEINSTANCE]
Hibernate: insert into JBPM_VARIABLEINSTANCE (VERSION_, NAME_, CONVERTER_, TOKEN_, TOKENVARIABLEMAP_, PROCESSINSTANCE_, LONGVALUE_, CLASS_, ID_) values (?, ?, ?, ?, ?, ?, ?, 'L', ?)
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_VARIABLEINSTANCE]
Hibernate: insert into JBPM_VARIABLEINSTANCE (VERSION_, NAME_, CONVERTER_, TOKEN_, TOKENVARIABLEMAP_, PROCESSINSTANCE_, LONGVALUE_, CLASS_, ID_) values (?, ?, ?, ?, ?, ?, ?, 'L', ?)
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_PROCESSINSTANCE]
Hibernate: update JBPM_PROCESSINSTANCE set VERSION_=?, KEY_=?, START_=?, END_=?, ISSUSPENDED_=?, PROCESSDEFINITION_=?, ROOTTOKEN_=?, SUPERPROCESSTOKEN_=? where ID_=? and VERSION_=?
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_TOKEN]
Hibernate: update JBPM_TOKEN set VERSION_=?, NAME_=?, START_=?, END_=?, NODEENTER_=?, NEXTLOGINDEX_=?, ISABLETOREACTIVATEPARENT_=?, ISTERMINATIONIMPLICIT_=?, ISSUSPENDED_=?, LOCK_=?, NODE_=?, PROCESSINSTANCE_=?, PARENT_=?, SUBPROCESSINSTANCE_=? where ID_=? and VERSION_=?
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_TASKINSTANCE]
Hibernate: update JBPM_TASKINSTANCE set VERSION_=?, NAME_=?, DESCRIPTION_=?, ACTORID_=?, CREATE_=?, START_=?, END_=?, DUEDATE_=?, PRIORITY_=?, ISCANCELLED_=?, ISSUSPENDED_=?, ISOPEN_=?, ISSIGNALLING_=?, ISBLOCKING_=?, TASK_=?, TOKEN_=?, PROCINST_=?, SWIMLANINSTANCE_=?, TASKMGMTINSTANCE_=? where ID_=? and VERSION_=?
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_TASKINSTANCE]
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_TOKENVARIABLEMAP]
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_VARIABLEINSTANCE]
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_MODULEINSTANCE]
Hibernate: update JBPM_MODULEINSTANCE set PROCESSINSTANCE_=?, NAME_=? where ID_=?
Hibernate: update JBPM_MODULEINSTANCE set PROCESSINSTANCE_=?, NAME_=? where ID_=?
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Pre-invalidating space [JBPM_VARIABLEINSTANCE]
Hibernate: update JBPM_VARIABLEINSTANCE set TASKINSTANCE_=?, NAME_=? where ID_=?
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [DELIVER], timestamp: 5011172298813446
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_TOKEN], timestamp: 5011172298813447
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_PROCESSINSTANCE], timestamp: 5011172298813448
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_TASKINSTANCE], timestamp: 5011172298813449
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_MODULEINSTANCE], timestamp: 5011172298813450
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_MODULEINSTANCE], timestamp: 5011172298813451
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_TOKENVARIABLEMAP], timestamp: 5011172298813452
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_VARIABLEINSTANCE], timestamp: 5011172298813453
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_VARIABLEINSTANCE], timestamp: 5011172298813454
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_VARIABLEINSTANCE], timestamp: 5011172298813455
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_PROCESSINSTANCE], timestamp: 5011172298813456
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_TOKEN], timestamp: 5011172298813457
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_TASKINSTANCE], timestamp: 5011172298813458
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_TASKINSTANCE], timestamp: 5011172298813459
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_TOKENVARIABLEMAP], timestamp: 5011172298813460
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_VARIABLEINSTANCE], timestamp: 5011172298813461
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_MODULEINSTANCE], timestamp: 5011172298813462
[DEBUG]org.hibernate.cache.UpdateTimestampsCache:Invalidating space [JBPM_VARIABLEINSTANCE], timestamp: 5011172298813463
分享到:
评论
1 楼 JavaTestJava 2008-10-09  
如何?想说明什么?

相关推荐

    oracle数据库数据同步

    方法:解析XML文件,再调用odp.net组件批量提交,效率是批处理文件的4倍以上),我测试过100万数据批量插入在10秒以内(不包括解析文件的时间,根据机器的配置不同时间也不同)。 压缩包中包含的文件:数据库建表、...

    java jdbc 线程插入记录

    JDBC 用线程写入mysql数据库记录10万条,测试本机127.0.0.1写入速度约 482条/秒,测试代码端显示约需要124秒,SQL分析数据结果是480条左右,除去前后两秒无效数据,统计SQL如下 select max(num),min(num),avg(num) ...

    SpringBatch-DataMigration SpringBatch数据迁移项目

    主要解决两库的两个表数据迁移和同步问题(两个表的字段可以不一致,只要知道对应关系及转化规则即可),曾经测试过350万数据10分钟内迁移完毕 相关技术: mybatis、springBatch、mysql、quartz、spring、springMVC ...

    邮箱分类数据库存储算法2.0

    修改了之前对邮箱进行分类的执行方法,通过设置sql语句的执行长度提高插入效率,经测试,100万条数据,当插入条数大于50000时采用事务处理,否则一条语句插入,用时400秒,比之前提高了两分钟左右,读者可以自己设置...

    Mysql单文件存储删除数据文件容量不会减少的bug与解决方法

    MySQL的Bug之一:InnoDB ibdata1 never shrinks after data is removed ...当批量插入接近十万的数据后 然后进行删除操作 占用磁盘空间并未减少 解决方案 两种方式: 1. 先备份后删除然后进行导入 mysqldump -uxxx

    用100多行python代码写一个数据库

    模拟1分钟写入10000条数据,共写入5个小时的数据, 插入300万条数据,每条数据54个字符,用时2分51秒 读取测试:读取指定时间段内包含某个子串的日志 数据范围 遍历数据量 结果数 用时(秒) 5小时 300万 604 6.6...

    基于命令行的简单数据库系统

    注意:实际提交后测试的数据文件中的数据量可能会比较大,几万条,上百兆。  举例:(上面建立的student表的数据)  1,aaa,97  2,bbb,87  3,ccc,56   c) –s 文件路径名 表示从指定文本文件中读取语句执行...

    excel的使用

    由于自定义格式中最多只有3个数字段,Excel规定最多只能在前两个数字段中包括2个条件测试,满足某个测试条件的数字使用相应段中指定的格式,其余数字使用第3段格式。如果仅包含一个条件测试,则要根据不同的情况来...

    花店管理系统-数据库设计.doc

    数据操作要求及实现 20 6.1数据插入、查询操作 20 6.2数据更新操作 20 6.3数据连接查询操作 21 7.总结 22 8.参考文献 24 花店管理系统 摘要: 我们已经学习了两个学期的数据库课程,所以对数据库的创建和SQL语言以及...

    支持多数据库的ORM框架ef-orm.zip

    EF在极限插入模式下,甚至刷新了每秒10万条写入的记录。远远超过了其他框架。 一个初步的性能测试:测试代码:http://geequery.github.io/ef-orm/manual/performance-test.rar 测试报告:...

    mongodb-testing:用于学习MongoDB功能和与关系数据库的区别

    为了利用MongoDB的最佳性能,经过深思熟虑的产品级数据模型将介于这两个极端之间。 性能测试 目标 将MSSQL与插入2000万个联系人(8000万个对象)的文档数据库进行比较,并确定哪种数据库模型表现最佳。 结果 Azure ...

    基于词嵌入对文本相似性进行检测(含源码、数据集、说明文档)(深度学习实战).zip

    word2vec是嵌入是通过训练神经网络从上下文中预测单词而得到的,因此,让网络预测在一系列片段中应该选择哪个词来填充上下文中缺少的单词,这样,那些可被插入相似模式的单词将会得到彼此靠近一些的向量(如地点类...

    EXCEL集成工具箱V8.0完整增强版(精简)

    1分钟内能处理手工需几小时才能完成的几万行ERP或KingDee原始数据。极力推荐的工具之一。 【取唯一值】 能瞬间取任意存储格区域的内容为不含重复值的唯一值清单,加载到工具中并提供随时随地调用,具有重复加载与...

    GoodProject Maven Webapp.zip

    前者的意思是可能存在有两段明文散列以后得到相同的结果,后者的意思是如果我们散列特定的数据,得到的结果一定是相同的。 [1] 参考资料: 1. 使用MD5变换算法来防止穷举破译密码(二) . .夏冰软件加密技术博客 ....

    SqliteDev 384

     插入数据  sql &quot;INSERT INTO test VALUES &quot;a&quot; &quot;b&quot; &quot;;  cmd CommandText sql;  cmd ExecuteNonQuery ;  取出数据  sql &quot;SELECT FROM test&quot;;  cmd CommandText sql; ...

    SQLite(SqliteDev)

     //插入数据  sql = "INSERT INTO test VALUES('a','b')";  cmd.CommandText = sql;  cmd.ExecuteNonQuery();  //取出数据  sql = "SELECT * FROM test";  cmd.CommandText = sql;  System.Data.SQLite....

    WinRAR_4.0.exe

    包含两个掩码,并且所有文件既匹配第一个掩码,也匹配第二个掩码, 较小的子集 或者更精确的匹配拥有更高的优先权。例如,如果你用 *.cpp 和 f*.cpp 掩码, f*.cpp 拥有更高的优先权。 RAR 命令行语法 ~~~~~~...

Global site tag (gtag.js) - Google Analytics