Lines 365-391
Link Here
|
365 |
private final Object lock = LWPsTracker.class.getName() + "_lock"; // NOI18N |
365 |
private final Object lock = LWPsTracker.class.getName() + "_lock"; // NOI18N |
366 |
private final HashMap<Integer, LWPUsage> lastReportedLWPs = new HashMap<Integer, LWPUsage>(); |
366 |
private final HashMap<Integer, LWPUsage> lastReportedLWPs = new HashMap<Integer, LWPUsage>(); |
367 |
private final HashMap<Integer, LWPUsage> newReportedLWPs = new HashMap<Integer, LWPUsage>(); |
367 |
private final HashMap<Integer, LWPUsage> newReportedLWPs = new HashMap<Integer, LWPUsage>(); |
368 |
private PreparedStatement insertStatement = null; |
368 |
private final PreparedStatement insertStatement; |
369 |
private PreparedStatement updateStatement = null; |
369 |
private final PreparedStatement updateStatement; |
370 |
|
370 |
|
371 |
public LWPsTracker() { |
371 |
public LWPsTracker() { |
|
|
372 |
PreparedStatement _insertStatement = null; |
373 |
PreparedStatement _updateStatement = null; |
372 |
try { |
374 |
try { |
373 |
insertStatement = sqlStorage.prepareStatement( |
375 |
if (sqlStorage != null) { |
374 |
String.format("insert into %s (%s, %s, %s) values (?, ?, null)", // NOI18N |
376 |
_insertStatement = sqlStorage.prepareStatement( |
375 |
MSASQLTables.lwps.tableMetadata.getName(), |
377 |
String.format("insert into %s (%s, %s, %s) values (?, ?, null)", // NOI18N |
376 |
MSASQLTables.lwps.LWP_ID.getColumnName(), |
378 |
MSASQLTables.lwps.tableMetadata.getName(), |
377 |
MSASQLTables.lwps.LWP_START.getColumnName(), |
379 |
MSASQLTables.lwps.LWP_ID.getColumnName(), |
378 |
MSASQLTables.lwps.LWP_END.getColumnName())); |
380 |
MSASQLTables.lwps.LWP_START.getColumnName(), |
379 |
updateStatement = sqlStorage.prepareStatement( |
381 |
MSASQLTables.lwps.LWP_END.getColumnName())); |
380 |
String.format("update %s set %s = ? where %s = ?", // NOI18N |
382 |
_updateStatement = sqlStorage.prepareStatement( |
381 |
MSASQLTables.lwps.tableMetadata.getName(), |
383 |
String.format("update %s set %s = ? where %s = ?", // NOI18N |
382 |
MSASQLTables.lwps.LWP_END.getColumnName(), |
384 |
MSASQLTables.lwps.tableMetadata.getName(), |
383 |
MSASQLTables.lwps.LWP_ID.getColumnName())); |
385 |
MSASQLTables.lwps.LWP_END.getColumnName(), |
|
|
386 |
MSASQLTables.lwps.LWP_ID.getColumnName())); |
387 |
} |
384 |
} catch (Throwable th) { |
388 |
} catch (Throwable th) { |
385 |
if (log.isLoggable(Level.FINE)) { |
389 |
if (log.isLoggable(Level.FINE)) { |
386 |
log.log(Level.FINE, "will not provide data...", th); // NOI18N |
390 |
log.log(Level.FINE, "will not provide data...", th); // NOI18N |
387 |
} |
391 |
} |
388 |
|
392 |
} finally { |
|
|
393 |
insertStatement = _insertStatement; |
394 |
updateStatement = _updateStatement; |
389 |
} |
395 |
} |
390 |
} |
396 |
} |
391 |
|
397 |
|