cgl.narada.service.storage.db
Class DatabaseStatements

java.lang.Object
  extended by cgl.narada.service.storage.db.DatabaseStatements

public class DatabaseStatements
extends Object

Title: DatabaseStatements

Description: Statements for Mysql

Copyright: Copyright (c) 2005


Method Summary
 void executeDeleteFromEntity13Stmt(String entityId)
           
 void executeDeleteFromEntityInventory13Stmt(String sequenceNumber)
           
 void executeDeleteFromEntityInventory25Stmt(String sequenceNumber, String entityId)
           
 void executeDeleteFromEntityTemplate15Stmt(String entityId, String templateId)
           
 void executeDeleteFromInventoryFull13Stmt(String sequenceNumber)
           
 void executeDeleteFromInventoryLight13(String sequenceNumber)
           
 void executeDeleteFromProfile15Stmt(String templateId, String profileId)
           
 void executeDeleteFromTemplate13Stmt(String templateId)
           
 void executeDeleteFromTimestampInfo13Stmt(String sequenceNumber)
           
 void executeInsertIntoEntityInventoryStmt(String sequenceNumber, String destAddr)
           
 void executeInsertIntoEntityStmt(String entityId)
           
 void executeInsertIntoEntityTemplateStmt(String templateId, String entityId)
           
 void executeInsertIntoInventoryFullStmt(String sequenceNumber, String previousSequenceNumber, String eventID, byte[] eventString, String templateId)
           
 void executeInsertIntoInventoryLightStmt(String sequenceNumber, String previousSequenceNumber, String templateId, String catenation, String status)
           
 void executeInsertIntoProfileStmt(String profileId, String profileType, byte[] subscription, String templateId, String destinationAddress)
           
 void executeInsertIntoTemplateStmt(String templateID, String templateType, byte[] templateInfo)
           
 void executeInsertIntoTimestampInfoStmt(String sequenceNumber, String timestamp, String templateId)
           
 ResultSet executeInventoryLightCompleteRowDESCStmt(String templateId)
           
 ResultSet executeInventoryLightCompleteRowStmt(String templateId)
           
 ResultSet executeSelectAllFromEntity9Stmt()
           
 ResultSet executeSelectAllFromEntityInventoryStmt(String sequenceNumber)
           
 ResultSet executeSelectCatenationFromEntityTemplateStmt(String templateId, String entityId)
           
 ResultSet executeSelectEntityIdFromEntityTemplateStmt(String templateId)
           
 ResultSet executeSelectEventFromInventoryFullStmt(String sequenceNumber)
           
 ResultSet executeSelectMAXSeqNumberFromEntityInventoryStmt()
           
 ResultSet executeSelectMAXSeqNumberFromInventoryFullStmt()
           
 ResultSet executeSelectMAXSeqNumberFromInventoryLight1Stmt()
           
 ResultSet executeSelectMAXSeqNumberFromInventoryLight2Stmt(String templateId)
           
 ResultSet executeSelectMAXSeqNumberTimestampFromTimestampInfoStmt(String templateId)
           
 ResultSet executeSelectMINSeqNumberTimestampFromTimestampInfoStmt(String templateId)
           
 ResultSet executeSelectProfileTypeSubscriptionFromProfileStmt(String templateId)
           
 ResultSet executeSelectSeqNumberFromEntityInventoryInventoryLightStmt(String seqNumber1, String seqNumber2, String entityId, String templateId)
           
 ResultSet executeSelectSeqNumberFromInventoryLight15Stmt(String templateId)
           
 ResultSet executeSelectSeqNumberFromInventoryLight29Stmt(String seqNumber1, String seqNumber2, String templateId)
           
 ResultSet executeSelectSeqNumberFromTimestampInfoStmt(String templateId, String timestamp1, String timestamp2)
           
 ResultSet executeSelectSeqNumberTimestampFromTimestampInfo15Stmt(String templateId)
           
 ResultSet executeSelectSeqNumberTimestampFromTimestampInfo29Stmt(String templateId, String timestamp1, String timestamp2)
           
 ResultSet executeSelectSeqNumberTimestampFromTimestampInfo39Stmt(String templateId, String sequenceNumber, String timestamp)
           
 ResultSet executeSelectSyncpointFromEntityTemplateStmt(String templateId, String entityId)
           
 ResultSet executeSelectTemplateBytesFromTemplateStmt()
           
 ResultSet executeSelectTimestampFromTimestampInfoStmt(String templateId, String sequenceNumber)
           
 ResultSet executeTimestampInfoCompleteRowDESCStmt(String templateId)
           
 ResultSet executeTimestampInfoCompleteRowStmt(String templateId)
           
 void executeUpdateEntityInventory16Stmt(String entityId1, String sequenceNumber, String entityId2)
           
 void executeUpdateEntityTemplate16Stmt(String syncpoint, String templateId, String entityId)
           
 void executeUpdateEntityTemplate26Stmt(String catenation, String templateId, String entityId)
           
 void executeUpdateInventoryLightStatusStmt(int status)
           
