`
kevindurant
  • 浏览: 8970 次
  • 性别: 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  
如何?想说明什么?

相关推荐

    Java使用JDBC向MySQL数据库批次插入10W条数据(测试效率)

    本文将详细讲解如何使用JDBC批量插入10万条数据,并探讨其背后的原理和优化策略。 批量处理在JDBC中主要通过Statement对象的`addBatch()`和`executeBatch()`两个方法实现。在示例代码中,我们创建了一个`...

    C#.NET中如何批量插入大量数据到数据库中

    `FileUpload`控件用于选择Excel文件,两个按钮分别用于导入数据到`GridView`以及将`GridView`中的数据批量插入到数据库。 ```csharp // 前端代码片段 &lt;!-- 定义列,例如学号和学生姓名 --&gt; 导入数据" /&gt; 插入到...

    3分钟如何向MySQL数据库中插入100万条数据

    通过这种方式,我们可以实现高效的数据插入,特别是对于100万条数据这样的大数据量。然而,实际应用中,可能还需要考虑其他因素,如数据库索引的影响、数据分批插入的大小优化、并发插入的策略等,这些都会对插入...

    Mysql生成三千万条数据

    ### MySQL生成三千万条数据的方法及测试分析 #### 一、背景与目的 在软件开发过程中,特别是数据库应用系统的设计与优化阶段,测试数据库在大数据量下的表现是至关重要的一步。通过模拟实际业务场景中的数据规模,...

    Mysql构造百万条测试数据

    这里调用了存储过程 `add_vote_memory`,并传递了参数 1000000,以生成 100 万条数据。注意,在调用存储过程时,需要根据电脑性能来估算执行时间。 知识点:如果在执行存储过程时出现内存溢出的错误,可以修改 ...

    批量生成mysql中文测试数据

    4. `120WName.txt` 和 `21w.txt`:这两个文件可能包含预先生成的大量中文姓名数据,用于加速生成过程或提供更真实的姓名数据。例如,`120WName.txt` 可能包含了120万个不同的中文姓名,而`21w.txt`可能包含了21万个...

    mysql中迅速插入百万条测试数据的方法

    这种方式虽然能完成数据插入,但正如描述中提到的,耗时较长,大约需要58分钟。 2. **使用PHP生成数据文件,然后导入**: - 在PHP脚本中生成包含100万行数据的SQL文件,每一行数据使用制表符(`\t`)分隔各个字段...

    mysql测试库(100万数据库和世界人口数据库).rar

    在提供的"mysql测试库(100万数据库和世界人口数据库).rar"压缩包中,包含两个重要的文件:`world.sql`和`t100w.sql`,它们为学习和测试MySQL功能提供了丰富的数据集。 `world.sql` 文件通常包含一个名为"world"的...

    C#/.Net 中快速批量给SQLite数据库插入测试数据

    在C#/.Net环境中,对SQLite数据库进行快速批量插入测试数据是常见的开发需求,尤其是在测试、性能优化或者数据初始化时。下面将详细讲解如何利用C#/.Net的特性以及SQLite数据库API来实现这一目标。 首先,SQLite是...

    MySQL数据库30W测试数据.rar

    "先看我.txt" 很可能是一个说明文档,提供了如何导入和使用这30万条测试数据的详细步骤。通常,这样的文本文件会包含SQL脚本的执行顺序、导入的注意事项以及可能的环境配置要求。而 "test_db-master" 可能是一个包含...

    SQLServer 批量插入数据的两种方法

    在这个例子中,BatchSize设置为DataTable的行数,这意味着一次性将所有数据插入。 4. 打开数据库连接。 5. 将DataTable作为数据源传递给SqlBulkCopy的WriteToServer方法。 6. 在适当的地方处理异常并关闭数据库连接...

    PhoenixonHBase性能测试报告.pdf

    测试方法包括数据导入和数据插入两种方式。数据导入使用文本文件数据装载至目标表,而数据插入使用DML语句将数据插入目标表。测试结果显示数据导入的性能优于数据插入。 K-V(RowKey)查询测试 K-V(RowKey)查询测试...

    MySQL大量数据插入各种方法性能分析与比较

    本文将对几种常见的数据插入策略进行分析和比较,包括单条插入、批量插入、事务处理和使用`LOAD DATA INFILE`命令。 首先,了解MySQL插入一条记录的时间构成有助于我们理解优化的必要性。插入过程涉及连接、发送...

    07mysql集群测试报告.pdf

    单线程功能测试则是对比100万条和1000万条数据的性能差异,这有助于理解数据库在不同数据规模下的响应速度。 大数据量下的读写性能对比测试,通过预先生成不同规模的数据,然后执行读写操作,观察性能变化,以便...

    千万级Mysql-MongoDB性能对比报告

    本次性能对比测试主要关注不同规模的数据插入操作在MySQL和MongoDB中的表现情况,特别是在处理千万级别数据时的表现。测试涵盖了不同的数据提交方式和数据量,旨在全面评估两种数据库系统的性能差异。 #### MySQL...

    使用Kettle同步mysql数据,增量同步

    例如,在双核CPU和4GB内存的PC机上,以及双核CPUx2和4GB内存的主机配置下,JVM内存堆栈配置为256MB时,在测试环境中,15万条数据的同步可以在3分钟内完成。 总结来说,Kettle通过灵活的数据抽取、转换和加载机制,...

    有标记的情感数据近40w条

    这40万条数据可以分为两个部分,分别存储在两个文件中。 描述中提到的“pos文件为正面,neg文件为负面”,这说明数据集由两个文本文件组成:pos.txt和neg.txt。pos.txt文件包含了所有被标记为正面情感的文本,而neg...

Global site tag (gtag.js) - Google Analytics