/*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
*
* Copyright 1997-2007 Sun Microsystems, Inc. All rights reserved.
*
* The contents of this file are subject to the terms of either the GNU
* General Public License Version 2 only ("GPL") or the Common Development
* and Distribution License("CDDL") (collectively, the "License"). You
* may not use this file except in compliance with the License. You can obtain
* a copy of the License at https://glassfish.dev.java.net/public/CDDL+GPL.html
* or glassfish/bootstrap/legal/LICENSE.txt. See the License for the specific
* language governing permissions and limitations under the License.
*
* When distributing the software, include this License Header Notice in each
* file and include the License file at glassfish/bootstrap/legal/LICENSE.txt.
* Sun designates this particular file as subject to the "Classpath" exception
* as provided by Sun in the GPL Version 2 section of the License file that
* accompanied this code. If applicable, add the following below the License
* Header, with the fields enclosed by brackets [] replaced by your own
* identifying information: "Portions Copyrighted [year]
* [name of copyright owner]"
*
* Contributor(s):
*
* If you wish your version of this file to be governed by only the CDDL or
* only the GPL Version 2, indicate your decision by adding "[Contributor]
* elects to include this software in this distribution under the [CDDL or GPL
* Version 2] license." If you don't indicate a single choice of license, a
* recipient has the option to distribute your version of this file under
* either the CDDL, the GPL Version 2 or to extend the choice of license to
* its licensees as provided above. However, if you add GPL Version 2 code
* and therefore, elected the GPL Version 2 license, then the option applies
* only if the new code is made subject to such option by the copyright
* holder.
*/
/*
* RequestStartAccessObjectImpl.java
*
* Created on July 11, 2005, 11:15 AM
*/
package com.sun.enterprise.admin.monitor.callflow;
import java.sql.BatchUpdateException;
import java.sql.Connection;
import com.sun.enterprise.admin.monitor.callflow.TableInfo;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import com.sun.enterprise.admin.common.constant.AdminConstants;
/**
*
* @author Harpreet Singh
*/
public class RequestStartAccessObjectImpl extends AbstractTableAccessObject{
private static final Logger logger =
Logger.getLogger(AdminConstants.kLoggerName);
private static RequestStartAccessObjectImpl _singletonRS;
/**
* Creates a new instance of RequestStartAccessObjectImpl
*/
private RequestStartAccessObjectImpl() {
String serverName = super.getServerInstanceName();
super.tableName = TableInfo.REQUEST_START_TABLE_NAME +
serverName.toUpperCase();
super.setName ("RequestStart");
}
public String getInsertSQL () {
String newsql = super.updateSqlWithTableName(
TableInfo.INSERT_INTO_TABLE_REQUEST_START_SQL,
TableInfo.REQUEST_START_TABLE_NAME);
return newsql;
}
public String getDeleteSQL () {
String newsql = super.updateSqlWithTableName (
TableInfo.DELETE_FROM_TABLE_REQUEST_START_SQL,
TableInfo.REQUEST_START_TABLE_NAME);
return newsql;
}
public boolean dropTable(Connection connection) {
super.con = connection;
return super.createStatmentAndExecuteUpdate(TableInfo.
DROP_TABLE_REQUEST_START_SQL, TableInfo.REQUEST_START_TABLE_NAME);
}
public boolean createTable (Connection connection){
super.con = connection;
return super.createTable(TableInfo.
CREATE_TABLE_REQUEST_START_SQL, TableInfo.REQUEST_START_TABLE_NAME);
}
public static synchronized TableAccessObject getInstance() {
if(_singletonRS == null)
_singletonRS = new RequestStartAccessObjectImpl ();
return _singletonRS;
}
public boolean insert(PreparedStatement pstmt, TransferObject[] requestStart) {
// sanity
if (pstmt == null)
return false;
boolean result = false;
try{
for (int i = 0 ; i<requestStart.length; i++) {
RequestStartTO request = (RequestStartTO)requestStart[i];
pstmt.setString(1, request.getRequestId());
pstmt.setLong(2, request.getTimeStamp());
pstmt.setLong (3, request.getTimeStampMillis());
if(request.getRequestType() != null)
pstmt.setString(4, request.getRequestType().toString());
else
pstmt.setString(4, null);
if (request.getIpAddress() != null)
pstmt.setString(5, request.getIpAddress());
else
pstmt.setString (5, null);
pstmt.addBatch();
}
int[] updated = pstmt.executeBatch();
result = (updated.length == requestStart.length)? true : false;
addTotalEntriesProcessed(updated.length);
if (isTraceOn()){
logger.log(Level.INFO, "Callflow: RequestStartAccessObjectImpl " +
" Attempting to Insert : " + requestStart.length +
" Inserted "+updated.length+ " rows."+
" Total Entries written so far: "+
getTotalEntriesProcessed());
}
if (result == false){
logger.log(Level.WARNING, "callflow.error_insert_row");
}
} 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;
}
}
|