static DatabaseStatements getInstance()
           
 void initialize(Connection connection, DataAccessObject storageDao)
           
 void initializeDeleteAndUpdateStatements()
           
 void initializeInsertIntoStatements()
           
 void initializeSelectStatements()
           
 void initializeUpdateStatements()
           
static void main(String[] args)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

getInstance

public static DatabaseStatements getInstance()

initialize

public void initialize(Connection connection,
                       DataAccessObject storageDao)

initializeUpdateStatements

public void initializeUpdateStatements()

initializeInsertIntoStatements

public void initializeInsertIntoStatements()

initializeDeleteAndUpdateStatements

public void initializeDeleteAndUpdateStatements()

initializeSelectStatements

public void initializeSelectStatements()

executeUpdateInventoryLightStatusStmt

public void executeUpdateInventoryLightStatusStmt(int status)
                                           throws ServiceException
Throws:
ServiceException

executeInsertIntoEntityStmt

public void executeInsertIntoEntityStmt(String entityId)
                                 throws ServiceException
Throws:
ServiceException

executeInsertIntoEntityInventoryStmt

public void executeInsertIntoEntityInventoryStmt(String sequenceNumber,
                                                 String destAddr)
                                          throws ServiceException
Throws:
ServiceException

executeInsertIntoEntityTemplateStmt

public void executeInsertIntoEntityTemplateStmt(String templateId,
                                                String entityId)
                                         throws ServiceException
Throws:
ServiceException

executeInsertIntoInventoryFullStmt

public void executeInsertIntoInventoryFullStmt(String sequenceNumber,
                                               String previousSequenceNumber,
                                               String eventID,
                                               byte[] eventString,
                                               String templateId)
                                        throws ServiceException
Throws:
ServiceException

executeInsertIntoInventoryLightStmt

public void executeInsertIntoInventoryLightStmt(String sequenceNumber,
                                                String previousSequenceNumber,
                                                String templateId,
                                                String catenation,
                                                String status)
                                         throws ServiceException
Throws:
ServiceException

executeInsertIntoProfileStmt

public void executeInsertIntoProfileStmt(String profileId,
                                         String profileType,
                                         byte[] subscription,
                                         String templateId,
                                         String destinationAddress)
                                  throws ServiceException
Throws:
ServiceException

executeInsertIntoTemplateStmt

public void executeInsertIntoTemplateStmt(String templateID,
                                          String templateType,
                                          byte[] templateInfo)
                                   throws ServiceException
Throws:
ServiceException

executeInsertIntoTimestampInfoStmt

public void executeInsertIntoTimestampInfoStmt(String sequenceNumber,
                                               String timestamp,
                                               String templateId)
                                        throws ServiceException
Throws:
ServiceException

executeDeleteFromEntity13Stmt

public void executeDeleteFromEntity13Stmt(String entityId)
                                   throws ServiceException
Throws:
ServiceException

executeDeleteFromEntityInventory13Stmt

public void executeDeleteFromEntityInventory13Stmt(String sequenceNumber)
                                            throws ServiceException
