delete from table_name 和 delete * from table_name 区别?

sql标准中有 delete * from 这样的语句吗?为什么有的数据库可以用 delete * from table_name ?

u010704330
sxyRain 还没有解决
6 年多之前 回复
suannai0314
鹳狸媛 楼主的这个问题解决了么?下边的答案能解决问题么?如果可以麻烦点击答案旁的√采纳哦~如果没有也可以将自己的答案贴上然后进行采纳的。
6 年多之前 回复

5个回答

delete * from table_name仅仅能删除表中数据,不能清空标识,删除表中数据后再重新写入数据时,标识符会从删除前标识最大加1开始。希望对您有帮助!

DoctorCZM
寧靜以致遠 如果是mysql或oracle的话,使用delete from table就可了;delete * from table可用于excel或者access进行数据删除的情况。
6 年多之前 回复
u010704330
sxyRain delete * from table_name 这条语句在数据库中执行会报错的,比如 mysql 或者 oracle ,能详细说下你的意思吗?
6 年多之前 回复
u010704330
sxyRain delete * from table_name 这条语句在数据库中使用会报错的,比如在mysql 或 oracle中使用,能详细说明下你要表达的意思吗?
6 年多之前 回复

没有发现有 delete * from语句。在哪里见到的啊/?

u010704330
sxyRain http://www.w3school.com.cn/sql/sql_delete.asp 你好,我在这个网站上看到的。
6 年多之前 回复

Microsoft Access的MDB数据库允许用Delete * from……

doyouwanna
钦犯 对。微软喜欢搞些特色
6 年多之前 回复
u010704330
sxyRain 你好,照你这么说 delete * from ...不是SQL标准 ,delete from table_name 才是?
6 年多之前 回复

DELETE * FROM TABLE 这种是access的写法 带星和不带星是一个意思 都是删除记录,并不是删除表!~ 只不过是不同数据库的不同写法而已!~

u010704330
sxyRain delete * from table_name 这条语句在数据库中执行会报错的,比如 mysql 或者 oracle ,你用的什么数据库?能详细说下你的意思吗?
6 年多之前 回复

其他人说都有一定道理,我补充一下,oracle数据库中没有delete * from 表名这样的删除语句,但是存在delete from 表名

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
求大神解!同样条件SELECT和DELETE在MYSQL上执行发生怪事

``` DELETE FROM TB_VALIDATE_PARAM WHERE UPPER(CONCAT(c_object_id, c_column_code)) NOT IN ( SELECT UPPER(CONCAT(COL.TABLE_NAME, COL.COLUMN_NAME)) FROM information_schema.COLUMNS AS COL WHERE COL.TABLE_SCHEMA = 'jlink' ); SELECT * FROM TB_VALIDATE_PARAM WHERE UPPER(CONCAT(c_object_id, c_column_code)) NOT IN ( SELECT UPPER(CONCAT(COL.TABLE_NAME, COL.COLUMN_NAME)) FROM information_schema.COLUMNS AS COL WHERE COL.TABLE_SCHEMA = 'jlink' ); ``` 两个SQL的条件一模一样,但是明明TB_VALIDATE_PARAM表里有数据,SELECT语句查不到任何数据时,DELETE却可以删除所有数据,我确定表里肯定有数据,也确定执行时肯定没有别人在操作,我尝试了三次,都是一样地效果,求解!

如何解决此错误“MySQL错误:1109(MULTI DELETE中的未知表'table_name')”?

<div class="post-text" itemprop="text"> <p>我正在使用 PHP 和 MySQL (服务器版本: 5.5.31-0ubuntu0.12.04.2)搭建网站,当我运行下面的查询时,它给了我上面的错误。我找不到这个错误背后的任何线索。有人可以帮助我解决这个错误吗?利用现有的查询? 为了供你参考,我把我的疑问写在下面:</p> <pre><code>DELETE ABC.theory_sheet_set, ABC.theory_sheet_questions FROM ABC.theory_sheet_set AS theory_sheet_set, OCN.theory_sheet_questions AS theory_sheet_questions WHERE theory_sheet_set.theory_sheet_set_id = theory_sheet_questions.theory_sheet_set_id AND theory_sheet_set.theory_sheet_id=".$theory_sheet_id </code></pre> <p>报错如下:</p> <pre><code>MySQL Error: 1109 (Unknown table 'theory_sheet_set' in MULTI DELETE) Session halted. </code></pre> <p>我的数据库名叫ABC。其上所有的表名都是有效的,涉及到这个查询的所有表都存在于数据库中。你能帮我解决这个问题吗? </p> </div>

activiti的taskService.complete方法报错, 会签功能,不能删除ACT_RU_EXECUTION表中的数据

