Skip navigation links


com.essbase.eas.server.dbms
Class ServerLogJDBC

java.lang.Object
  extended by com.essbase.eas.server.dbms.JDBCImplementation
      extended by com.essbase.eas.server.dbms.ServerLogJDBC


public class ServerLogJDBC
extends JDBCImplementation

Supports conversion operations for essbase log file viewer. main tables used are: serverlogid, serverlogdetail

Version:
1.0.0, 4/1/2001 Created
Author:
hung vo

Field Summary
static short APP_FIELD
           
static java.lang.String[] colNames
           
static short DATE_FIELD
           
static short DB_FIELD
           
static short MSG_NUM_FIELD
           
static short MSG_TEXT_FIELD
           
static short MSG_TYPE_FIELD
           
static short SERVER_FIELD
           
static short USER_FIELD
           

 

Fields inherited from class com.essbase.eas.server.dbms.JDBCImplementation
con, database, error, props, pstmt, result, rs, showBinds, showSql, stmt

 

Constructor Summary
ServerLogJDBC()
           

 

Method Summary
protected  void addBinds(java.lang.Object[] cond, int bindIndex)
           
protected  void appendConditions(java.lang.StringBuffer buf, java.lang.Object[] cond)
           
 boolean deleteAllConditions(int logId)
           
 boolean deleteCondition(int logId, int id)
           
 boolean deleteLogSession(int logId)
           
 boolean deleteLogSessionDetails(int logId)
           
 java.util.List getAppNames(int logId)
           
 java.sql.ResultSet getConditionDeatils(int logId, int id)
           
 java.sql.ResultSet getConditions(int logId)
           
 java.sql.ResultSet getCount(int logId)
           
 java.util.List getDatabaseNames(int logId, java.lang.String appname)
           
static java.sql.Date getDate(java.sql.ResultSet rs, int col)
           
static java.sql.Timestamp getDateTime(java.sql.ResultSet rs, int col)
           
 java.sql.ResultSet getLogData(int logId, short xData, short yData, short series, java.lang.Object[] cond)
           
 java.sql.ResultSet getLogDeatils(int logId, java.lang.Object[] cond)
           
 java.sql.ResultSet getLogDeatils(int logId, java.lang.String startDate, java.lang.String endDate)
           
 java.lang.Object[] getLogInfo(java.lang.String server, java.lang.String app)
           
 java.sql.ResultSet getLogSearchDeatils(int logId, java.lang.String search)
           
 java.util.List getMessageNumbers(int logId)
           
static java.lang.String getString(java.sql.ResultSet rs, int col)
           
 java.util.List getUserNames(int logId)
           
 boolean insertCondition(int logId, int id, java.lang.String xaxis, java.lang.String yaxis, java.lang.String series, java.lang.String granularity, java.lang.String xtitle, java.lang.String ytitle, java.lang.String title)
           
 boolean insertConditionDetails(int logId, int id, java.lang.String colname, java.lang.String op, java.lang.String op1, java.lang.String op2)
           
 boolean insertIntoLogDetail(int log_id, java.lang.String machine_name, java.lang.String app_name, java.lang.String db_name, java.lang.String user_name, java.lang.String timestamp, java.lang.String error_type, java.lang.String error_number, java.lang.String error_text)
           
 int insertIntoLogId(java.lang.String userName, java.lang.String machineName, java.lang.String appName, java.lang.String fileName, java.lang.String startDate, java.lang.String endDate, long msgCount)
           
 void prepareToInsertLogDetail()
           
 boolean updateCondition(int logId, int id, java.lang.String xaxis, java.lang.String yaxis, java.lang.String series, java.lang.String granularity, java.lang.String xtitle, java.lang.String ytitle, java.lang.String title)
           
 int updateEndDate(int logId, java.lang.String endDate)
           
 int updateLogId(int logId, java.lang.String endDate, long msgCount, boolean bAddMsgCount)
           
 int updateMsgCount(int logId, long msgCount)
           
 int updateMsgCount(int logId, long msgCount, boolean bAddMsgCount)
           

 

Methods inherited from class com.essbase.eas.server.dbms.JDBCImplementation
bindInt, bindString, bindTimestamp, closeCNX, commit, createPreparedStmt, execPreparedStmt, execSQL, getError, getResultSet, isConnected, openCNX, printSql, setAutoCommit, showSql

 

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

 

Field Detail

APP_FIELD

public static final short APP_FIELD
See Also:
Constant Field Values

DB_FIELD

public static final short DB_FIELD
See Also:
Constant Field Values

USER_FIELD

public static final short USER_FIELD
See Also:
Constant Field Values

DATE_FIELD

