oracle in可能超过1000,解决oracle in 超过1000 报错问题

@Override

public void execute(JobExecutionContext arg0) throws JobExecutionException

{

try

{

log.debug("Start ShelfTimeTask ...");

List tasks = taskService.findAllShelfTimingTask();

if(tasks.size()<1000)

{

if (tasks != null && tasks.size() != 0)

{

taskService.batchOnDownTask(tasks);

}

}

else

{

List task = new ArrayList(0);

int len = tasks.size();

for(int i=0;i< len; i++)

{

if((i % 1000) == 0 && i>0)

{

task = new ArrayList(0);

task.add(tasks.get(i));

}

else

{

task.add(tasks.get(i));

}

if((i+1)%1000 == 0)

{

taskService.batchOnDownTask(task);

}

}

}

log.debug("ShelfTimeTask complete...");

}

catch (Exception e)

{

addLog(e);

}

}