2020-03-05 17:25:21,008 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_RU_JOB RES LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_ where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= ?) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ <= ?) and ( (RES.EXECUTION_ID_ is null) or (PI.SUSPENSION_STATE_ = 1) ) ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:21,008 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Parameters: 2020-03-05 17:25:04.781(Timestamp), 2020-03-05 17:25:04.781(Timestamp), 2(Integer), 1(Integer) 2020-03-05 17:25:21,037 DEBUG [impl.persistence.entity.TaskEntity.selectTask] - ==> Preparing: select * from ACT_RU_TASK where ID_ = ? 2020-03-05 17:25:21,051 DEBUG [impl.persistence.entity.TaskEntity.selectTask] - ==> Parameters: e10fc0d1e5a4472f8e3799780d806796(String) 2020-03-05 17:25:21,101 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - <== Total: 0 2020-03-05 17:25:21,321 DEBUG [impl.persistence.entity.TaskEntity.selectTask] - <== Total: 1 2020-03-05 17:25:21,337 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - ==> Preparing: select * from ACT_RU_EXECUTION where ID_ = ? 2020-03-05 17:25:21,349 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String) 2020-03-05 17:25:21,598 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - <== Total: 1 2020-03-05 17:25:21,618 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Preparing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null 2020-03-05 17:25:21,632 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String) 2020-03-05 17:25:21,875 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - <== Total: 2 2020-03-05 17:25:21,893 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - ==> Preparing: select * from ACT_RU_EXECUTION where ID_ = ? 2020-03-05 17:25:21,906 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String) 2020-03-05 17:25:22,152 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - <== Total: 1 2020-03-05 17:25:22,172 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Preparing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null 2020-03-05 17:25:22,186 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String) 2020-03-05 17:25:22,478 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - <== Total: 3 2020-03-05 17:25:22,496 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - ==> Preparing: select * from ACT_RU_EXECUTION where ID_ = ? 2020-03-05 17:25:22,508 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - ==> Parameters: b7a34a039dc74635bba47d4763cd5c9a(String) 2020-03-05 17:25:22,814 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecution] - <== Total: 1 2020-03-05 17:25:22,833 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Preparing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null 2020-03-05 17:25:22,846 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Parameters: b7a34a039dc74635bba47d4763cd5c9a(String) 2020-03-05 17:25:23,506 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - <== Total: 13 2020-03-05 17:25:23,608 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_HI_ACTINST RES WHERE RES.EXECUTION_ID_ = ? and RES.ACT_ID_ = ? and RES.END_TIME_ is null order by RES.ID_ asc ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:23,633 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String), jhbmsh(String), 2(Integer), 1(Integer) 2020-03-05 17:25:23,870 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - <== Total: 0 2020-03-05 17:25:23,936 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_HI_ACTINST RES WHERE RES.EXECUTION_ID_ = ? and RES.ACT_ID_ = ? and RES.END_TIME_ is null order by RES.ID_ asc ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:23,959 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String), jhbmsh(String), 2(Integer), 1(Integer) 2020-03-05 17:25:24,536 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - <== Total: 1 2020-03-05 17:25:24,557 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Preparing: select * from ACT_HI_VARINST where ID_ = ? 2020-03-05 17:25:24,572 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Parameters: ca712ffb55ed4eaebd637337c36e402e(String) 2020-03-05 17:25:24,813 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - <== Total: 1 2020-03-05 17:25:24,834 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - ==> Preparing: select * from ACT_RU_IDENTITYLINK where PROC_INST_ID_ = ? 2020-03-05 17:25:24,847 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - ==> Parameters: b7a34a039dc74635bba47d4763cd5c9a(String) 2020-03-05 17:25:24,874 WARN [org.springframework.scheduling.quartz.LocalDataSourceJobStore] - This scheduler instance (SC-2018112819301583393050864) is still active but was recovered by another instance in the cluster. This may cause inconsistent behavior. 2020-03-05 17:25:25,075 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - <== Total: 3 2020-03-05 17:25:25,097 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByParentTaskId] - ==> Preparing: select * from ACT_RU_TASK where PARENT_TASK_ID_ = ? 2020-03-05 17:25:25,110 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByParentTaskId] - ==> Parameters: e10fc0d1e5a4472f8e3799780d806796(String) 2020-03-05 17:25:25,324 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByParentTaskId] - <== Total: 0 2020-03-05 17:25:25,341 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByTask] - ==> Preparing: select * from ACT_RU_IDENTITYLINK where TASK_ID_ = ? 2020-03-05 17:25:25,354 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByTask] - ==> Parameters: e10fc0d1e5a4472f8e3799780d806796(String) 2020-03-05 17:25:25,510 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByTask] - <== Total: 0 2020-03-05 17:25:25,527 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByTaskId] - ==> Preparing: select * from ACT_RU_VARIABLE where TASK_ID_ = ? 2020-03-05 17:25:25,542 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByTaskId] - ==> Parameters: e10fc0d1e5a4472f8e3799780d806796(String) 2020-03-05 17:25:25,718 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByTaskId] - <== Total: 0 2020-03-05 17:25:25,734 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.selectHistoricTaskInstance] - ==> Preparing: select * from ACT_HI_TASKINST where ID_ = ? 2020-03-05 17:25:25,747 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.selectHistoricTaskInstance] - ==> Parameters: e10fc0d1e5a4472f8e3799780d806796(String) 2020-03-05 17:25:26,030 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.selectHistoricTaskInstance] - <== Total: 1 2020-03-05 17:25:26,051 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Preparing: select distinct T.* from ACT_RU_TASK T where T.EXECUTION_ID_ = ? 2020-03-05 17:25:26,063 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String) 2020-03-05 17:25:26,149 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_RU_JOB RES LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_ where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= ?) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ <= ?) and ( (RES.EXECUTION_ID_ is null) or (PI.SUSPENSION_STATE_ = 1) ) ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:26,149 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Parameters: 2020-03-05 17:25:26.149(Timestamp), 2020-03-05 17:25:26.149(Timestamp), 2(Integer), 1(Integer) 2020-03-05 17:25:26,225 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - <== Total: 0 2020-03-05 17:25:26,347 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - <== Total: 1 2020-03-05 17:25:26,409 DEBUG [impl.persistence.entity.ByteArrayEntity.selectByteArray] - ==> Preparing: select * from ACT_GE_BYTEARRAY where ID_ = ? 2020-03-05 17:25:26,421 DEBUG [impl.persistence.entity.ByteArrayEntity.selectByteArray] - ==> Parameters: 0b5bf947cc4f4b39a3cbe4f92361c92d(String) 2020-03-05 17:25:26,679 DEBUG [impl.persistence.entity.ByteArrayEntity.selectByteArray] - <== Total: 1 2020-03-05 17:25:26,749 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Preparing: select * from ACT_HI_VARINST where ID_ = ? 2020-03-05 17:25:26,767 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Parameters: 32b25168f8d142099f15776efb4d0942(String) 2020-03-05 17:25:26,998 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - <== Total: 1 2020-03-05 17:25:27,061 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Preparing: select * from ACT_HI_VARINST where ID_ = ? 2020-03-05 17:25:27,075 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Parameters: 95bf1206fafb4d94a382912c0e3d49d7(String) 2020-03-05 17:25:27,311 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - <== Total: 1 2020-03-05 17:25:27,331 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - ==> Preparing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ? 2020-03-05 17:25:27,344 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String) 2020-03-05 17:25:27,606 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - <== Total: 1 2020-03-05 17:25:27,623 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - ==> Preparing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ? 2020-03-05 17:25:27,639 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String) 2020-03-05 17:25:27,838 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - <== Total: 0 2020-03-05 17:25:27,849 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - inactive concurrent executions in 'Activity(jhbmsh)': [ConcurrentExecution[a32f7be1df484268a5137525f7482fc8]] 2020-03-05 17:25:27,857 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - other concurrent executions: [] 2020-03-05 17:25:27,866 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - transitions to take concurrent: [(jhbmsh)--sid-29EF82D1-53D5-4ADD-AAF2-B2E4CB2857FB-->(flbmsh), (jhbmsh)--sid-2160AC73-3470-4599-AA6D-39C99E731D3E-->(end)] 2020-03-05 17:25:27,874 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - active concurrent executions: [] 2020-03-05 17:25:27,880 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - recyclable executions for reuse: [ConcurrentExecution[a32f7be1df484268a5137525f7482fc8]] 2020-03-05 17:25:27,888 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - recycled ConcurrentExecution[a32f7be1df484268a5137525f7482fc8] to take transition (jhbmsh)--sid-29EF82D1-53D5-4ADD-AAF2-B2E4CB2857FB-->(flbmsh) 2020-03-05 17:25:27,901 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - Child execution ScopeExecution[dae048adf18e4137bd7503498bdf3b7a] created with parent 2020-03-05 17:25:27,912 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - new ScopeExecution[dae048adf18e4137bd7503498bdf3b7a] with parent ScopeExecution[66c63afb27a44c1688b44a0f6a216f5d] created to take transition (jhbmsh)--sid-2160AC73-3470-4599-AA6D-39C99E731D3E-->(end) 2020-03-05 17:25:28,011 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - ==> Preparing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ? 2020-03-05 17:25:28,025 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - ==> Parameters: b7a34a039dc74635bba47d4763cd5c9a(String) 2020-03-05 17:25:28,284 DEBUG [impl.persistence.entity.ExecutionEntity.selectExecutionsByParentExecutionId] - <== Total: 1 2020-03-05 17:25:28,309 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Preparing: select distinct T.* from ACT_RU_TASK T where T.EXECUTION_ID_ = ? 2020-03-05 17:25:28,659 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Parameters: dae048adf18e4137bd7503498bdf3b7a(String) 2020-03-05 17:25:28,886 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - <== Total: 0 2020-03-05 17:25:28,907 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - ==> Preparing: select * from ACT_RU_JOB J where J.EXECUTION_ID_ = ? 2020-03-05 17:25:28,923 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - ==> Parameters: dae048adf18e4137bd7503498bdf3b7a(String) 2020-03-05 17:25:29,123 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - <== Total: 0 2020-03-05 17:25:29,144 DEBUG [impl.persistence.entity.EventSubscriptionEntity.selectEventSubscriptionsByExecution] - ==> Preparing: select * from ACT_RU_EVENT_SUBSCR where (EXECUTION_ID_ = ?) 2020-03-05 17:25:29,157 DEBUG [impl.persistence.entity.EventSubscriptionEntity.selectEventSubscriptionsByExecution] - ==> Parameters: dae048adf18e4137bd7503498bdf3b7a(String) 2020-03-05 17:25:29,328 DEBUG [impl.persistence.entity.EventSubscriptionEntity.selectEventSubscriptionsByExecution] - <== Total: 0 2020-03-05 17:25:29,347 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Preparing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null 2020-03-05 17:25:29,360 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Parameters: dae048adf18e4137bd7503498bdf3b7a(String) 2020-03-05 17:25:29,542 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - <== Total: 0 2020-03-05 17:25:29,608 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_HI_ACTINST RES WHERE RES.EXECUTION_ID_ = ? and RES.END_TIME_ is null order by RES.ID_ asc ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:29,628 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Parameters: dae048adf18e4137bd7503498bdf3b7a(String), 2147483647(Integer), 1(Integer) 2020-03-05 17:25:29,845 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - <== Total: 0 2020-03-05 17:25:29,867 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Preparing: select distinct T.* from ACT_RU_TASK T where T.EXECUTION_ID_ = ? 2020-03-05 17:25:29,880 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String) 2020-03-05 17:25:30,085 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - <== Total: 0 2020-03-05 17:25:30,105 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - ==> Preparing: select * from ACT_RU_IDENTITYLINK where PROC_INST_ID_ = ? 2020-03-05 17:25:30,120 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - ==> Parameters: dae048adf18e4137bd7503498bdf3b7a(String) 2020-03-05 17:25:30,280 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - <== Total: 0 2020-03-05 17:25:30,301 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - Child execution ScopeExecution[7e9d7306afd1405a9730796c25492472] created with parent 2020-03-05 17:25:30,309 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - initializing ScopeExecution[7e9d7306afd1405a9730796c25492472] 2020-03-05 17:25:30,363 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - Child execution ScopeExecution[024014e14ffb4e95b07060e129af8f1f] created with parent 2020-03-05 17:25:30,380 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Preparing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null 2020-03-05 17:25:30,394 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - ==> Parameters: 024014e14ffb4e95b07060e129af8f1f(String) 2020-03-05 17:25:30,571 DEBUG [impl.persistence.entity.VariableInstanceEntity.selectVariablesByExecutionId] - <== Total: 0 2020-03-05 17:25:30,646 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_HI_ACTINST RES WHERE RES.EXECUTION_ID_ = ? and RES.ACT_ID_ = ? and RES.END_TIME_ is null order by RES.ID_ asc ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:30,670 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Parameters: 024014e14ffb4e95b07060e129af8f1f(String), flbmsh(String), 2(Integer), 1(Integer) 2020-03-05 17:25:30,906 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - <== Total: 0 2020-03-05 17:25:30,980 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Preparing: select distinct T.* from ACT_RU_TASK T where T.EXECUTION_ID_ = ? 2020-03-05 17:25:30,993 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Parameters: 024014e14ffb4e95b07060e129af8f1f(String) 2020-03-05 17:25:31,266 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_RU_JOB RES LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_ where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= ?) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ <= ?) and ( (RES.EXECUTION_ID_ is null) or (PI.SUSPENSION_STATE_ = 1) ) ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:31,266 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Parameters: 2020-03-05 17:25:31.264(Timestamp), 2020-03-05 17:25:31.264(Timestamp), 2(Integer), 1(Integer) 2020-03-05 17:25:31,346 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - <== Total: 0 2020-03-05 17:25:31,494 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - <== Total: 0 2020-03-05 17:25:31,655 DEBUG [engine.impl.persistence.entity.ExecutionEntity] - destroying ConcurrentScopeExecution[66c63afb27a44c1688b44a0f6a216f5d] 2020-03-05 17:25:31,669 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Preparing: select * from ACT_HI_VARINST where ID_ = ? 2020-03-05 17:25:31,682 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Parameters: aa15f1aaa53243febef5fcfc2b0f6378(String) 2020-03-05 17:25:31,922 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - <== Total: 1 2020-03-05 17:25:31,962 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - ==> Preparing: select * from ACT_RU_JOB J where J.EXECUTION_ID_ = ? 2020-03-05 17:25:31,975 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String) 2020-03-05 17:25:32,176 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - <== Total: 0 2020-03-05 17:25:32,195 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - ==> Preparing: select * from ACT_RU_IDENTITYLINK where PROC_INST_ID_ = ? 2020-03-05 17:25:32,209 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String) 2020-03-05 17:25:32,636 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - <== Total: 0 2020-03-05 17:25:32,661 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Preparing: select distinct T.* from ACT_RU_TASK T where T.EXECUTION_ID_ = ? 2020-03-05 17:25:32,676 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - ==> Parameters: b7a34a039dc74635bba47d4763cd5c9a(String) 2020-03-05 17:25:32,879 DEBUG [impl.persistence.entity.TaskEntity.selectTasksByExecutionId] - <== Total: 0 2020-03-05 17:25:32,896 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - ==> Preparing: select * from ACT_RU_JOB J where J.EXECUTION_ID_ = ? 2020-03-05 17:25:32,910 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String) 2020-03-05 17:25:33,115 DEBUG [impl.persistence.entity.JobEntity.selectJobsByExecutionId] - <== Total: 0 2020-03-05 17:25:33,133 DEBUG [impl.persistence.entity.EventSubscriptionEntity.selectEventSubscriptionsByExecution] - ==> Preparing: select * from ACT_RU_EVENT_SUBSCR where (EXECUTION_ID_ = ?) 2020-03-05 17:25:33,147 DEBUG [impl.persistence.entity.EventSubscriptionEntity.selectEventSubscriptionsByExecution] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String) 2020-03-05 17:25:33,345 DEBUG [impl.persistence.entity.EventSubscriptionEntity.selectEventSubscriptionsByExecution] - <== Total: 0 2020-03-05 17:25:33,416 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_HI_ACTINST RES WHERE RES.EXECUTION_ID_ = ? and RES.END_TIME_ is null order by RES.ID_ asc ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:33,437 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String), 2147483647(Integer), 1(Integer) 2020-03-05 17:25:33,676 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.selectHistoricActivityInstancesByQueryCriteria] - <== Total: 0 2020-03-05 17:25:33,713 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Preparing: select * from ACT_HI_VARINST where ID_ = ? 2020-03-05 17:25:33,725 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Parameters: 9a88efabbcef4344a7ae082e5135d645(String) 2020-03-05 17:25:33,968 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - <== Total: 1 2020-03-05 17:25:33,987 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Preparing: select * from ACT_HI_VARINST where ID_ = ? 2020-03-05 17:25:34,001 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - ==> Parameters: ccad23e5a3ae4791a0db8415196dfbe8(String) 2020-03-05 17:25:34,247 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.selectHistoricVariableInstanceByVariableInstanceId] - <== Total: 1 2020-03-05 17:25:34,274 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - ==> Preparing: select * from ACT_RU_IDENTITYLINK where PROC_INST_ID_ = ? 2020-03-05 17:25:34,290 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String) 2020-03-05 17:25:34,462 DEBUG [impl.persistence.entity.IdentityLinkEntity.selectIdentityLinksByProcessInstance] - <== Total: 0 2020-03-05 17:25:36,071 DEBUG [impl.persistence.entity.HistoricDetailEntity.bulkInsertHistoricDetailVariableInstanceUpdate_oracle] - ==> Preparing: INSERT ALL INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT * FROM dual 2020-03-05 17:25:36,377 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_RU_JOB RES LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_ where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= ?) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ <= ?) and ( (RES.EXECUTION_ID_ is null) or (PI.SUSPENSION_STATE_ = 1) ) ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:36,377 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Parameters: 2020-03-05 17:25:36.377(Timestamp), 2020-03-05 17:25:36.377(Timestamp), 2(Integer), 1(Integer) 2020-03-05 17:25:36,455 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - <== Total: 0 2020-03-05 17:25:36,614 DEBUG [impl.persistence.entity.HistoricDetailEntity.bulkInsertHistoricDetailVariableInstanceUpdate_oracle] - ==> Parameters: 8dcaeb292e504cee98af911229524979(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, null, flbmAssigneeList(String), 0(Integer), serializable(String), 2020-03-05 17:25:23.543(Timestamp), cc6836ebfe334fec91dbb7329c15bfd1(String), null, null, null, null, 9755d5dd0f7a49aa8778a6b1a499cb07(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), b93e9df098ae40da8b83ab758823266f(String), null, pass(String), 1(Integer), boolean(String), 2020-03-05 17:25:23.552(Timestamp), null, null, 1(Long), null, null, 8f3bd3bc2e0a40d98b7537ca470f2f61(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), 66c63afb27a44c1688b44a0f6a216f5d(String), b93e9df098ae40da8b83ab758823266f(String), null, nrOfCompletedInstances(String), 1(Integer), integer(String), 2020-03-05 17:25:26.7(Timestamp), null, null, 1(Long), 1(String), null, 56100d82672d4bf99652a6d077d021cd(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), 66c63afb27a44c1688b44a0f6a216f5d(String), b93e9df098ae40da8b83ab758823266f(String), null, nrOfActiveInstances(String), 1(Integer), integer(String), 2020-03-05 17:25:27.011(Timestamp), null, null, 0(Long), 0(String), null, a55c87971dad4b5dab889769bd8a4bbc(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), 578a7c83fcbe454995939a1a0a1ba2f2(String), null, nrOfInstances(String), 0(Integer), integer(String), 2020-03-05 17:25:30.333(Timestamp), null, null, 1(Long), 1(String), null, f72352f58cac47549aa7e666feccbf6e(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), 578a7c83fcbe454995939a1a0a1ba2f2(String), null, nrOfCompletedInstances(String), 0(Integer), integer(String), 2020-03-05 17:25:30.344(Timestamp), null, null, 0(Long), 0(String), null, 27f05823082647cdb5cca9cdf361adc4(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), 578a7c83fcbe454995939a1a0a1ba2f2(String), null, nrOfActiveInstances(String), 0(Integer), integer(String), 2020-03-05 17:25:30.354(Timestamp), null, null, 1(Long), 1(String), null, df5596d20f0f40a9a80a76fc7569669b(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), 024014e14ffb4e95b07060e129af8f1f(String), 578a7c83fcbe454995939a1a0a1ba2f2(String), null, loopCounter(String), 0(Integer), integer(String), 2020-03-05 17:25:30.586(Timestamp), null, null, 0(Long), 0(String), null, e4afcced22ab452998b859b450642d55(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), 024014e14ffb4e95b07060e129af8f1f(String), 578a7c83fcbe454995939a1a0a1ba2f2(String), null, flbmAssignee(String), 0(Integer), string(String), 2020-03-05 17:25:30.926(Timestamp), null, null, null, scfl(String), null, dc64b76bb428492cb4c2e02eb34e2ed4(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, null, loopCounter(String), 0(Integer), integer(String), 2020-03-05 17:25:33.693(Timestamp), null, null, 0(Long), 0(String), null, 702030af6b9f46f59324986178556e24(String), VariableUpdate(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, null, jhbmAssignee(String), 0(Integer), string(String), 2020-03-05 17:25:33.702(Timestamp), null, null, null, scjh(String), null 2020-03-05 17:25:37,553 DEBUG [impl.persistence.entity.HistoricDetailEntity.bulkInsertHistoricDetailVariableInstanceUpdate_oracle] - <== Updates: 11 2020-03-05 17:25:38,455 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.bulkInsertHistoricVariableInstance_oracle] - ==> Preparing: INSERT ALL INTO ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT * FROM dual 2020-03-05 17:25:38,855 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.bulkInsertHistoricVariableInstance_oracle] - ==> Parameters: 80be1bad33f04798bbb819b8e4bc7e72(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, flbmAssigneeList(String), 0(Integer), serializable(String), b8ed975def6b4a1fad9cb618c207aec5(String), null, null, null, null, 2020-03-05 17:25:23.541(Timestamp), 2020-03-05 17:25:23.541(Timestamp), 85da4781a4064ac483015e50581f40be(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), null, nrOfInstances(String), 0(Integer), integer(String), null, null, 1(Long), 1(String), null, 2020-03-05 17:25:30.332(Timestamp), 2020-03-05 17:25:30.332(Timestamp), e92c275b73ba47f6937d59e24873c6f3(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), null, nrOfCompletedInstances(String), 0(Integer), integer(String), null, null, 0(Long), 0(String), null, 2020-03-05 17:25:30.343(Timestamp), 2020-03-05 17:25:30.343(Timestamp), b6d91858263c4112b01b546d9820a0d8(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), null, nrOfActiveInstances(String), 0(Integer), integer(String), null, null, 1(Long), 1(String), null, 2020-03-05 17:25:30.353(Timestamp), 2020-03-05 17:25:30.353(Timestamp), d5f306ba7fbe428cbb5511a592c70e1b(String), b7a34a039dc74635bba47d4763cd5c9a(String), 024014e14ffb4e95b07060e129af8f1f(String), null, loopCounter(String), 0(Integer), integer(String), null, null, 0(Long), 0(String), null, 2020-03-05 17:25:30.585(Timestamp), 2020-03-05 17:25:30.585(Timestamp), c56e783d9e6441718d451bf8a9b034f9(String), b7a34a039dc74635bba47d4763cd5c9a(String), 024014e14ffb4e95b07060e129af8f1f(String), null, flbmAssignee(String), 0(Integer), string(String), null, null, null, scfl(String), null, 2020-03-05 17:25:30.925(Timestamp), 2020-03-05 17:25:30.925(Timestamp), 751249edab7c4566b8c3d8e05ff44480(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, loopCounter(String), 0(Integer), integer(String), null, null, 0(Long), 0(String), null, 2020-03-05 17:25:33.692(Timestamp), 2020-03-05 17:25:33.692(Timestamp), d3f3d6908dde47698ff858499995a76f(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, jhbmAssignee(String), 0(Integer), string(String), null, null, null, scjh(String), null, 2020-03-05 17:25:33.701(Timestamp), 2020-03-05 17:25:33.701(Timestamp) 2020-03-05 17:25:39,516 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.bulkInsertHistoricVariableInstance_oracle] - <== Updates: 8 2020-03-05 17:25:39,553 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.insertHistoricTaskInstance] - ==> Preparing: insert into ACT_HI_TASKINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, NAME_, PARENT_TASK_ID_, DESCRIPTION_, OWNER_, ASSIGNEE_, START_TIME_, CLAIM_TIME_, END_TIME_, DURATION_, DELETE_REASON_, TASK_DEF_KEY_, FORM_KEY_, PRIORITY_, DUE_DATE_, CATEGORY_, TENANT_ID_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 2020-03-05 17:25:39,610 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.insertHistoricTaskInstance] - ==> Parameters: 3d7ff2f6811d4722b492bcd7cb7de6af(String), rent_zczr:1:89f8f180b5d44c82bc0cba80cc6b21a3(String), b7a34a039dc74635bba47d4763cd5c9a(String), 024014e14ffb4e95b07060e129af8f1f(String), 法律部门审核(String), null, null, null, scfl(String), 2020-03-05 17:25:31.505(Timestamp), null, null, null, null, flbmsh(String), /rent/zczrshZybm(String), 50(Integer), null, null, (String) 2020-03-05 17:25:39,789 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.insertHistoricTaskInstance] - <== Updates: 1 2020-03-05 17:25:40,053 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.bulkInsertHistoricActivityInstance_oracle] - ==> Preparing: INSERT ALL INTO ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_, TENANT_ID_ ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_, TENANT_ID_ ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT * FROM dual 2020-03-05 17:25:40,157 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.bulkInsertHistoricActivityInstance_oracle] - ==> Parameters: 578a7c83fcbe454995939a1a0a1ba2f2(String), rent_zczr:1:89f8f180b5d44c82bc0cba80cc6b21a3(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), flbmsh(String), 3d7ff2f6811d4722b492bcd7cb7de6af(String), null, 法律部门审核(String), userTask(String), scfl(String), 2020-03-05 17:25:30.32(Timestamp), null, null, (String), 1be546fd8af546b3ae2e6c286f0846e1(String), rent_zczr:1:89f8f180b5d44c82bc0cba80cc6b21a3(String), b7a34a039dc74635bba47d4763cd5c9a(String), 66c63afb27a44c1688b44a0f6a216f5d(String), end(String), null, null, 结束(String), endEvent(String), null, 2020-03-05 17:25:31.942(Timestamp), 2020-03-05 17:25:31.947(Timestamp), 5(Long), (String) 2020-03-05 17:25:40,407 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.bulkInsertHistoricActivityInstance_oracle] - <== Updates: 2 2020-03-05 17:25:40,425 DEBUG [impl.persistence.entity.HistoricIdentityLinkEntity.insertHistoricIdentityLink] - ==> Preparing: insert into ACT_HI_IDENTITYLINK (ID_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_) values (?, ?, ?, ?, ?, ?) 2020-03-05 17:25:40,449 DEBUG [impl.persistence.entity.HistoricIdentityLinkEntity.insertHistoricIdentityLink] - ==> Parameters: 7283cdf8e0284a70b23f705ee1b97d5d(String), participant(String), scfl(String), null, null, b7a34a039dc74635bba47d4763cd5c9a(String) 2020-03-05 17:25:40,547 DEBUG [impl.persistence.entity.HistoricIdentityLinkEntity.insertHistoricIdentityLink] - <== Updates: 1 2020-03-05 17:25:40,792 DEBUG [impl.persistence.entity.ExecutionEntity.bulkInsertExecution_oracle] - ==> Preparing: INSERT ALL into ACT_RU_EXECUTION (ID_, REV_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_, ACT_ID_, IS_ACTIVE_, IS_CONCURRENT_, IS_SCOPE_,IS_EVENT_SCOPE_, PARENT_ID_, SUPER_EXEC_, SUSPENSION_STATE_, CACHED_ENT_STATE_, TENANT_ID_, NAME_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) into ACT_RU_EXECUTION (ID_, REV_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_, ACT_ID_, IS_ACTIVE_, IS_CONCURRENT_, IS_SCOPE_,IS_EVENT_SCOPE_, PARENT_ID_, SUPER_EXEC_, SUSPENSION_STATE_, CACHED_ENT_STATE_, TENANT_ID_, NAME_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT * FROM dual 2020-03-05 17:25:40,899 DEBUG [impl.persistence.entity.ExecutionEntity.bulkInsertExecution_oracle] - ==> Parameters: 7e9d7306afd1405a9730796c25492472(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, rent_zczr:1:89f8f180b5d44c82bc0cba80cc6b21a3(String), flbmsh(String), false(Boolean), false(Boolean), true(Boolean), false(Boolean), b7a34a039dc74635bba47d4763cd5c9a(String), null, 1(Integer), 6(Integer), (String), null, 024014e14ffb4e95b07060e129af8f1f(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, rent_zczr:1:89f8f180b5d44c82bc0cba80cc6b21a3(String), flbmsh(String), true(Boolean), true(Boolean), false(Boolean), false(Boolean), 7e9d7306afd1405a9730796c25492472(String), null, 1(Integer), 7(Integer), (String), null 2020-03-05 17:25:41,139 DEBUG [impl.persistence.entity.ExecutionEntity.bulkInsertExecution_oracle] - <== Updates: 2 2020-03-05 17:25:41,171 DEBUG [impl.persistence.entity.TaskEntity.insertTask] - ==> Preparing: insert into ACT_RU_TASK (ID_, REV_, NAME_, PARENT_TASK_ID_, DESCRIPTION_, PRIORITY_, CREATE_TIME_, OWNER_, ASSIGNEE_, DELEGATION_, EXECUTION_ID_, PROC_INST_ID_, PROC_DEF_ID_, TASK_DEF_KEY_, DUE_DATE_, CATEGORY_, SUSPENSION_STATE_, TENANT_ID_, FORM_KEY_) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) 2020-03-05 17:25:41,224 DEBUG [impl.persistence.entity.TaskEntity.insertTask] - ==> Parameters: 3d7ff2f6811d4722b492bcd7cb7de6af(String), 法律部门审核(String), null, null, 50(Integer), 2020-03-05 17:25:30.97(Timestamp), null, scfl(String), null, 024014e14ffb4e95b07060e129af8f1f(String), b7a34a039dc74635bba47d4763cd5c9a(String), rent_zczr:1:89f8f180b5d44c82bc0cba80cc6b21a3(String), flbmsh(String), null, null, 1(Integer), (String), /rent/zczrshZybm(String) 2020-03-05 17:25:41,401 DEBUG [impl.persistence.entity.TaskEntity.insertTask] - <== Updates: 1 2020-03-05 17:25:41,421 DEBUG [impl.persistence.entity.IdentityLinkEntity.insertIdentityLink] - ==> Preparing: insert into ACT_RU_IDENTITYLINK (ID_, REV_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_, PROC_DEF_ID_) values (?, 1, ?, ?, ?, ?, ?, ?) 2020-03-05 17:25:41,449 DEBUG [impl.persistence.entity.IdentityLinkEntity.insertIdentityLink] - ==> Parameters: 7283cdf8e0284a70b23f705ee1b97d5d(String), participant(String), scfl(String), null, null, b7a34a039dc74635bba47d4763cd5c9a(String), null 2020-03-05 17:25:41,488 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_RU_JOB RES LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_ where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= ?) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ <= ?) and ( (RES.EXECUTION_ID_ is null) or (PI.SUSPENSION_STATE_ = 1) ) ) a where ROWNUM < ?) where rnum >= ? 2020-03-05 17:25:41,488 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Parameters: 2020-03-05 17:25:41.486(Timestamp), 2020-03-05 17:25:41.486(Timestamp), 2(Integer), 1(Integer) 2020-03-05 17:25:41,550 DEBUG [impl.persistence.entity.IdentityLinkEntity.insertIdentityLink] - <== Updates: 1 2020-03-05 17:25:41,565 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - <== Total: 0 2020-03-05 17:25:41,668 DEBUG [impl.persistence.entity.ByteArrayEntity.bulkInsertByteArray_oracle] - ==> Preparing: INSERT ALL into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_) VALUES (?, 1, ?, ?, ?) into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_) VALUES (?, 1, ?, ?, ?) into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_) VALUES (?, 1, ?, ?, ?) SELECT * FROM dual 2020-03-05 17:25:41,721 DEBUG [impl.persistence.entity.ByteArrayEntity.bulkInsertByteArray_oracle] - ==> Parameters: 7bb43b3ae074482688f9cd47b9279dea(String), var-flbmAssigneeList(String), java.io.ByteArrayInputStream@12e26091(ByteArrayInputStream), null, b8ed975def6b4a1fad9cb618c207aec5(String), hist.var-flbmAssigneeList(String), java.io.ByteArrayInputStream@17175672(ByteArrayInputStream), null, cc6836ebfe334fec91dbb7329c15bfd1(String), hist.detail.var-flbmAssigneeList(String), java.io.ByteArrayInputStream@38920a(ByteArrayInputStream), null 2020-03-05 17:25:41,867 DEBUG [impl.persistence.entity.ByteArrayEntity.bulkInsertByteArray_oracle] - <== Updates: 3 2020-03-05 17:25:42,543 DEBUG [impl.persistence.entity.VariableInstanceEntity.bulkInsertVariableInstance_oracle] - ==> Preparing: INSERT ALL INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) INTO ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) VALUES (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT * FROM dual 2020-03-05 17:25:42,829 DEBUG [impl.persistence.entity.VariableInstanceEntity.bulkInsertVariableInstance_oracle] - ==> Parameters: 80be1bad33f04798bbb819b8e4bc7e72(String), serializable(String), flbmAssigneeList(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, 7bb43b3ae074482688f9cd47b9279dea(String), null, null, null, null, 85da4781a4064ac483015e50581f40be(String), integer(String), nrOfInstances(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), null, null, null, 1(Long), 1(String), null, e92c275b73ba47f6937d59e24873c6f3(String), integer(String), nrOfCompletedInstances(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), null, null, null, 0(Long), 0(String), null, b6d91858263c4112b01b546d9820a0d8(String), integer(String), nrOfActiveInstances(String), b7a34a039dc74635bba47d4763cd5c9a(String), 7e9d7306afd1405a9730796c25492472(String), null, null, null, 1(Long), 1(String), null, d5f306ba7fbe428cbb5511a592c70e1b(String), integer(String), loopCounter(String), b7a34a039dc74635bba47d4763cd5c9a(String), 024014e14ffb4e95b07060e129af8f1f(String), null, null, null, 0(Long), 0(String), null, c56e783d9e6441718d451bf8a9b034f9(String), string(String), flbmAssignee(String), b7a34a039dc74635bba47d4763cd5c9a(String), 024014e14ffb4e95b07060e129af8f1f(String), null, null, null, null, scfl(String), null, 751249edab7c4566b8c3d8e05ff44480(String), integer(String), loopCounter(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, null, null, 0(Long), 0(String), null, d3f3d6908dde47698ff858499995a76f(String), string(String), jhbmAssignee(String), b7a34a039dc74635bba47d4763cd5c9a(String), b7a34a039dc74635bba47d4763cd5c9a(String), null, null, null, null, scjh(String), null 2020-03-05 17:25:43,372 DEBUG [impl.persistence.entity.VariableInstanceEntity.bulkInsertVariableInstance_oracle] - <== Updates: 8 2020-03-05 17:25:43,404 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.updateHistoricTaskInstance] - ==> Preparing: update ACT_HI_TASKINST set EXECUTION_ID_ = ?, NAME_ = ?, PARENT_TASK_ID_ = ?, DESCRIPTION_ = ?, OWNER_ = ?, ASSIGNEE_ = ?, CLAIM_TIME_ = ?, END_TIME_ = ?, DURATION_ = ?, DELETE_REASON_ = ?, TASK_DEF_KEY_ = ?, FORM_KEY_ = ?, PRIORITY_ = ?, DUE_DATE_ = ?, CATEGORY_ = ? where ID_ = ? 2020-03-05 17:25:43,453 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.updateHistoricTaskInstance] - ==> Parameters: a32f7be1df484268a5137525f7482fc8(String), 计划部门审核(String), null, null, null, scjh(String), null, 2020-03-05 17:25:26.042(Timestamp), 783815(Long), completed(String), jhbmsh(String), /rent/zczrshZybm(String), 50(Integer), null, null, e10fc0d1e5a4472f8e3799780d806796(String) 2020-03-05 17:25:43,592 DEBUG [impl.persistence.entity.HistoricTaskInstanceEntity.updateHistoricTaskInstance] - <== Updates: 1 2020-03-05 17:25:43,615 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Preparing: update ACT_HI_VARINST set REV_ = ?, BYTEARRAY_ID_ = ?, DOUBLE_ = ?, LONG_ = ?, TEXT_ = ?, TEXT2_ = ?, VAR_TYPE_ = ?, LAST_UPDATED_TIME_ = ? where ID_ = ? and REV_ = ? 2020-03-05 17:25:43,652 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Parameters: 1(Integer), null, null, 1(Long), 1(String), null, integer(String), 2020-03-05 17:25:31.952(Timestamp), aa15f1aaa53243febef5fcfc2b0f6378(String), 0(Integer) 2020-03-05 17:25:43,767 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - <== Updates: 1 2020-03-05 17:25:43,789 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Preparing: update ACT_HI_VARINST set REV_ = ?, BYTEARRAY_ID_ = ?, DOUBLE_ = ?, LONG_ = ?, TEXT_ = ?, TEXT2_ = ?, VAR_TYPE_ = ?, LAST_UPDATED_TIME_ = ? where ID_ = ? and REV_ = ? 2020-03-05 17:25:43,825 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Parameters: 1(Integer), null, null, 0(Long), 0(String), null, integer(String), 2020-03-05 17:25:31.95(Timestamp), 95bf1206fafb4d94a382912c0e3d49d7(String), 0(Integer) 2020-03-05 17:25:43,946 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - <== Updates: 1 2020-03-05 17:25:43,968 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Preparing: update ACT_HI_VARINST set REV_ = ?, BYTEARRAY_ID_ = ?, DOUBLE_ = ?, LONG_ = ?, TEXT_ = ?, TEXT2_ = ?, VAR_TYPE_ = ?, LAST_UPDATED_TIME_ = ? where ID_ = ? and REV_ = ? 2020-03-05 17:25:44,003 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Parameters: 1(Integer), null, null, null, scjh(String), null, string(String), 2020-03-05 17:25:34.262(Timestamp), ccad23e5a3ae4791a0db8415196dfbe8(String), 0(Integer) 2020-03-05 17:25:44,118 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - <== Updates: 1 2020-03-05 17:25:44,142 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Preparing: update ACT_HI_VARINST set REV_ = ?, BYTEARRAY_ID_ = ?, DOUBLE_ = ?, LONG_ = ?, TEXT_ = ?, TEXT2_ = ?, VAR_TYPE_ = ?, LAST_UPDATED_TIME_ = ? where ID_ = ? and REV_ = ? 2020-03-05 17:25:44,177 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Parameters: 1(Integer), null, null, 0(Long), 0(String), null, integer(String), 2020-03-05 17:25:33.979(Timestamp), 9a88efabbcef4344a7ae082e5135d645(String), 0(Integer) 2020-03-05 17:25:44,306 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - <== Updates: 1 2020-03-05 17:25:44,327 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Preparing: update ACT_HI_VARINST set REV_ = ?, BYTEARRAY_ID_ = ?, DOUBLE_ = ?, LONG_ = ?, TEXT_ = ?, TEXT2_ = ?, VAR_TYPE_ = ?, LAST_UPDATED_TIME_ = ? where ID_ = ? and REV_ = ? 2020-03-05 17:25:44,365 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Parameters: 1(Integer), null, null, 1(Long), 1(String), null, integer(String), 2020-03-05 17:25:31.953(Timestamp), 32b25168f8d142099f15776efb4d0942(String), 0(Integer) 2020-03-05 17:25:44,479 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - <== Updates: 1 2020-03-05 17:25:44,500 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Preparing: update ACT_HI_VARINST set REV_ = ?, BYTEARRAY_ID_ = ?, DOUBLE_ = ?, LONG_ = ?, TEXT_ = ?, TEXT2_ = ?, VAR_TYPE_ = ?, LAST_UPDATED_TIME_ = ? where ID_ = ? and REV_ = ? 2020-03-05 17:25:44,535 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - ==> Parameters: 1(Integer), null, null, 1(Long), null, null, boolean(String), 2020-03-05 17:25:24.824(Timestamp), ca712ffb55ed4eaebd637337c36e402e(String), 0(Integer) 2020-03-05 17:25:44,664 DEBUG [impl.persistence.entity.HistoricVariableInstanceEntity.updateHistoricVariableInstance] - <== Updates: 1 2020-03-05 17:25:44,682 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.updateHistoricActivityInstance] - ==> Preparing: update ACT_HI_ACTINST set EXECUTION_ID_ = ?, ASSIGNEE_ = ?, END_TIME_ = ?, DURATION_ = ? where ID_ = ? 2020-03-05 17:25:44,706 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.updateHistoricActivityInstance] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String), scjh(String), 2020-03-05 17:25:31.652(Timestamp), 789646(Long), b93e9df098ae40da8b83ab758823266f(String) 2020-03-05 17:25:44,796 DEBUG [impl.persistence.entity.HistoricActivityInstanceEntity.updateHistoricActivityInstance] - <== Updates: 1 2020-03-05 17:25:44,812 DEBUG [impl.persistence.entity.TaskEntity.deleteTask] - ==> Preparing: delete from ACT_RU_TASK where ID_ = ? and REV_ = ? 2020-03-05 17:25:44,827 DEBUG [impl.persistence.entity.TaskEntity.deleteTask] - ==> Parameters: e10fc0d1e5a4472f8e3799780d806796(String), 1(Integer) 2020-03-05 17:25:44,896 DEBUG [impl.persistence.entity.TaskEntity.deleteTask] - <== Updates: 1 2020-03-05 17:25:44,908 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - ==> Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ? 2020-03-05 17:25:44,923 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - ==> Parameters: 95bf1206fafb4d94a382912c0e3d49d7(String), 1(Integer) 2020-03-05 17:25:45,000 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - <== Updates: 1 2020-03-05 17:25:45,016 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - ==> Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ? 2020-03-05 17:25:45,032 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - ==> Parameters: aa15f1aaa53243febef5fcfc2b0f6378(String), 1(Integer) 2020-03-05 17:25:45,108 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - <== Updates: 1 2020-03-05 17:25:45,122 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - ==> Preparing: delete from ACT_RU_VARIABLE where ID_ = ? and REV_ = ? 2020-03-05 17:25:45,137 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - ==> Parameters: 32b25168f8d142099f15776efb4d0942(String), 1(Integer) 2020-03-05 17:25:45,214 DEBUG [impl.persistence.entity.VariableInstanceEntity.deleteVariableInstance] - <== Updates: 1 2020-03-05 17:25:45,229 DEBUG [impl.persistence.entity.ExecutionEntity.deleteExecution] - ==> Preparing: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ? 2020-03-05 17:25:45,244 DEBUG [impl.persistence.entity.ExecutionEntity.deleteExecution] - ==> Parameters: 66c63afb27a44c1688b44a0f6a216f5d(String), 1(Integer) 2020-03-05 17:25:48,284 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Preparing: select * from ( select a.*, ROWNUM rnum from ( select RES.* from ACT_RU_JOB RES LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = RES.PROCESS_INSTANCE_ID_ where (RES.RETRIES_ > 0) and (RES.DUEDATE_ is null or RES.DUEDATE_ <= ?) and (RES.LOCK_OWNER_ is null or RES.LOCK_EXP_TIME_ <= ?) and ( (RES.EXECUTION_ID_ is null) or (PI.SUSPENSION_STATE_ = 1) ) ) a where ROWNUM < ?) where rnum >= ? org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: java.sql.SQLException: ORA-02292: 违反完整约束条件 (EAM.SYS_C0018471) - 已找到子记录 2020-03-05 17:25:48,284 DEBUG [impl.persistence.entity.JobEntity.selectNextJobsToExecute] - ==> Parameters: 2020-03-05 17:25:48.284(Timestamp), 2020-03-05 17:25:48.284(Timestamp), 2(Integer), 1(Integer) ### The error may involve org.activiti.engine.impl.persistence.entity.ExecutionEntity.deleteExecution-Inline ### The error occurred while setting parameters ### SQL: delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ? ### Cause: java.sql.SQLException: ORA-02292: 违反完整约束条件 (EAM.SYS_C0018471) - 已找到子记录 ``` ```![图片说明](https://img-ask.csdn.net/upload/202003/05/1583402296_781060.png) ``` ```不能删除ACT_RU_EXECUTION 表中的记录, delete from ACT_RU_EXECUTION where ID_ = ? and REV_ = ? ### Cause: java.sql.SQLException: ORA-02292: 违反完整约束条件

