Revision 5030
Added by daigle over 14 years ago
| ScheduledJobAccess.java | ||
|---|---|---|
| 70 | 70 |
|
| 71 | 71 |
pstmt.setLong(1, jobId); |
| 72 | 72 |
|
| 73 |
logMetacat.info("SQL getJobByName - " + sql);
|
|
| 74 |
logMetacat.info("SQL params: [" + jobId + "]");
|
|
| 73 |
String sqlReport = "ScheduledJobAccess.getJob - SQL: " + sql;
|
|
| 74 |
sqlReport += " [" + jobId + "]";
|
|
| 75 | 75 |
|
| 76 |
logMetacat.info(sqlReport); |
|
| 77 |
|
|
| 76 | 78 |
pstmt.execute(); |
| 77 | 79 |
|
| 78 | 80 |
ResultSet resultSet = pstmt.getResultSet(); |
| ... | ... | |
| 89 | 91 |
pstmt.close(); |
| 90 | 92 |
} |
| 91 | 93 |
} catch (SQLException sqle) {
|
| 92 |
logMetacat.error("ScheduledJobAccess.getJobByName - An error occurred "
|
|
| 94 |
logMetacat.error("ScheduledJobAccess.getJob - An error occurred "
|
|
| 93 | 95 |
+ "closing prepared statement: " + sqle.getMessage()); |
| 94 | 96 |
} |
| 95 | 97 |
} |
| ... | ... | |
| 123 | 125 |
|
| 124 | 126 |
pstmt.setString(1, jobName); |
| 125 | 127 |
|
| 126 |
logMetacat.info("SQL getJobByName - " + sql);
|
|
| 127 |
logMetacat.info("SQL params: [" + jobName + "]");
|
|
| 128 |
String sqlReport = "ScheduledJobAccess.getJobByName - SQL: " + sql;
|
|
| 129 |
sqlReport += " [" + jobName + "]";
|
|
| 128 | 130 |
|
| 131 |
logMetacat.info(sqlReport); |
|
| 132 |
|
|
| 129 | 133 |
pstmt.execute(); |
| 130 | 134 |
|
| 131 | 135 |
ResultSet resultSet = pstmt.getResultSet(); |
| ... | ... | |
| 147 | 151 |
} catch (SQLException sqle) {
|
| 148 | 152 |
logMetacat.error("ScheduledJobAccess.getJobByName - An error occurred "
|
| 149 | 153 |
+ "closing prepared statement: " + sqle.getMessage()); |
| 150 |
} |
|
| 154 |
} finally {
|
|
| 155 |
DBConnectionPool.returnDBConnection(conn, serialNumber); |
|
| 156 |
} |
|
| 151 | 157 |
} |
| 152 | 158 |
|
| 153 | 159 |
// Now get all the job parameters and put those into a list of job parameter |
| ... | ... | |
| 259 | 265 |
pstmt.close(); |
| 260 | 266 |
} |
| 261 | 267 |
} catch (SQLException sqle) {
|
| 262 |
logMetacat.error("ScheduledJobAccess.getJobByName - An error occurred "
|
|
| 268 |
logMetacat.error("ScheduledJobAccess.getAllJobs - An error occurred "
|
|
| 263 | 269 |
+ "closing prepared statement: " + sqle.getMessage()); |
| 264 | 270 |
} finally {
|
| 265 | 271 |
DBConnectionPool.returnDBConnection(conn, serialNumber); |
Also available in: Unified diff
Change location of PropertyService to properties directory