Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 370794 - Add database support for Microsoft SQL Server 2008
Summary: Add database support for Microsoft SQL Server 2008
Status: CLOSED WONTFIX
Alias: None
Product: Jubula
Classification: Technology
Component: Core (show other bugs)
Version: 1.2.0   Edit
Hardware: All All
: P3 enhancement (vote)
Target Milestone: ---   Edit
Assignee: Markus Tiede CLA
QA Contact: Oliver Goetz CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-02-07 04:14 EST by Markus Tiede CLA
Modified: 2012-02-23 02:50 EST (History)
1 user (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Markus Tiede CLA 2012-02-07 04:14:45 EST 
There is currently no support to store Jubula projects in a "Microsoft SQL Server 2008" database instance.
Comment 1 Markus Tiede CLA 2012-02-07 05:53:45 EST 
We recently evaluated adding support for "Microsoft SQL Server 2008" databases and decided not to do so due to the following reasons:
 - The default database transaction isolation level for "Microsoft SQL Server 2008" is "READ COMMITTED". This leads to blocked reads during database write operations e.g. when importing Jubula projects into the database or saving test cases - which causes the client to "hang" permanently during these operations. This issue might be resolved by adjusting the database isolation level but it would require manual adjustment of the database setup and / or default behavior.

 - "Microsoft SQL Server 2008" uses a different behavior for evaluating uniqueness of <code>null</code> values (http://connect.microsoft.com/SQLServer/feedback/details/299229/) than is specified in the standard, which causes some of our unique constraints to fail despite being correct.
Comment 2 Alexandra Schladebeck CLA 2012-02-23 02:50:29 EST 
based on the results of the evaluation, I am closing this ticket.