Throws:
ServiceException

executeDeleteFromEntityInventory25Stmt

public void executeDeleteFromEntityInventory25Stmt(String sequenceNumber,
                                                   String entityId)
                                            throws ServiceException
Throws:
ServiceException

executeDeleteFromEntityTemplate15Stmt

public void executeDeleteFromEntityTemplate15Stmt(String entityId,
                                                  String templateId)
                                           throws ServiceException
Throws:
ServiceException

executeDeleteFromInventoryFull13Stmt

public void executeDeleteFromInventoryFull13Stmt(String sequenceNumber)
                                          throws ServiceException
Throws:
ServiceException

executeDeleteFromInventoryLight13

public void executeDeleteFromInventoryLight13(String sequenceNumber)
                                       throws ServiceException
Throws:
ServiceException

executeDeleteFromProfile15Stmt

public void executeDeleteFromProfile15Stmt(String templateId,
                                           String profileId)
                                    throws ServiceException
Throws:
ServiceException

executeDeleteFromTemplate13Stmt

public void executeDeleteFromTemplate13Stmt(String templateId)
                                     throws ServiceException
Throws:
ServiceException

executeDeleteFromTimestampInfo13Stmt

public void executeDeleteFromTimestampInfo13Stmt(String sequenceNumber)
                                          throws ServiceException
Throws:
ServiceException

executeUpdateEntityTemplate16Stmt

public void executeUpdateEntityTemplate16Stmt(String syncpoint,
                                              String templateId,
                                              String entityId)
                                       throws ServiceException
Throws:
ServiceException

executeUpdateEntityTemplate26Stmt

public void executeUpdateEntityTemplate26Stmt(String catenation,
                                              String templateId,
                                              String entityId)
                                       throws ServiceException
Throws:
ServiceException

executeUpdateEntityInventory16Stmt

public void executeUpdateEntityInventory16Stmt(String entityId1,
                                               String sequenceNumber,
                                               String entityId2)
                                        throws ServiceException
Throws:
ServiceException

executeSelectTemplateBytesFromTemplateStmt

public ResultSet executeSelectTemplateBytesFromTemplateStmt()
                                                     throws ServiceException
Throws:
ServiceException

executeSelectAllFromEntity9Stmt

public ResultSet executeSelectAllFromEntity9Stmt()
                                          throws ServiceException
Throws:
ServiceException

executeSelectMAXSeqNumberFromInventoryFullStmt

public ResultSet executeSelectMAXSeqNumberFromInventoryFullStmt()
                                                         throws ServiceException
Throws:
ServiceException

executeSelectMAXSeqNumberFromInventoryLight1Stmt

public ResultSet executeSelectMAXSeqNumberFromInventoryLight1Stmt()
                                                           throws ServiceException
Throws:
ServiceException

executeSelectMAXSeqNumberFromEntityInventoryStmt

public ResultSet executeSelectMAXSeqNumberFromEntityInventoryStmt()
                                                           throws ServiceException
Throws:
ServiceException

executeSelectEntityIdFromEntityTemplateStmt

public ResultSet executeSelectEntityIdFromEntityTemplateStmt(String templateId)
                                                      throws ServiceException
Throws:
ServiceException

executeSelectEventFromInventoryFullStmt

public ResultSet executeSelectEventFromInventoryFullStmt(String sequenceNumber)
                                                  throws ServiceException
Throws:
ServiceException

executeSelectMAXSeqNumberFromInventoryLight2Stmt

public ResultSet executeSelectMAXSeqNumberFromInventoryLight2Stmt(String templateId)
                                                           throws ServiceException
Throws:
ServiceException

executeSelectProfileTypeSubscriptionFromProfileStmt

public ResultSet executeSelectProfileTypeSubscriptionFromProfileStmt(String templateId)
                                                              throws ServiceException
Throws:
ServiceException

executeSelectSeqNumberTimestampFromTimestampInfo15Stmt

public ResultSet executeSelectSeqNumberTimestampFromTimestampInfo15Stmt(String templateId)
                                                                 throws ServiceException
