解决oracle in 超过1000 报错问题

最新推荐文章于 2024-09-08 17:57:47 发布

绿源2008

最新推荐文章于 2024-09-08 17:57:47 发布

阅读量2.4k

点赞数

分类专栏： J2EE

本文链接：https://blog.csdn.net/chenkeqin_2012/article/details/18444561

版权

J2EE 专栏收录该内容

9 篇文章 0 订阅

订阅专栏

@Override
    public void execute(JobExecutionContext arg0) throws JobExecutionException
    {
        try
        {
            log.debug("Start ShelfTimeTask ...");
            List<TimingTask> tasks = taskService.findAllShelfTimingTask();
            if(tasks.size()<1000)
            {

                if (tasks != null && tasks.size() != 0)
                {
                    taskService.batchOnDownTask(tasks);
                }
            }
            else
            {
                List<TimingTask> task = new ArrayList<TimingTask>(0);
                int len = tasks.size();
                for(int i=0;i< len; i++)
                {
                    if((i % 1000) == 0 && i>0)
                    {

                        task = new ArrayList<TimingTask>(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);
        }
    }