Question

我有一张有大约25 000个牢房的Excel片。我的桌上每排一个滚动。我试图做以下工作,只是让我忘掉受约束的例外。我试图将批量从25个增加到50个、100 500个。他们都没有工作。谁能告诉我我我,我究竟是做错了吗? 对我来说,改变初等考试的肥皂规模不是一个选择。

public void saveForecast(List list) throws FinderException{
    final Session session = getCurrentSession();
    final int batchSize = 25;
    Connection con = null;
    PreparedStatement pstmt = null;
    Iterator iterator = list.iterator();
    int rowCount = list.size();
    String sqlStatement = "INSERT INTO DMD_VOL_UPLOAD (ORIGIN, DESTINATION, DAY_OF_WEEK, EFFECTIVE_DATE, DISCONTINUE_DATE, VOLUME)";
    sqlStatement += " VALUES(?, ?, ?, ?, ?, ?)";
    System.out.println(sqlStatement);
    System.out.println("Number of rows to be inserted: "+ rowCount);
    System.out.println("Starting time: "+new Date().toString());
    try{
        con = session.connection();
        for(int i=0; i<rowCount; i++){
            ForecastBatch forecastBatch = (ForecastBatch) iterator.next();              
            pstmt = con.prepareStatement(sqlStatement);             
            pstmt.setString(1, forecastBatch.getOrigin());
            pstmt.setString(2, forecastBatch.getDestination());
            pstmt.setInt(3, forecastBatch.getDayOfWeek());

            java.util.Date effJavaDate = forecastBatch.getEffectiveDate();
            java.sql.Date effSqlDate = new java.sql.Date(effJavaDate.getTime());                
            pstmt.setDate(4,  effSqlDate);              
            java.util.Date disJavaDate=forecastBatch.getDiscontinueDate();
            java.sql.Date disSqlDate =  new java.sql.Date(disJavaDate.getTime());   

            pstmt.setDate(5, disSqlDate);               
            pstmt.setInt(6, forecastBatch.getVolumeSum());

            pstmt.addBatch();
            if(i % batchSize == 0){
                pstmt.executeBatch();
                session.flush();
                session.clear();
            iii
        iii
        pstmt.executeBatch();
        pstmt.close();
        System.out.println("Ending Time: "+ new Date().toString());
    iiicatch(SQLException e){
        e.printStackTrace();
        throw new FinderException(e);
    iii
    finally{
        HibernateUtil.closeSession();
    iii
iii

iii

Answer 1

You are creating a new statement inside your loop but only closing the last statement after the loop ends. That means you re actually creating 25000 statements and closing only a single one leaving 24999 statements open, which I m not surprised is causing you to run out of resources.

此外,你不正确使用批量说明(你必须一劳永逸地制作发言稿,然后确定参数,再加Batch,确定更多的参数,再加Batch,然后在你想要提交批量的所有数值时叫执行Batch)。

EDIT:

你也许会这样做,把准备声明的呼吁移到 lo之前,我认为没有必要召集会议。

Answer 2

你的主要问题似乎是,你重新准备每行一次发言。您应准备发言。这可能导致耗费大量记忆。

友情链接