Project

General

Profile

« Previous | Next » 

Revision 5030

Added by daigle over 14 years ago

Change location of PropertyService to properties directory

View differences:

ScheduledJobParamAccess.java
101 101 
						pstmt.close();
102 102 
					}
103 103 
				} catch (SQLException sqle) {
104 
					logMetacat.error("ScheduledJobParamsAccess.createJobParams - An error occurred "
104 
					logMetacat.error("ScheduledJobParamAccess.createJobParams - An error occurred "
105 105 
							+ "closing prepared statement: " + sqle.getMessage());
106 106 
				} finally {
107 107 
					DBConnectionPool.returnDBConnection(conn, serialNumber);
......
122 122 
		// change the status to deleted
123 123 
		try {
124 124 
			String sql = "UPDATE scheduled_job_params SET status = ? WHERE jobId = ?";
125 
			pstmt = conn.prepareStatement(sql);
126
125 127 
			pstmt.setString(1, StatusUtil.DELETED);
126 128 
			pstmt.setLong(1, jobId);
127 129
128 
			logMetacat.info("SQL deleteJobParams - " + sql);
130 
			logMetacat.info("ScheduledJobParamsAccess.deleteJobParams - SQL: " + sql);
129 131 

  		




  130
  132
  
    
			pstmt.execute();


  		




  131
  133
  
    
		} catch (SQLException sqle) {


  		




  ......




  137
  139
  
    
					pstmt.close();


  		




  138
  140
  
    
				}


  		




  139
  141
  
    
			} catch (SQLException sqle) {


  		




  140
  
  
    
				logMetacat.error("ScheduledJobParamsAccess.createJobParams - An error occurred " 


  		




  
  142
  
    
				logMetacat.error("ScheduledJobParamsAccess.deleteJobParams - An error occurred " 


  		




  141
  143
  
    
						+ "closing prepared statement: " + sqle.getMessage());


  		




  142
  144
  
    
			} finally {


  		




  143
  145
  
    
				DBConnectionPool.returnDBConnection(conn, serialNumber);


  		












Also available in:  Unified diff