Postgres pg_delete和“DELETE FROM ...”之间的差异

<div class="post-text" itemprop="text"> <p>PHP: pg_delete : <a href="http://php.net/manual/es/function.pg-delete.php" rel="nofollow noreferrer">http://php.net/manual/es/function.pg-delete.php</a></p> <p>and use: "Delete From . . ."</p> <p>What is the difference between both sequences? wich one is more efficient? ¿Wich one have less probable to get errors?</p> </div>

Mysql sql语句 delete * from tables where id='字符串a'

其中字段id 是varchar可变字符串类型 字符串a是用java中 UUID.Random() 生成的一段字符串随机码,是字符串类型,且长度没有越界。 由于是随机生成码其中包含有字符e d这时候SQL语句就执行报错,提示提示错误信息:包含e d那一段字符串有问题。 拜托大神们帮我看下。谢谢

如何在Access中删除一行数据,怎么出错?? String sql="DELETE FROM T

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn= DriverManager.getConnection("jdbc:odbc:DDEmployer"); Statement stat=conn.createStatement(); String id=javax.swing.JOptionPane.showInputDialog(null,"请输入要删除的员工编号"); String sql="DELETE FROM T_EMPLOYER WHERE ID=id"; int i=stat.executeUpdate(sql); System.out.println("成功删除"+i+"行"); 如果执行这条语句,是删除了,但是删除的是全部啊??怎么接?? 如果将SQL语句改为下面这个 String sql="DELETE FROM T_EMPLOYER WHERE T_EMPLOYER.ID=10"; 则正常删除