Throws:
ServiceException

executeSelectSeqNumberFromInventoryLight15Stmt

public ResultSet executeSelectSeqNumberFromInventoryLight15Stmt(String templateId)
                                                         throws ServiceException
Throws:
ServiceException

executeSelectMINSeqNumberTimestampFromTimestampInfoStmt

public ResultSet executeSelectMINSeqNumberTimestampFromTimestampInfoStmt(String templateId)
                                                                  throws ServiceException
Throws:
ServiceException

executeSelectMAXSeqNumberTimestampFromTimestampInfoStmt

public ResultSet executeSelectMAXSeqNumberTimestampFromTimestampInfoStmt(String templateId)
                                                                  throws ServiceException
Throws:
ServiceException

executeSelectSyncpointFromEntityTemplateStmt

public ResultSet executeSelectSyncpointFromEntityTemplateStmt(String templateId,
                                                              String entityId)
                                                       throws ServiceException
Throws:
ServiceException

executeSelectCatenationFromEntityTemplateStmt

public ResultSet executeSelectCatenationFromEntityTemplateStmt(String templateId,
                                                               String entityId)
                                                        throws ServiceException
Throws:
ServiceException

executeSelectAllFromEntityInventoryStmt

public ResultSet executeSelectAllFromEntityInventoryStmt(String sequenceNumber)
                                                  throws ServiceException
Throws:
ServiceException

executeSelectTimestampFromTimestampInfoStmt

public ResultSet executeSelectTimestampFromTimestampInfoStmt(String templateId,
                                                             String sequenceNumber)
                                                      throws ServiceException
Throws:
ServiceException

executeSelectSeqNumberFromTimestampInfoStmt

public ResultSet executeSelectSeqNumberFromTimestampInfoStmt(String templateId,
                                                             String timestamp1,
                                                             String timestamp2)
                                                      throws ServiceException
Throws:
ServiceException

executeSelectSeqNumberTimestampFromTimestampInfo29Stmt

public ResultSet executeSelectSeqNumberTimestampFromTimestampInfo29Stmt(String templateId,
                                                                        String timestamp1,
                                                                        String timestamp2)
                                                                 throws ServiceException
Throws:
ServiceException

executeSelectSeqNumberTimestampFromTimestampInfo39Stmt

public ResultSet executeSelectSeqNumberTimestampFromTimestampInfo39Stmt(String templateId,
                                                                        String sequenceNumber,
                                                                        String timestamp)
                                                                 throws ServiceException
Throws:
ServiceException

executeSelectSeqNumberFromInventoryLight29Stmt

public ResultSet executeSelectSeqNumberFromInventoryLight29Stmt(String seqNumber1,
                                                                String seqNumber2,
                                                                String templateId)
                                                         throws ServiceException
Throws:
ServiceException

executeSelectSeqNumberFromEntityInventoryInventoryLightStmt

public ResultSet executeSelectSeqNumberFromEntityInventoryInventoryLightStmt(String seqNumber1,
                                                                             String seqNumber2,
                                                                             String entityId,
                                                                             String templateId)
                                                                      throws ServiceException
Throws:
ServiceException

executeTimestampInfoCompleteRowStmt

public ResultSet executeTimestampInfoCompleteRowStmt(String templateId)
                                              throws ServiceException
Throws:
ServiceException

executeTimestampInfoCompleteRowDESCStmt

public ResultSet executeTimestampInfoCompleteRowDESCStmt(String templateId)
                                                  throws ServiceException
Throws:
ServiceException

executeInventoryLightCompleteRowStmt

public ResultSet executeInventoryLightCompleteRowStmt(String templateId)
                                               throws ServiceException
Throws:
ServiceException

executeInventoryLightCompleteRowDESCStmt

public ResultSet executeInventoryLightCompleteRowDESCStmt(String templateId)
                                                   throws ServiceException
Throws:
ServiceException

main

public static void main(String[] args)


For comments and suggestions please send e-mail to The NaradaBrokering Project