Methods Summary |
---|
public boolean | createTable(java.sql.Connection connection)
super.con = connection;
return super.createTable(
TableInfo.CREATE_TABLE_REQUEST_END_SQL,
TableInfo.REQUEST_END_TABLE_NAME);
|
public boolean | dropTable(java.sql.Connection connection)
super.con = connection;
return super.createStatmentAndExecuteUpdate(
TableInfo.DROP_TABLE_REQUEST_END_SQL,
TableInfo.REQUEST_END_TABLE_NAME);
|
public java.lang.String | getDeleteSQL()
String newsql = super.updateSqlWithTableName (
TableInfo.DELETE_FROM_TABLE_REQUEST_END_SQL,
TableInfo.REQUEST_END_TABLE_NAME);
return newsql;
|
public java.lang.String | getInsertSQL()
String newsql = super.updateSqlWithTableName(
TableInfo.INSERT_INTO_TABLE_REQUEST_END_SQL,
TableInfo.REQUEST_END_TABLE_NAME);
return newsql;
|
public static TableAccessObject | getInstance()
return _singletonRE;
|
public boolean | insert(java.sql.PreparedStatement pstmt, TransferObject[] transferObject)
// sanity
if (pstmt == null)
return false;
boolean result = false;
try{
for (int i = 0 ; i<transferObject.length; i++) {
RequestEndTO request = (RequestEndTO)transferObject[i];
pstmt.setString(1, request.getRequestId());
pstmt.setLong(2, request.getTimeStamp());
pstmt.addBatch();
}
int[] updated = pstmt.executeBatch();
result = (updated.length == transferObject.length)? true : false;
addTotalEntriesProcessed(updated.length);
if (isTraceOn()){
logger.log(Level.INFO, "Callflow: RequestEndAccessObjectImpl " +
" Attempting to Insert : " + transferObject.length +
" Inserted "+updated.length+ " rows." +
" Total Entries written so far : "+
getTotalEntriesProcessed());
}
} catch(BatchUpdateException bue) {
// log it
logger.log(Level.FINE, "Error inserting data into CallFlow tables", bue);
result = false;
}catch (SQLException se) {
// log it
logger.log(Level.FINE, "Error inserting data into CallFlow tables", se);
result = false;
}
return result;
|