oracle数据的删除,delete from的使用,速度

有学生表Student —>Sno学号,Sname姓名,Sage年龄,Ssex性别 成绩表Sc结构如下Sno学号,Cno课程号,score成绩 问题:删除'002'同学的'001'课程的成绩?

怎样写这样的一个定时job

``` declare v_msg varchar2(200); v_msg1 varchar2(200); begin for cur in (select * from wbjol_id) loop RECOVERSODATAFROMSOHIS.PROCRECOVERFIRST(cur.ol_id, v_msg, v_msg1); end loop; end; 这个是游标调用存储过程 RECOVERSODATAFROMSOHIS.PROCRECOVERFIRST这个是存过 CREATE OR REPLACE PACKAGE BODY RECOVERSODATAFROMSOHIS IS PROCEDURE PROCRECOVERFIRST(OLID IN NUMBER, RESULTID OUT VARCHAR2, RESULTMSG OUT VARCHAR2) IS STR_SQL VARCHAR2(1000); TABLE_ID TRANSFER_SO_TABLE.ID%TYPE; TABLE_NAME TRANSFER_SO_TABLE.TABLE_NAME%TYPE; KEY_ID TRANSFER_SO_TABLE.KEY_ID%TYPE; V_CNT INTEGER; V_SUB_RESULT_MSG VARCHAR2(500); V_COL_STR VARCHAR2(1000); BEGIN RESULTID := 0; RESULTMSG := ''; --取得购物车表 SELECT A.ID, A.TABLE_NAME, A.KEY_ID INTO TABLE_ID, TABLE_NAME,KEY_ID FROM TRANSFER_SO_TABLE A WHERE A.ID = 1; STR_SQL := 'select COUNT(1) from so_his.' || TABLE_NAME ||' ol where ol.' || KEY_ID ||' = :1'; EXECUTE IMMEDIATE STR_SQL INTO V_CNT USING OLID; IF V_CNT > 0 THEN --取表字段 V_COL_STR := GETTABCOL(TABLE_NAME); STR_SQL := 'insert into so.' || TABLE_NAME || ' select '||V_COL_STR||' from so_his.' || TABLE_NAME || ' ol where ol.' || KEY_ID || ' = :1'; EXECUTE IMMEDIATE STR_SQL USING OLID; PROCRECOVERSEC(OLID, TABLE_ID, RESULTID, V_SUB_RESULT_MSG); STR_SQL := 'delete from so_his.' || TABLE_NAME || ' ol where ol.' || KEY_ID || ' = :1'; EXECUTE IMMEDIATE STR_SQL USING OLID; END IF; IF (RESULTID = 1) THEN RESULTMSG := SUBSTR(RESULTMSG || V_SUB_RESULT_MSG, 1, 500); ELSE RESULTMSG := '成功'; END IF; EXCEPTION WHEN OTHERS THEN RESULTID := 1; RESULTMSG := RESULTMSG || SUBSTR(SQLERRM, 1, 400); END; 这个是存过 我该怎么写这个job ,小白 求帮助 ```