public static final short DATE_FIELD
See Also:
Constant Field Values

MSG_TYPE_FIELD

public static final short MSG_TYPE_FIELD
See Also:
Constant Field Values

MSG_NUM_FIELD

public static final short MSG_NUM_FIELD
See Also:
Constant Field Values

MSG_TEXT_FIELD

public static final short MSG_TEXT_FIELD
See Also:
Constant Field Values

SERVER_FIELD

public static final short SERVER_FIELD
See Also:
Constant Field Values

colNames

public static final java.lang.String[] colNames

Constructor Detail

ServerLogJDBC

public ServerLogJDBC()

Method Detail

prepareToInsertLogDetail

public void prepareToInsertLogDetail()

insertIntoLogId

public int insertIntoLogId(java.lang.String userName,
                           java.lang.String machineName,
                           java.lang.String appName,
                           java.lang.String fileName,
                           java.lang.String startDate,
                           java.lang.String endDate,
                           long msgCount)

updateLogId

public int updateLogId(int logId,
                       java.lang.String endDate,
                       long msgCount,
                       boolean bAddMsgCount)

updateMsgCount

public int updateMsgCount(int logId,
                          long msgCount)

updateMsgCount

public int updateMsgCount(int logId,
                          long msgCount,
                          boolean bAddMsgCount)

updateEndDate

public int updateEndDate(int logId,
                         java.lang.String endDate)

insertIntoLogDetail

public boolean insertIntoLogDetail(int log_id,
                                   java.lang.String machine_name,
                                   java.lang.String app_name,
                                   java.lang.String db_name,
                                   java.lang.String user_name,
                                   java.lang.String timestamp,
                                   java.lang.String error_type,
                                   java.lang.String error_number,
                                   java.lang.String error_text)

deleteLogSession

public boolean deleteLogSession(int logId)

deleteLogSessionDetails

public boolean deleteLogSessionDetails(int logId)

getLogInfo

public java.lang.Object[] getLogInfo(java.lang.String server,
                                     java.lang.String app)

getDate

public static java.sql.Date getDate(java.sql.ResultSet rs,
                                    int col)

getDateTime

public static java.sql.Timestamp getDateTime(java.sql.ResultSet rs,
                                             int col)

getString

public static java.lang.String getString(java.sql.ResultSet rs,
                                         int col)

appendConditions

protected void appendConditions(java.lang.StringBuffer buf,
                                java.lang.Object[] cond)

addBinds

protected void addBinds(java.lang.Object[] cond,
                        int bindIndex)

getLogDeatils

public java.sql.ResultSet getLogDeatils(int logId,
                                        java.lang.Object[] cond)

getLogData

public java.sql.ResultSet getLogData(int logId,
                                     short xData,
                                     short yData,
                                     short series,
                                     java.lang.Object[] cond)

getLogSearchDeatils

public java.sql.ResultSet getLogSearchDeatils(int logId,
                                              java.lang.String search)

getUserNames

public java.util.List getUserNames(int logId)

getAppNames

public java.util.List getAppNames(int logId)

getDatabaseNames

public java.util.List getDatabaseNames(int logId,
                                       java.lang.String appname)

getMessageNumbers

public java.util.List getMessageNumbers(int logId)

getCount

public java.sql.ResultSet getCount(int logId)

getLogDeatils

public java.sql.ResultSet getLogDeatils(int logId,
                                        java.lang.String startDate,
                                        java.lang.String endDate)

getConditions

public java.sql.ResultSet getConditions(int logId)

getConditionDeatils

public java.sql.ResultSet getConditionDeatils(int logId,
                                              int id)

deleteAllConditions

public boolean deleteAllConditions(int logId)

deleteCondition

public boolean deleteCondition(int logId,
                               int id)

insertCondition

public boolean insertCondition(int logId,
                               int id,
                               java.lang.String xaxis,
                               java.lang.String yaxis,
                               java.lang.String series,
                               java.lang.String granularity,
                               java.lang.String xtitle,
                               java.lang.String ytitle,
                               java.lang.String title)

updateCondition

public boolean updateCondition(int logId,
                               int id,
                               java.lang.String xaxis,
                               java.lang.String yaxis,
                               java.lang.String series,
                               java.lang.String granularity,
                               java.lang.String xtitle,
                               java.lang.String ytitle,
                               java.lang.String title)

insertConditionDetails

public boolean insertConditionDetails(int logId,
                                      int id,
                                      java.lang.String colname,
                                      java.lang.String op,
                                      java.lang.String op1,
                                      java.lang.String op2)

Skip navigation links


Copyright © 2001, 2012, Oracle. All rights reserved.