List<ItiCallLogs> logsList = null;
    try {
    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    Connection connection=DriverManager.getConnection("jdbc:sqlserver://localhost\SQL2008:1433;databaseName=Keyhiedb_QA1;user=prachi;password=Prachi@123");
    preparedStatement = connection.prepareStatement(GET_ITICALL_LOG_DETAILS);
    preparedStatement.setString(1, transactionId);
    ResultSet rs = preparedStatement.executeQuery();
    logsList = new ArrayList<ItiCallLogs>();
    ItiCallLogs itiCallLogs = null;
    while(rs.next())
    {
        itiCallLogs = new ItiCallLogs();
        itiCallLogs.setLogSeqId(rs.getLong(1));
        itiCallLogs.setSuccess(rs.getBoolean(2));
        itiCallLogs.setRecordId(rs.getLong(3));
        itiCallLogs.setHomeCommunityId(rs.getString(6));
        itiCallLogs.setPatientLocalId(rs.getString(7));
        itiCallLogs.setTransactionId(rs.getString(8));
        itiCallLogs.setPatientEUID(rs.getString(9));
        itiCallLogs.setEndPointURL(rs.getString(10));
        itiCallLogs.setDescription(rs.getString(11));
        itiCallLogs.setArchive(rs.getBoolean(12));
        logsList.add(itiCallLogs);
    }
    } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }
    catch(ClassNotFoundException e)
    {
        e.printStackTrace();
    }

    return logsList;
}