“DELETE FROM”中的MySQL语法错误[关闭]

<div class="post-text" itemprop="text"> <p>Well, I'm making a PHP script that find any row WHERE user_id is equal to the user_id of the user logged and if find any row with the same user_id as the user, "moves" all rows from <strong>friend_requests</strong> with her user_id to a new table called <strong>friend_requestes_notificated</strong></p> <p>Is everything OK in my script, except the code that Delete the row after copy the row to the new table.</p> <hr> <p><strong>That's the error:</strong> </p> <blockquote> <p>"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELETE FROM friend_requests WHERE user_id=1' at line 1"</p> </blockquote> <hr> <p><strong>CODE:</strong></p> <pre><code>&lt;?php include_once("includes/head.php"); ?&gt; &lt;?php require_once("includes/connect/connect.php"); ?&gt; &lt;?php require_once("includes/functions.php"); ?&gt; &lt;?php require_once("includes/jquery.php"); ?&gt; &lt;?php function friend_request_notification(){ global $db; global $userid; $userid = $_SESSION['userid']; $query_id_see = "SELECT user_id FROM friend_requests WHERE user_id=\"{$userid}\" "; $result_set3 = mysql_query($query_id_see, $db) or die(mysql_error()); $change_table = "INSERT INTO friend_requests_notificated (id, user_id, user_id_requester) SELECT id, user_id, user_id_requester FROM friend_requests WHERE user_id={$userid} DELETE FROM friend_requests WHERE user_id={$userid}"; $change_table2 = mysql_query($change_table) or die(mysql_error()); if ($id_requests = mysql_fetch_array($result_set3)){ } else { } } if ($id_requests = mysql_fetch_array($change_table2)){ } else { } friend_request_notification(); ?&gt; </code></pre> </div>

如何从WordPress数据库中删除大量帖子

<div class="post-text" itemprop="text"> <p>In WordPress woocommerce site I have custom post_type <code>klaviyo_shop_cart</code> = =1137717 number of post which I don't need them so I decided to delete them from my database. to do this I have tried few plugin but due to limitation I failed to delete them. </p> <p>My PHP method which can only handle 3000 post deletion i cannot increase these number. if i increase it shows 500 error.</p> <pre><code>&lt;?php $number = 3000 ; $mycustomposts = get_posts( array( 'post_type' =&gt; 'klaviyo_shop_cart', 'numberposts' =&gt; $number ) ); foreach( $mycustomposts as $mypost ) { // Delete's each post. wp_delete_post( $mypost-&gt;ID, true); // Set to False if you want to send them to Trash. } echo '&lt;h3 style=:"color:red;"&gt; DELETED!&lt;/h3&gt;' . $number ; ?&gt; </code></pre> <p>its very slower it an delete 3000 post at a time. SO I want to try bellow sql query to delete post. I know that I cannot delete <code>1137717</code> number of post at time so I need a better solution. my question is there any way to delete <code>50000</code> in a single query ?</p> <pre><code>DELETE FROM wp_posts WHERE post_type='klaviyo_shop_cart'; DELETE FROM wp_postmeta WHERE post_id NOT IN (SELECT id FROM wp_posts); DELETE FROM wp_term_relationships WHERE object_id NOT IN (SELECT id FROM wp_posts); </code></pre> <p>I found this from <a href="https://wordpress.stackexchange.com/questions/66242/how-to-empty-wordpress-custom-post-database-table">here</a></p> <p>this huge number of post can delete a batch operation on 50000 post delete at once.</p> </div>

WordPress中WP_List_table的分页问题

<div class="post-text" itemprop="text"> <p>I'm developing a plugin for WordPress. I use WP_List_Table which output rows from database nicely. The issue I have is the pagination. If I have let's say 200 rows in the database and I set it to only display 50 rows per page, this works and I do get 1 of 4 pages.</p> <p>On page 1 It displays ID 1 to ID 50. But when I click on page 2 it displays ID 2 to ID 51. So it only jumps 1 row and not 50. Where's the issue?</p> <p>This will handle the data:</p> <pre><code> function prepare_items() { global $wpdb; /* Select project for user */ $table_name2 = $wpdb-&gt;prefix . 'project_name'; $current_user = wp_get_current_user(); $sql2 = "SELECT * FROM " . $wpdb-&gt;prefix . "project_name WHERE alloweduser = " . $current_user-&gt;ID; $results2 = $wpdb-&gt;get_results($sql2) or die(mysql_error()); foreach( $results2 as $result2 ) { $table_name = $wpdb-&gt;prefix . "project_name_" . $result2-&gt;projectname; /* Define how many rows to show per page */ $per_page = 50; $columns = $this-&gt;get_columns(); $hidden = array(); $sortable = $this-&gt;get_sortable_columns(); // here we configure table headers, defined in our methods $this-&gt;_column_headers = array($columns, $hidden, $sortable); // [OPTIONAL] process bulk action if any $this-&gt;process_bulk_action(); // will be used in pagination settings $total_items = $wpdb-&gt;get_var("SELECT COUNT(cid) FROM $table_name"); // prepare query params, as usual current page, order by and order direction $paged = isset($_REQUEST['paged']) ? max(0, intval($_REQUEST['paged']) - 0) : 0; $orderby = (isset($_REQUEST['orderby']) &amp;&amp; in_array($_REQUEST['orderby'], array_keys($this-&gt;get_sortable_columns()))) ? $_REQUEST['orderby'] : 'cid'; $order = (isset($_REQUEST['order']) &amp;&amp; in_array($_REQUEST['order'], array('ASC', 'DESC'))) ? $_REQUEST['order'] : 'ASC'; // Define $items array // notice that last argument is ARRAY_A, so we will retrieve array $this-&gt;items = $wpdb-&gt;get_results($wpdb-&gt;prepare("SELECT * FROM $table_name ORDER BY $orderby $order LIMIT %d OFFSET %d", $per_page, $paged), ARRAY_A); // configure pagination $this-&gt;set_pagination_args(array( 'total_items' =&gt; $total_items, // total items defined above 'per_page' =&gt; $per_page, // per page constant defined at top of method 'total_pages' =&gt; ceil($total_items / $per_page) // calculate pages count )); } } } </code></pre> <p>This will output the data:</p> <pre><code>function custom_table_example_submissions_page_handler() { global $wpdb; $table = new Custom_Table_Example_List_Table(); $table-&gt;prepare_items(); $message = ''; if ('delete' === $table-&gt;current_action()) { $message = '&lt;div class="updated below-h2" id="message"&gt;&lt;p&gt;' . sprintf(__('Deleted %d submission(s).', 'custom_table_example'), count($_REQUEST['id'])) . '&lt;/p&gt;&lt;/div&gt;'; } ?&gt; &lt;div class="wrap"&gt; &lt;div class="icon32 icon32-posts-post" id="icon-edit"&gt; &lt;br&gt;&lt;/div&gt; &lt;h2&gt;&lt;?php _e('Submissions', 'custom_table_example')?&gt; &lt;/h2&gt; &lt;?php echo $message; ?&gt; &lt;form id="submissions-table" method="GET"&gt; &lt;input type="hidden" name="page" value="&lt;?php echo $_REQUEST['page']; ?&gt;"/&gt; &lt;?php //$table-&gt;display(array('contributorname', 'email')); ?&gt; &lt;?php $table-&gt;display(); ?&gt; &lt;/form&gt; &lt;/div&gt; &lt;?php } </code></pre> <p>Update:</p> <p>get_columns:</p> <pre><code>function get_columns() { $columns = array( 'cb' =&gt; '&lt;input type="checkbox" /&gt;', //Render a checkbox instead of text 'name' =&gt; __('Name', 'custom_table_example'), 'upload' =&gt; __('Upload', 'custom_table_example'), 'upload2' =&gt; __('Upload', 'custom_table_example'), 'upload3' =&gt; __('Upload', 'custom_table_example'), 'upload4' =&gt; __('Upload', 'custom_table_example'), 'rate' =&gt; __('Rate', 'custom_table_example'), ); return $columns; } </code></pre> <p>$this-&gt;items is retrieved from: <a href="https://core.trac.wordpress.org/browser/tags/4.0.1/src//wp-admin/includes/class-wp-list-table.php#L0" rel="nofollow">https://core.trac.wordpress.org/browser/tags/4.0.1/src//wp-admin/includes/class-wp-list-table.php#L0</a></p> <p>It's called with:</p> <pre><code>if (!class_exists('WP_List_Table')) { require_once(ABSPATH . 'wp-admin/includes/class-wp-list-table.php'); } </code></pre> </div>

