자바 java.sql.SQLException 에러 해결좀 부탁드려요 ㅠ_ㅠ

게시물 수정 , 삭제는 로그인 필요

FTP로 파일 전송하는 프로그램인데요 선언할때 문제가 생겨서 출력하면

[2011-09-15 16:06:05]SMS Ftp Send TEST
[2011-09-15 16:06:05] ftpSend2() 기동 시작 =================================

이담으로 진행이 안되네요 ㅠ_ㅠ 소스는 아래 에러 로그는 그 아래 있어요

 

 public void ftpSend() throws Exception
    {
        SnncLog.log(SnncConstantIF.CQM,appName,"SMS Ftp Send TEST");
        String mFullPath = "";
        try
        {
            SnncLog.log(SnncConstantIF.CQM,appName," ftpSend2() 기동 시작 =================================");
           
            // FTPClient ftpClient2 = new org.apache.commons.net.ftp.FTPClient();
            FTPClient ftpClient2 = new FTPClient();
            SnncLog.log(SnncConstantIF.CQM,appName," 111111111111111");
           
            ftpClient2.setControlEncoding("euc-kr");
            SnncLog.log(SnncConstantIF.CQM,appName," 222222222222222");
            ftpClient2.connect("211.53.208.225");
            SnncLog.log(SnncConstantIF.CQM,appName," 333333333333333");
            ftpClient2.login("snnc","snnc0807");
            SnncLog.log(SnncConstantIF.CQM,appName," 444444444444444");
            ftpClient2.setFileType(FTP.BINARY_FILE_TYPE);
            SnncLog.log(SnncConstantIF.CQM,appName," 555555555555555");
           
            File file_in = new File("/WAS/DKSNNC03/LOG/OC4J/CQM/APP/1CQM/CQM_SMS.sms");
            SnncLog.log(SnncConstantIF.CQM,appName," 666666666666666");
            FileInputStream in = new FileInputStream(file_in);
            SnncLog.log(SnncConstantIF.CQM,appName," 777777777777777");
            boolean flag = ftpClient2.storeFile("CQM_SMS.sms", in);  //송신측 파일명
            ftpClient2.logout();
            in.close();
            ftpClient2.disconnect();
           
            SnncLog.log(SnncConstantIF.CQM,appName," ftpSend2() 기동 종료 =================================");
           
        } catch (Exception e)
        {
            SnncLog.log(SnncConstantIF.CQM,appName," error = "+e);
            e.printStackTrace();
            SnncLog.log(SnncConstantIF.CQM,appName,"[ERRO] 비정상 " + appName +"Mgr." + e.getMessage() + ":" + e.getLocalizedMessage() + " : " + e.toString());
            throw new Exception("[PGM-ERR: Mgr " + appName + "]" +e.getMessage());           
        }
    } // end ftpSend

 

 

 

ERROR Log

 

java.sql.SQLException: Statement was closed
 at com.evermind.sql.FilterStatement.intercept(FilterStatement.java:450)
 at com.evermind.sql.FilterPreparedStatement.setString(FilterPreparedStatement.java:191)
 at com.evermind.sql.PreparedStatementBCELProxy.setString(PreparedStatementBCELProxy.java:187)
 at com.posco.mes.common.bl.PosDBModuleHelper.setCurrentModuleName(PosDBModuleHelper.java:103)
 at com.posco.common.reuse.control.adf.PosADFBindingFilter.releaseApplicationModuleToStateless(PosADFBindingFilter.java:285)
 at com.posco.common.reuse.control.adf.PosADFBindingFilter.doFilter(PosADFBindingFilter.java:239)
 at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:16)
 at oracle.adf.model.servlet.ADFBindingFilter.doFilter(ADFBindingFilter.java:239)
 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:669)
 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:340)
 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:830)
 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:228)
 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:133)
 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
 at java.lang.Thread.run(Thread.java:534)