FileDocCategorySizeDatePackage
StartTimeAccessObjectImplTest.javaAPI DocGlassfish v2 API5251Fri May 04 22:24:28 BST 2007com.sun.enterprise.admin.monitor.callflow

StartTimeAccessObjectImplTest

public class StartTimeAccessObjectImplTest extends TestCase
author
Harpreet Singh

Fields Summary
Connection
con
TableAccessObject
cs
PreparedStatement
pstmt
StartTimeTO[]
startTime
Constructors Summary
public StartTimeAccessObjectImplTest(String testName)

    
    
       
        super(testName);
    
Methods Summary
public static voidmain(java.lang.String[] argList)


        
    
protected voidsetUp()

      try{
            // TODO code application logic here
            String url="jdbc:derby://localhost:1527/sun-callflow;retrieveMessagesFromServerOnGetMessage=true;create=true;";            
            Class.forName("org.apache.derby.jdbc.ClientDriver").newInstance();
            con = DriverManager.getConnection(url, "APP", "APP");         
            // drop request start table
            cs = StartTimeAccessObjectImpl.getInstance();            
        } catch (Exception e){
            e.printStackTrace();
        }        
        
    
protected voidtearDown()

        try{
            con.close();
        } finally{
            con = null;
        }
    
public voidtestCreateTable()
Test of createTable method, of class com.sun.enterprise.admin.monitor.callflow.StartTimeAccessObjectImpl.

        System.out.println("Start Time : testCreateTable");
        boolean result = false;
        try{
            result = cs.createTable(con);
            System.out.println("Start Time Create Table returned = "+ result);
        }catch (Exception e){
            e.printStackTrace();
        }
        assertTrue(result);        
    
public voidtestDropTable()
Test of dropTable method, of class com.sun.enterprise.admin.monitor.callflow.StartTimeAccessObjectImpl.

        System.out.println("StartTime testDropTable");
        boolean result = cs.dropTable(con);
        System.out.println("Start Time Drop Table returned = "+result);
        assertTrue (result);              
    
public voidtestInsert()

        System.out.println(" testStorestartTime");
        try{
            String insertSQL = cs.getInsertSQL();
            System.out.println (" Insert SQL :"+ insertSQL);            
            pstmt = con.prepareStatement(insertSQL);            
            
            for (int i = 0; i < startTime.length; i++) {
                startTime[i] = new StartTimeTO();
                startTime[i].requestId = "RequestID_"+i;
                startTime[i].timeStamp = System.nanoTime();
                startTime[i].containerTypeOrApplicationType = "ORB";
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        boolean result = cs.insert (pstmt, startTime);
        System.out.println("testStorestartTime returned = "+result);
        assertTrue (result);