无法通过Zend_Db_Table_Abstract-> delete()删除记录

<div class="post-text" itemprop="text"> <p>I am trying to delete a record through a delete action using zend framework Model. i am still unable to figure out why its not deleting and the <strong>$model-&gt;delete() always returns zero. (0)</strong> this is my delete action code.</p> <pre><code>public function deleteAction() { if ($this-&gt;getRequest()-&gt;isGet()) { $id = $this-&gt;getRequest()-&gt;getParam('id'); if (!empty($id)) { $id = $this-&gt;getRequest()-&gt;getPost('id'); $post = new Application_Model_Post(); if ($post-&gt;delete($id)) { $this-&gt;_helper-&gt;flashMessenger-&gt;addMessage('Post deleted.'); } else { $this-&gt;_helper-&gt;flashMessenger-&gt;addMessage('Post note deleted.'); } $this-&gt;view-&gt;messages = $this-&gt;_helper-&gt;flashMessenger-&gt;getMessages(); } $this-&gt;_helper-&gt;redirector('index'); } } </code></pre> <p>The class <strong>Application_Model_Post</strong> has a method called, delete()</p> <pre><code>public function delete($id) { return $this-&gt;getMapper()-&gt;delete($id); } </code></pre> <p>it refers to the delete method in, class Application_Model_PostMapper</p> <pre><code> public function delete($id) { $this-&gt;getDbTable()-&gt;delete('id ='.(int) $id); } public function getDbTable() { if (null === $this-&gt;_dbTable) { $this-&gt;setDbTable('Application_Model_DbTable_Post'); } return $this-&gt;_dbTable; } class Application_Model_DbTable_Post extends Zend_Db_Table_Abstract { protected $_name = 'posts'; } </code></pre> <p>REF: <a href="http://framework.zend.com/apidoc/1.6/Zend_Db/Table/Zend_Db_Table_Abstract.html#delete" rel="nofollow">http://framework.zend.com/apidoc/1.6/Zend_Db/Table/Zend_Db_Table_Abstract.html#delete</a></p> <p><strong>UPDATE 1</strong></p> <p>tried this solution and unable to get it resolved.</p> <pre><code>$where = $this-&gt;getDbTable()-&gt;getAdapter()-&gt;quoteInto('id = ?', (int)$id); $this-&gt;getDbTable()-&gt;delete( $where ); </code></pre> <p>also this, </p> <pre><code>$this-&gt;getDbTable()-&gt;delete(array('id = ?' =&gt; (int) $id)); </code></pre> </div>

sql delete from删除数据问题

我用delete from语句删除表内数据后在另一个地方还能看到删除前的数据,这是个什么原因,哪位大神能解答一下嘛 顺便说下如何解决最好~

postgre数据库,MD5加密盐值.sql

/* 2017.8.7(yi)~2017.8.15(er) --注释 COMMENT ON COLUMN public.kq_users.user_display_name IS '显示名称'; --权限 GRANT ALL ON TABLE public.kq_users TO xfacedata; GRANT SELECT, UPDATE, INSERT, DELETE ON TABLE public.kq_users TO r_xfacedata_qry; GRANT SELECT ON TABLE public.kq_users TO xfacektl; --建表 drop table users; CREATE TABLE users ( user_id character varying(32) NOT NULL, user_name character varying(200) NOT NULL, user_display_name character varying(200) NOT NULL, password character varying(200) NOT NULL, salt_value character varying(50) NOT NULL, PRIMARY KEY (user_id) ) -- 更新字段值 update kq_users set user_display_name = '120' where user_id = '120'; */ --CRUD 表中字段 alter table kq_users add COLUMN user_display_name varchar(200); -- false -- alter table kq_users add COLUMN userDisplayName varying(200); alter table kq_users rename column userDisplayName to user_display_name; alter table kq_users add COLUMN salt_value varchar(100); alter table kq_users rename column id to user_id; alter table kq_users rename column user_id to id; alter table kq_users add COLUMN id varchar(32); -- 删除字段 alter table Test drop COLUMN BazaarType; alter table kq_users drop COLUMN id; alter table kq_users drop COLUMN salt_value; alter table kq_users drop COLUMN user_display_name; /* MD5 加密,盐值; --salt_value 1440345394530213 select md5('admin'||'1440345394530213'); "151ea22fe214a4b37783a3c2fcf393e7" select md5('sys'||'1440345394530213'); "9ba01cc258bc33d0f50177553d905f73" insert into kq_users(user_id, user_name, user_display_name, user_pwd, salt_value) values('11','admin1','管理员1','151ea22fe214a4b37783a3c2fcf393e7','1440345394530213'); insert into kq_users(user_id, user_name, user_display_name, user_pwd, salt_value) values('22','sys1','系统管理员1','9ba01cc258bc33d0f50177553d905f73','1440345394530213'); delete from kq_users where user_id='11'; delete from kq_users where user_id='22'; --ok select t.user_id userId, t.user_name userName,t.user_pwd userPwd, t.user_display_name userDisplayName,t.salt_value salt from kq_users as t where t.user_pwd=md5(('admin'||'1440345394530213')) and t.user_name='admin1'; --ok select t.user_id userId, t.user_name userName,t.user_pwd userPwd, t.user_display_name userDisplayName,t.salt_value salt from kq_users as t where t.user_pwd=md5(('sys'||'1440345394530213')) and t.user_name='sys1'; */ --加注释 COMMENT ON COLUMN public.kq_users.salt_value IS 'md5加密盐值'; limit 1 offset 0; select * from kq_users where user select * from kq_users;

用mysqlbinlog恢复数据,要么提示重复主键,要么没有提示,但是没有恢复数据

在练习mysql的一些操作,遇到了这样一个问题:一直提示我 ERROR 1062 (23000) at line 38: Duplicate entry '1003' for key 'PRIMARY' 要么就是什么提示也没有,但是数据没有恢复。 是在centos7下的 日志如下 /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=1*/; /*!50003 SET @OLD_COMPLETION_TYPE=@@COMPLETION_TYPE,COMPLETION_TYPE=0*/; DELIMITER /*!*/; # at 4 #200613 16:50:44 server id 1 end_log_pos 123 CRC32 0xdfe52871 Start: binlog v 4, server v 5.7.30-log created 200613 16:50:44 at startup # Warning: this binlog is either in use or was not closed properly. ROLLBACK/*!*/; # at 123 #200613 16:50:44 server id 1 end_log_pos 154 CRC32 0x63a556c4 Previous-GTIDs # [empty] # at 154 #200613 17:10:11 server id 1 end_log_pos 219 CRC32 0x0351855f Anonymous_GTID last_committed=0 sequence_number=1 rbr_only=yes /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/; # at 219 #200613 17:10:11 server id 1 end_log_pos 292 CRC32 0xe7ca3b52 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1592039411/*!*/; SET @@session.pseudo_thread_id=2/*!*/; SET @@session.foreign_key_checks=1, @@session.sql_auto_is_null=0, @@session.unique_checks=1, @@session.autocommit=1/*!*/; SET @@session.sql_mode=1436549152/*!*/; SET @@session.auto_increment_increment=1, @@session.auto_increment_offset=1/*!*/; /*!\C utf8 *//*!*/; SET @@session.character_set_client=33,@@session.collation_connection=33,@@session.collation_server=33/*!*/; SET @@session.lc_time_names=0/*!*/; SET @@session.collation_database=DEFAULT/*!*/; BEGIN /*!*/; # at 292 #200613 17:10:11 server id 1 end_log_pos 347 CRC32 0x834fb63f Table_map: `test1`.`student` mapped to number 109 # at 347 #200613 17:10:11 server id 1 end_log_pos 398 CRC32 0x96b8773b Write_rows: table id 109 flags: STMT_END_F ### INSERT INTO `test1`.`student` ### SET ### @1=1003 ### @2='王五' ### @3=103 # at 398 #200613 17:10:11 server id 1 end_log_pos 429 CRC32 0xa6609c17 Xid = 36``` COMMIT/*!*/; # at 429 #200613 17:10:52 server id 1 end_log_pos 494 CRC32 0xa4f6ba2a Anonymous_GTID last_committed=1 sequence_number=2 rbr_only=yes /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/; # at 494 #200613 17:10:52 server id 1 end_log_pos 567 CRC32 0x3e9bbaa8 Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1592039452/*!*/; BEGIN /*!*/; # at 567 #200613 17:10:52 server id 1 end_log_pos 622 CRC32 0xf59a597e Table_map: `test1`.`student` mapped to number 109 # at 622 #200613 17:10:52 server id 1 end_log_pos 673 CRC32 0x6e894d2c Delete_rows: table id 109 flags: STMT_END_F ### DELETE FROM `test1`.`student` ### WHERE ### @1=1004 ### @2='赵六' ### @3=102 # at 673 #200613 17:10:52 server id 1 end_log_pos 704 CRC32 0x7f696394 Xid = 38 COMMIT/*!*/; # at 704 #200613 21:08:10 server id 1 end_log_pos 769 CRC32 0xf3a835d2 Anonymous_GTID last_committed=2 sequence_number=3 rbr_only=yes /*!50718 SET TRANSACTION ISOLATION LEVEL READ COMMITTED*//*!*/; SET @@SESSION.GTID_NEXT= 'ANONYMOUS'/*!*/; # at 769 #200613 21:08:10 server id 1 end_log_pos 842 CRC32 0x68857d8e Query thread_id=2 exec_time=0 error_code=0 SET TIMESTAMP=1592053690/*!*/; BEGIN /*!*/; # at 842 #200613 21:08:10 server id 1 end_log_pos 897 CRC32 0x9b69f363 Table_map: `test1`.`student` mapped to number 109 # at 897 #200613 21:08:10 server id 1 end_log_pos 948 CRC32 0xacb76edb Delete_rows: table id 109 flags: STMT_END_F ### DELETE FROM `test1`.`student` ### WHERE ### @1=1005 ### @2='钱七' ### @3=101 # at 948 #200613 21:08:10 server id 1 end_log_pos 979 CRC32 0x58df2fd6 Xid = 171 COMMIT/*!*/; SET @@SESSION.GTID_NEXT= 'AUTOMATIC' /* added by mysqlbinlog */ /*!*/; DELIMITER ; # End of log file /*!50003 SET COMPLETION_TYPE=@OLD_COMPLETION_TYPE*/; /*!50530 SET @@SESSION.PSEUDO_SLAVE_MODE=0*/; 然后是操作: [root@localhost mysql]# mysqlbinlog --no-defaults --stop-position=842 mysql-bin.000004 | mysql -u root -p Enter password: ERROR 1062 (23000) at line 38: Duplicate entry '1003' for key 'PRIMARY' 我搜过有看到说什么要把主键设为自增,但我觉得应该不是这个问题,然而也试了试,还是一样的问题。 另外,是这么个简单的表: +------+--------+---------+ | id | name | classid | +------+--------+---------+ | 1001 | 张三 | 101 | | 1002 | 李四 | 102 | | 1003 | 王五 | 103 | +------+--------+---------+

PLS-00103 出现符号“AS”在下列:

