Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 318531 - Add option to invoke the Query Builder for Classic Models Sample database
Summary: Add option to invoke the Query Builder for Classic Models Sample database
Status: VERIFIED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: BIRT (show other bugs)
Version: 2.6.0   Edit
Hardware: PC Windows XP
: P3 enhancement (vote)
Target Milestone: 2.6.1   Edit
Assignee: Linda Chan CLA
QA Contact: Tianli Zhang CLA
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-06-30 20:13 EDT by Abhisek Sinha CLA
Modified: 2010-07-12 05:40 EDT (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 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