Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 318531

Summary: Add option to invoke the Query Builder for Classic Models Sample database
Product: z_Archived Reporter: Abhisek Sinha <asinha>
Component: BIRTAssignee: Linda Chan <lchan>
Status: VERIFIED FIXED QA Contact: Tianli Zhang <tzhang>
Severity: enhancement    
Priority: P3 CC: bluesoldier
Version: 2.6.0   
Target Milestone: 2.6.1   
Hardware: PC   
OS: Windows XP   
Whiteboard:

Description Abhisek Sinha CLA 2010-06-30 20:13:14 EDT 
Build Identifier: I20100608-0911

We should add an option in the Data Source type list in the "Create New Data Source" wizard for the Query builder for the Classic Models sample database.

The Classic Models sample database is often used to evaluate/demo BIRT and it will be useful if we can enable users to have a look at the Query builder when they are evaluating BIRT.

Reproducible: Always
Comment 1 Linda Chan CLA 2010-06-30 22:46:02 EDT 
See bug #228979, plus What's New description with screen shots in 
http://www.eclipse.org/birt/phoenix/project/notable2.3.php#jump_15  .

*** This bug has been marked as a duplicate of bug 228979 ***
Comment 2 Linda Chan CLA 2010-07-08 19:33:31 EDT 
Using the auto-generated external connection profile of BIRT SampleDb (provided for bug 228979) is the preferred approach to define a data source design for use with SQB.  Its relevant connection property values would get automatically updated/migrated when appropriate.  

If one must create a local (transient) SampleDb data source profile instead for use with SQB, one can take the following steps:
In the New Data Source wizard, select "Create from a data source in the following list:", and select "JDBC Database Connection for Query Builder".  Press Next button. 
Select "Derby" in the list box; press Next button.   
In the Drivers combo box, select "BIRT SampleDb Derby Embedded Driver" in combo box, if not automatically selected.  
It will now automatically has the default database location URL specified to access the BIRT sampledb database.  Users are free to update it if necessary.

Note that the data source properties created this way are saved locally in a report design.  If the property values, such as the database location or the jarList path become obsolete (e.g. users installs another version of BIRT designer), users will need to manually update the appropriate property value(s).
Comment 3 Linda Chan CLA 2010-07-08 19:39:30 EDT 
The pre-defined BIRT sampledb Driver Definition for use with SQB now has the default database location URL set to access the BIRT sampledb database.  It is however user's responsibility to maintain such local connection property values, when the report design is run in another BIRT installation environment.
Comment 4 Tianli Zhang CLA 2010-07-12 05:40:29 EDT 
BIRT SampleDb Derby Embedded Driver is provided in JDBC Database Connection for Query Builder. Verified in 2.6.1.v20100712-0630