CREATE OR REPLACE PROCEDURE S_DQCYJ/*(V_NY IN VARCHAR2, v_flag in varchar2 := 'S_DQCYJ')*/ is /*---------------------------------------------------------------------------------------- 功能要求:根据........处理(DQCYJ) 编写人: 编写开始日期: 编写结束日期: 参数定义: 年月 数据来源: 调用方法:其它语言中调用,PL/SQL过程中 如:EXEC S_DQCYJ ('参数'); -----------------------------------------------------------------------------------------*/ AS e_clerror exception; v_error_msg varchar2(4000); v_func_result varchar2(1000); \*存放函数返回值*\ v_count number(1) := 0; \*存放处理前数据检查的返回值*\ type r_col is table of varchar2(4000) index by binary_integer; \*存放列名和列值*\ v_col_name r_col; v_col_values r_col; cursor c_proc_1 is SELECT A.WELL_DESC JH, \* 井号*\ B.YEAR_MON NY, \* 年月*\ C.OIL_PROD_METHOD CYFS, \* 采油方式*\ B.PROD_DAYS SCTS, \* 生产天数*\ C.PUMP_DIAMETER BJ, \* 泵径*\ C.PUMP_DEPTH BS, \* 泵深*\ C.STROKE_LENGTH CC, \* 冲程*\ C.STROKE_FREQUENCY CC1, \* 冲次*\ C.DISCHARGE_CAPACITY PL, \* 排量*\ C.PUMP_EFFICIENCY BX, \* 泵效*\ B.OIL_PRES YY, \* 油压*\ B.CASING_PRES TY, \* 套压*\ B.FLOW_PRES LY, \* 流压*\ B.WATER_CUT_RATIO HS, \* 含水率*\ B.OIL_PROD_DAILY RCYL, \* 日产油量*\ B.WATER_PROD_DAILY RCSL, \* 日产水量*\ B.GAS_PROD_DAILY RCQL, \* 日产气量*\ B.OIL_PROD_VOL_MON YCYL, \* 月产油量*\ B.WATER_PROD_VOL_MON YCSL, \* 月产水量*\ B.GAS_PROD_MON YCQL, \* 月产气量*\ B.OIL_PROD_YEAR NCYL, \* 年产油量*\ B.WATER_PROD_YEAR NCSL, \* 年产水量*\ B.GAS_PROD_YEAR NCQL, \* 年产气量*\ B.OIL_PROD_CUM LJCYL, \* 累计油量*\ B.WATER_PROD_CUM LJCSL, \* 累计水量*\ B.GAS_PROD_CUM LJCQL, \* 累计气量*\ NULL BZ \* 备注*\ FROM cy11.cd_well_source@A2LINK.US.ORACLE.COM A, PC_WELL_PRO_MONTHLY@A2LINK.US.ORACLE.COM B, PC_WELL_PRO_MECH_MONTHLY@A2LINK.US.ORACLE.COM C WHERE A.well_id = B.WELL_ID AND A.well_id = C.WELL_ID AND B.YEAR_MON = C.YEAR_MON AND B.YEAR_MON = V_NY;*/ begin /*先删除log_tab_error表中错误信息,并提交数据库**************/ delete from log_tab_error where error_type = v_flag; commit; \*----------处理前检查输入参数是否正确----------------------*\ if (length(v_ny) <> 6) then v_error_msg := '参数格式输入错误!格式应为“yyyymm”,6位数字'; RAISE e_clerror; end if; \*----------处理前各个数据表数据检查---------------------------------*\ select count(*) into v_count from PC_WELL_PRO_MONTHLY@A2LINK.US.ORACLE.COM where rownum < 2 and YEAR_MON = v_ny; if (v_count = 0) then v_error_msg := '在执行过程S_DQCYJ时:"C_WELL_PRO_MONTHLY"表中没有' || v_ny || '月的数据'; RAISE e_clerror; end if; \*处理前先删除插入表当月数据并提交数据库**********************\ delete from DQCYJ where ny = v_ny; commit; \*开始处理数据************************************************\ v_col_name(1) := 'JH'; \**\ v_col_name(2) := 'NY'; \**\ v_col_name(3) := 'CYFS'; \**\ v_col_name(4) := 'SCTS'; \**\ v_col_name(5) := 'BJ'; \**\ v_col_name(6) := 'BS'; \**\ v_col_name(7) := 'CC'; \**\ v_col_name(8) := 'CC1'; \**\ v_col_name(9) := 'PL'; \**\ v_col_name(10) := 'BX'; \**\ v_col_name(11) := 'YY'; \**\ v_col_name(12) := 'TY'; \**\ v_col_name(13) := 'LY'; \**\ v_col_name(14) := 'HS'; \**\ v_col_name(15) := 'RCYL'; \**\ v_col_name(16) := 'RCSL'; \**\ v_col_name(17) := 'RCQL'; \**\ v_col_name(18) := 'YCYL'; \**\ v_col_name(19) := 'YCSL'; \**\ v_col_name(20) := 'YCQL'; \**\ v_col_name(21) := 'NCYL'; \**\ v_col_name(22) := 'NCSL'; \**\ v_col_name(23) := 'NCQL'; \**\ v_col_name(24) := 'LJCYL'; \**\ v_col_name(25) := 'LJCSL'; \**\ v_col_name(26) := 'LJCQL'; \**\ v_col_name(27) := 'BZ'; \**\ for c_1 in c_proc_1 loop \*--处理各列数据-----------------------------------------------*\ v_col_values(1) := c_1.JH; \**\ v_col_values(2) := c_1.NY; \**\ v_col_values(3) := c_1.CYFS; \**\ v_col_values(4) := c_1.SCTS; \**\ v_col_values(5) := c_1.BJ; \**\ v_col_values(6) := c_1.BS; \**\ v_col_values(7) := c_1.CC; \**\ v_col_values(8) := c_1.CC1; \**\ v_col_values(9) := c_1.PL; \**\ v_col_values(10) := c_1.BX; \**\ v_col_values(11) := c_1.YY; \**\ v_col_values(12) := c_1.TY; \**\ v_col_values(13) := c_1.LY; \**\ v_col_values(14) := c_1.HS; \**\ v_col_values(15) := c_1.RCYL; \**\ v_col_values(16) := c_1.RCSL; \**\ v_col_values(17) := c_1.RCQL; \**\ v_col_values(18) := c_1.YCYL; \**\ v_col_values(19) := c_1.YCSL; \**\ v_col_values(20) := c_1.YCQL; \**\ v_col_values(21) := c_1.NCYL; \**\ v_col_values(22) := c_1.NCSL; \**\ v_col_values(23) := c_1.NCQL; \**\ v_col_values(24) := c_1.LJCYL; \**\ v_col_values(25) := c_1.LJCSL; \**\ v_col_values(26) := c_1.LJCQL; \**\ v_col_values(27) := c_1.BZ; \**\ \*--把处理结果插入目标表---------------------------------------*\ insert into DQCYJ (JH \**\, NY \**\, CYFS \**\, SCTS \**\, BJ \**\, BS \**\, CC \**\, CC1 \**\, PL \**\, BX \**\, YY \**\, TY \**\, LY \**\, HS \**\, RCYL \**\, RCSL \**\, RCQL \**\, YCYL \**\, YCSL \**\, YCQL \**\, NCYL \**\, NCSL \**\, NCQL \**\, LJCYL \**\, LJCSL \**\, LJCQL \**\, BZ \**\) values (c_1.JH \**\, c_1.NY \**\, c_1.CYFS \**\, c_1.SCTS \**\, c_1.BJ \**\, c_1.BS \**\, c_1.CC \**\, c_1.CC1 \**\, c_1.PL \**\, c_1.BX \**\, c_1.YY \**\, c_1.TY \**\, c_1.LY \**\, c_1.HS \**\, c_1.RCYL \**\, c_1.RCSL \**\, c_1.RCQL \**\, c_1.YCYL \**\, c_1.YCSL \**\, c_1.YCQL \**\, c_1.NCYL \**\, c_1.NCSL \**\, c_1.NCQL \**\, c_1.LJCYL \**\, c_1.LJCSL \**\, c_1.LJCQL \**\, c_1.BZ \**\); end loop; commit; \*--执行例外*****************\ exception when e_clerror then ROLLBACK; insert into log_tab_error (error_type, error_msg, error_user) values (v_flag, v_error_msg, null); commit; when DUP_VAL_ON_INDEX then ROLLBACK; v_error_msg := '在执行过程S_DQCYJ时:处理到' || 'JH()=' || v_col_values(1) || 'NY()=' || v_col_values(2) || '时,有重复记录!'; insert into log_tab_error (error_type, error_msg, error_user) values (v_flag, v_error_msg, null); commit; when others then ROLLBACK; IF (SQLCODE = -1401) OR (SQLCODE = -1438) THEN -- \*字符或数值超宽*\ -- \*判断插入值宽度是否大于表字段宽度-----*\ for i in 1 .. 27 loop v_func_result := f_col_len_errmessage('DQCYJ', v_col_name(i), v_col_values(i), 'JH()', v_col_values(1), 'NY()', v_col_values(2)); if (v_func_result != 'Y') then v_error_msg := '在执行过程S_DQCYJ时:' || v_func_result; insert into log_tab_error (error_type, error_msg, error_user) values (v_flag, v_error_msg, null); commit; end if; end loop; ELSE v_error_msg := '在执行S_DQCYJ过程时,执行到' || 'JH()=' || v_col_values(1) || 'NY()=' || v_col_values(2) || '时:' || F_ORA_ERRMESSAGE(SQLCODE) || chr(10) || '系统信息:' || chr(10) || SQLERRM; insert into log_tab_error (error_type, error_msg, error_user) values (v_flag, v_error_msg, null); commit; END IF; END S_DQCYJ; ![图片说明](https://img-ask.csdn.net/upload/201810/18/1539859918_420030.png)

SQLserver: delete语句没有From,为什么可以执行

DELETE [dbo].[T_VrcgGrpMaster] WHERE TenantID = '1234' AND WordGroup = 'bbbb' ; 与 DELETE FROM [dbo].[T_VrcgGrpMaster] WHERE TenantID = '1234' AND WordGroup = 'bbbb' ; 都可以删除一条数据,第一个没有FROM关键字为什么可以执行

通过resolver删除指定的联系人

resolver查询或者删除通讯录指定姓名联系人时候,为什么姓名必须要设置成常量的 形式,变量就不行呢?我的代码中如果name="shanshan"常量的形式,就能够删除 成功,name如果是从textview中输入的姓名的值获取而来的删除就不成功呢? 代码如下: name = tv_name.getText().toString(); // 设置你的操作事项 //删除通讯录中的联系人 //delete(i,name); ContentResolver resolver = getContentResolver(); Uri uri = Uri.parse("content://com.android.contacts/contacts"); Cursor cursor = resolver.query(uri,new String[]{"display_name"},ContactsContract.Data.DISPLAY_NAME+"= ?",new String[]{name},null); //Cursor cursor=resolver.query(ContactsContract.CommonDataKinds.Phone.CONTENT_URI, null, ContactsContract.CommonDataKinds.Phone.DISPLAY_NAME+"="+name, null, null); int b = cursor.getCount(); System.out.println(b); if (cursor.moveToFirst()) { int id = cursor.getInt(0); // 根据id删除data中的相应数据 resolver.delete(RawContacts.CONTENT_URI, "display_name=?",new String[]{name}); uri = Uri.parse("content://com.android.contacts/data"); resolver.delete(Contacts.CONTENT_URI, "display_name=?",new String[] {name }); } 这样子不会成功,name换成通讯录里面有的联系人的名字,即可删除成功,为什么?

Mybaties delet in 无法删除

``` Preparing: DELETE FROM IC_menu WHERE ( id IN ?) Parameters: ('7af43662f45a41c8969d5502a00878ba','9accac9e7bef46fe9a05b2875989f4a8','09302a1c550c42b486a1b1ed259f7925','edfca7bd57e446f2921e68ad275218a2')(String) Updates: 0 ``` 上面这段语句,使用mybaties执行,无法删除,但是在sqlplus中,执行是可以删除的。 有谁遇到过吗?

技术大佬:我去,你写的 switch 语句也太老土了吧

昨天早上通过远程的方式 review 了两名新来同事的代码,大部分代码都写得很漂亮,严谨的同时注释也很到位,这令我非常满意。但当我看到他们当中有一个人写的 switch 语句时,还是忍不住破口大骂:“我擦,小王,你丫写的 switch 语句也太老土了吧!” 来看看小王写的代码吧,看完不要骂我装逼啊。 private static String createPlayer(PlayerTypes p...

Vue + Spring Boot 项目实战(十九):Web 项目优化解决方案

快来一起探索如何打脸我们的破项目,兄弟姐妹们把害怕打在公屏上!

你连存活到JDK8中著名的Bug都不知道,我怎么敢给你加薪

CopyOnWriteArrayList.java和ArrayList.java,这2个类的构造函数,注释中有一句话 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 public ArrayList(Collection&lt;? ...

副业收入是我做程序媛的3倍,工作外的B面人生是怎样的?

提到“程序员”,多数人脑海里首先想到的大约是:为人木讷、薪水超高、工作枯燥…… 然而,当离开工作岗位,撕去层层标签,脱下“程序员”这身外套,有的人生动又有趣,马上展现出了完全不同的A/B面人生! 不论是简单的爱好,还是正经的副业,他们都干得同样出色。偶尔,还能和程序员的特质结合,产生奇妙的“化学反应”。 @Charlotte:平日素颜示人,周末美妆博主 大家都以为程序媛也个个不修边幅,但我们也许...

CSDN:因博主近期注重写专栏文章(已超过150篇),订阅博主专栏人数在突增,近期很有可能提高专栏价格(已订阅的不受影响),提前声明,敬请理解!

CSDN:因博主近期注重写专栏文章(已超过150篇),订阅博主专栏人数在突增,近期很有可能提高专栏价格(已订阅的不受影响),提前声明,敬请理解! 目录 博客声明 大数据了解博主粉丝 博主的粉丝群体画像 粉丝群体性别比例、年龄分布 粉丝群体学历分布、职业分布、行业分布 国内、国外粉丝群体地域分布 博主的近期访问每日增量、粉丝每日增量 博客声明 因近期博主写专栏的文章越来越多,也越来越精细,逐步优化文章。因此,最近一段时间,订阅博主专栏的人数增长也非常快,并且专栏价

一个HashMap跟面试官扯了半个小时

一个HashMap能跟面试官扯上半个小时 关注 安琪拉的博客 1.回复面试领取面试资料 2.回复书籍领取技术电子书 3.回复交流领取技术电子书 前言 HashMap应该算是Java后端工程师面试的必问题,因为其中的知识点太多,很适合用来考察面试者的Java基础。 开场 面试官: 你先自我介绍一下吧! 安琪拉: 我是安琪拉,草丛三婊之一,最强中单(钟馗不服)!哦,不对,串场了,我是**,目...

我说我不会算法,阿里把我挂了。

不说了,字节跳动也反手把我挂了。

记录下入职中软一个月(外包华为)

我在年前从上一家公司离职,没想到过年期间疫情爆发,我也被困在家里,在家呆着的日子让人很焦躁,于是我疯狂的投简历,看面试题,希望可以进大公司去看看。 我也有幸面试了我觉得还挺大的公司的(虽然不是bat之类的大厂,但是作为一名二本计算机专业刚毕业的大学生bat那些大厂我连投简历的勇气都没有),最后选择了中软,我知道这是一家外包公司,待遇各方面甚至不如我的上一家公司,但是对我而言这可是外包华为,能...

面试:第十六章:Java中级开发

HashMap底层实现原理,红黑树,B+树,B树的结构原理 Spring的AOP和IOC是什么?它们常见的使用场景有哪些?Spring事务,事务的属性,传播行为,数据库隔离级别 Spring和SpringMVC,MyBatis以及SpringBoot的注解分别有哪些?SpringMVC的工作原理,SpringBoot框架的优点,MyBatis框架的优点 SpringCould组件有哪些,他们...

培训班出来的人后来都怎么样了?(二)

接着上回说,培训班学习生涯结束了。后面每天就是无休止的背面试题,不是没有头脑的背,培训公司还是有方法的,现在回想当时背的面试题好像都用上了,也被问到了。回头找找面试题,当时都是打印下来天天看,天天背。 不理解呢也要背,面试造飞机,上班拧螺丝。班里的同学开始四处投简历面试了,很快就有面试成功的,刚开始一个,然后越来越多。不知道是什么原因,尝到胜利果实的童鞋,不满足于自己通过的公司,嫌薪水要少了,选择...

面试了一个 31 岁程序员,让我有所触动,30岁以上的程序员该何去何从?

最近面试了一个31岁8年经验的程序猿,让我有点感慨,大龄程序猿该何去何从。

大三实习生,字节跳动面经分享,已拿Offer

说实话,自己的算法,我一个不会,太难了吧

程序员垃圾简历长什么样?

已经连续五年参加大厂校招、社招的技术面试工作,简历看的不下于万份 这篇文章会用实例告诉你,什么是差的程序员简历! 疫情快要结束了,各个公司也都开始春招了,作为即将红遍大江南北的新晋UP主,那当然要为小伙伴们做点事(手动狗头)。 就在公众号里公开征简历,义务帮大家看,并一一点评。《启舰:春招在即,义务帮大家看看简历吧》 一石激起千层浪,三天收到两百多封简历。 花光了两个星期的所有空闲时...

工作八年,月薪60K,裸辞两个月,投简历投到怀疑人生!

近日,有网友在某职场社交平台吐槽,自己裸辞两个月了,但是找工作却让自己的心态都要崩溃了,全部无果,不是已查看无回音,就是已查看不符合。 “工作八年,两年一跳,裸辞两个月了,之前月薪60K,最近找工作找的心态崩了!所有招聘工具都用了,全部无果,不是已查看无回音,就是已查看不符合。进头条,滴滴之类的大厂很难吗???!!!投简历投的开始怀疑人生了!希望 可以收到大厂offer” 先来看看网...

大牛都会用的IDEA调试技巧!!!

导读 前天面试了一个985高校的实习生,问了他平时用什么开发工具,他想也没想的说IDEA,于是我抛砖引玉的问了一下IDEA的调试用过吧,你说说怎么设置断点...

都前后端分离了,咱就别做页面跳转了!统统 JSON 交互

文章目录1. 无状态登录1.1 什么是有状态1.2 什么是无状态1.3 如何实现无状态1.4 各自优缺点2. 登录交互2.1 前后端分离的数据交互2.2 登录成功2.3 登录失败3. 未认证处理方案4. 注销登录 这是本系列的第四篇,有小伙伴找不到之前文章,松哥给大家列一个索引出来: 挖一个大坑,Spring Security 开搞! 松哥手把手带你入门 Spring Security,别再问密...

97年世界黑客编程大赛冠军作品(大小仅为16KB),惊艳世界的编程巨作

这是世界编程大赛第一名作品(97年Mekka ’97 4K Intro比赛)汇编语言所写。 整个文件只有4095个字节, 大小仅仅为16KB! 不仅实现了3D动画的效果!还有一段震撼人心的背景音乐!!! 内容无法以言语形容,实在太强大! 下面是代码,具体操作看最后! @echo off more +1 %~s0|debug e100 33 f6 bf 0 20 b5 10 f3 a5...

程序员是做全栈工程师好?还是专注一个领域好?

昨天,有位大一的同学私信我,说他要做全栈工程师。 我一听,这不害了孩子么,必须制止啊。 谁知,讲到最后,更确定了他做全栈程序员的梦想。 但凡做全栈工程师的,要么很惨,要么很牛! 但凡很牛的,绝不是一开始就是做全栈的! 全栈工程师听起来好听,但绝没有你想象的那么简单。 今天听我来给你唠,记得帮我点赞哦。 一、全栈工程师的职责 如果你学习编程的目的只是玩玩,那随意,想怎么学怎么学。...

不要再到处使用 === 了

我们知道现在的开发人员都使用 === 来代替 ==,为什么呢?我在网上看到的大多数教程都认为,要预测 JavaScript 强制转换是如何工作这太复杂了,因此建议总是使用===。这些都...

什么是a站、b站、c站、d站、e站、f站、g站、h站、i站、j站、k站、l站、m站、n站?00后的世界我不懂!

A站 AcFun弹幕视频网,简称“A站”,成立于2007年6月,取意于Anime Comic Fun,是中国大陆第一家弹幕视频网站。A站以视频为载体,逐步发展出基于原生内容二次创作的完整生态,拥有高质量互动弹幕,是中国弹幕文化的发源地;拥有大量超粘性的用户群体,产生输出了金坷垃、鬼畜全明星、我的滑板鞋、小苹果等大量网络流行文化,也是中国二次元文化的发源地。 B站 全称“哔哩哔哩(bilibili...

十个摸鱼,哦,不对,是炫酷(可以玩一整天)的网站!!!

文章目录前言正文**1、Kaspersky Cyberthreat real-time map****2、Finding Home****3、Silk – Interactive Generative Art****4、Liquid Particles 3D****5、WINDOWS93****6、Staggering Beauty****7、Ostagram图片生成器网址****8、全历史网址*...

终于,月薪过5万了!

来看几个问题想不想月薪超过5万?想不想进入公司架构组?想不想成为项目组的负责人?想不想成为spring的高手,超越99%的对手?那么本文内容是你必须要掌握的。本文主要详解bean的生命...

用了这个 IDE 插件,5分钟解决前后端联调!

点击上方蓝色“程序猿DD”,选择“设为星标”回复“资源”获取独家整理的学习资料!作者 |李海庆我是一个 Web 开发前端工程师,受到疫情影响,今天是我在家办公的第78天。开发了两周,...

大厂的 404 页面都长啥样?最后一个笑了...

每天浏览各大网站,难免会碰到404页面啊。你注意过404页面么?猿妹搜罗来了下面这些知名网站的404页面,以供大家欣赏,看看哪个网站更有创意: 正在上传…重新上传取消 腾讯 正在上传…重新上传取消 网易 淘宝 百度 新浪微博 正在上传…重新上传取消 新浪 京东 优酷 腾讯视频 搜...

自从喜欢上了B站这12个UP主,我越来越觉得自己是个废柴了!

不怕告诉你,我自从喜欢上了这12个UP主,哔哩哔哩成为了我手机上最耗电的软件,几乎每天都会看,可是吧,看的越多,我就越觉得自己是个废柴,唉,老天不公啊,不信你看看…… 间接性踌躇满志,持续性混吃等死,都是因为你们……但是,自己的学习力在慢慢变强,这是不容忽视的,推荐给你们! 都说B站是个宝,可是有人不会挖啊,没事,今天咱挖好的送你一箩筐,首先啊,我在B站上最喜欢看这个家伙的视频了,为啥 ,咱撇...

代码注释如此沙雕,会玩还是你们程序员!

某站后端代码被“开源”,同时刷遍全网的,还有代码里的那些神注释。 我们这才知道,原来程序员个个都是段子手;这么多年来,我们也走过了他们的无数套路… 首先,产品经理,是永远永远吐槽不完的!网友的评论也非常扎心,说看这些代码就像在阅读程序员的日记,每一页都写满了对产品经理的恨。 然后,也要发出直击灵魂的质问:你是尊贵的付费大会员吗? 这不禁让人想起之前某音乐app的穷逼Vip,果然,穷逼在哪里都是...

Java14 新特性解读

Java14 已于 2020 年 3 月 17 号发布,官方特性解读在这里:https://openjdk.java.net/projects/jdk/14/以下是个人对于特性的中文式...

前端还能这么玩?(女朋友生日,用前端写了一个好玩的送给了她,高兴坏了)

前端还能这么玩?(女朋友生日,用前端写了一个好玩的送给了她,高兴坏了)

爬虫(101)爬点重口味的

小弟最近在学校无聊的很哪,浏览网页突然看到一张图片,都快流鼻血。。。然后小弟冥思苦想,得干一点有趣的事情python 爬虫库安装https://s.taobao.com/api?_ks...

工作两年简历写成这样,谁要你呀!

作者:小傅哥 博客:https://bugstack.cn 沉淀、分享、成长,让自己和他人都能有所收获! 一、前言 最近有伙伴问小傅哥,我的简历怎么投递了都没有反应,心里慌的很呀。 工作两年了目前的公司没有什么大项目,整天的维护别人的代码,有坑也不让重构,都烦死了。荒废我一身技能无处施展,投递的简历也没人看。我是不动物园里的猩猩,狒狒了! 我要加班,我要996,我要疯狂编码,求给我个机会… ...

相关热词 c# 开发接口 c# 中方法上面的限制 c# java 时间戳 c#单元测试入门 c# 数组转化成文本 c#实体类主外键关系设置 c# 子函数 局部 c#窗口位置设置 c# list 查询 c# 事件 执行顺序
立即提问
相关内容推荐