Get a range of tests from Quality Center in SQL Server

SQL Server doesn't have a LIMIT function like MySQL, but a little digging with Google turned up a query that looks something like this: SELECT test.* FROM ( SELECT test.*, ROW_NUMBER() OVER (ORDER BY TS_TEST_ID) AS row FROM test ) test WHERE test.row BETWEEN 10 and 15 based on this post on Stack Overflow: http://stackoverflow.com/questions/5151013/limit-style-functionality-in-ms-sql-server-2005

Integrating with QC — is it really worth it?

I've finally started writing about the work I did last year integrating HP Quality Center with JUnit (and with Bugzilla) and there seems to be some genuine interest in that, but as Elisabeth Hendrickson pointed out in tweet: @fijiaaron I'm curious if, after your experience w/Junit+QC, you see this as generally beneficial, or just a … Continue reading Integrating with QC — is it really worth it?

Lately…moving, looking for work, flying etc.

It's been a long time since I wrote anything other than a tech related post here. I'm going to try to change that. Just think, this used to be a travelogue. That's where the name 'fijiaaron' came from. Lately I've been busy moving. We moved from south Renton (soon to become Kent) back to Bellevue. … Continue reading Lately…moving, looking for work, flying etc.

Integrating JUnit with HP Quality Center – part 2

Integrating JUnit tests with HP/Mercury Quality Center Part 2: reporting annotation converage using a base class In my previous post I talked about adding an annotation to JUnit test cases that identified corresponding manual test cases defined in Quality Center. In this post, I'll describe how I used those annotations to create a coverage report … Continue reading Integrating JUnit with HP Quality Center – part 2

Integrating JUnit tests with HP/Mercury Quality Center

Integrating JUnit tests with HP/Mercury Quality Center Part 1: initial analysis and annotation A while back I did some work for a client who had two sets of test cases. On the one hand, they had hundreds of manual test cases documented in Quality Center. On the other hand, they had hundreds of automated test … Continue reading Integrating JUnit tests with HP/Mercury Quality Center