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

Bug 204344

Summary: Initial Integration with the SQL Query Builder and SQL Query Model for use by ODA consumer applications
Product: z_Archived Reporter: Linda Chan <lchan>
Component: BIRTAssignee: Linda Chan <lchan>
Status: RESOLVED FIXED QA Contact:
Severity: enhancement    
Priority: P3 CC: bpayton, kvenkatraman, lzhu, wenfeng.fwd
Version: 2.3.0Keywords: plan
Target Milestone: 2.3.0 M6   
Hardware: PC   
OS: Windows 2000   
Whiteboard:
Bug Depends on:    
Bug Blocks: 201783    

Description Linda Chan CLA 2007-09-21 21:43:55 EDT 
The SQL Query Builder (http://wiki.eclipse.org/DTP_SQL_Query_Builder_Ganymede_Project_Plan) planned in Ganymede is a powerful tool that allows users the freedom to create queries to access a relational data source without detail knowledge of the SQL syntax. The same tool also provides the option to edit a SQL query text directly. Any editing made in either the textual or graphical pane would be automatically reflected in the other. 
This integration project plans to provide ODA adapters to the the SQL Query Builder and SQL Query Model. With the adapters, an ODA-compliant consumer application can consume the builder, as well as other custom ODA providers, through the same ODA API.
Comment 1 Linda Chan CLA 2008-03-01 00:43:02 EST 
Due to the dependency on the existing BIRT oda.jdbc driver, this integration project will need to be in the BIRT namespace.
Changing the product component of bug to BIRT Data Access.
Comment 2 Linda Chan CLA 2008-03-01 00:44:55 EST 
Committed initial contribution of a new BIRT ODA driver that integrates the DTP ODA support of Database connection profile with the DTP SQL Query Builder.  It is capable of preserving the last window state of the SQB dialog page in a BIRT Data Set Design.

Their project namespaces are:
* org.eclipse.birt.report.data.oda.jdbc.dbprofile
* org.eclipse.birt.report.data.oda.jdbc.dbprofile.ui
Comment 3 Linda Chan CLA 2008-03-06 20:56:26 EST 
Added missing profile wizard definition in plugin extension; updated labels to indicate prototype status
Comment 4 Linda Chan CLA 2008-03-12 23:49:15 EDT 
Improved BIRT Data Set Editor performance when switching between its page nodes by using a new ODA DataSetDesignSession API method (bug 222514) to collect interim design state.
Also re-factored the connection error handling in birt oda.jdbc.dbprofile.ui implementation.
Comment 5 Linda Chan CLA 2008-03-14 19:45:57 EDT 
To ensure that the ODA SQL Query Builder dialog page benefits from bug fixes made to the DTP core sqlbuilder component, re-factored the custom SQB Dialog to extend from the DTP sqlbuilder plugin's SQB dialog.  
Also fixed the BIRT Data Set Editor update data set handle logic so that updates do occur even when only the oda designer state (but not the data set design) got changed in an ODA design session response.
Comment 6 Linda Chan CLA 2008-03-27 23:54:32 EDT 
Created new feature project "org.eclipse.birt.report.data.oda.jdbc.dbprofile.sqlbuilder.feature" to specify its plugin and feature dependencies from DTP.
Comment 7 Linda Chan CLA 2008-03-28 19:49:20 EDT 
*** Bug 159501 has been marked as a duplicate of this bug. ***
Comment 8 Lin Zhu CLA 2008-04-07 03:08:58 EDT 
As we are in critical stage of delivery BIRT M6, set this bug to p5.
Comment 9 Linda Chan CLA 2008-04-07 14:33:41 EDT 
Completed delivery of scope intended for M6.

There are known limitations in the M6 version.  They are:
* Handling of '?' parameter markers in a SQL query text. Any metadata defined in BIRT Data Set Editor's Parameters page, such as a default value, are not preserved.  Named parameters are not yet supported in the integrated version.

* Server deployment of an ODA data source design that references a database profile requires the use of the same JDBC driver jar path (Bugzilla 225866)

* Side effect of appending results in the SQL Results View when using "Run SQL" in the SQB dialog page (Bugzilla 220685)

* Limited availability of DBMS-specific profile property pages to support Read-Only Mode (Bugzilla 213266)

* Generic Catalog Filtering not yet available for all out-of-box Database Profile Types (Bugzilla 221607)

* SQB has dependency on Eclipse IDE plugin; not able to include in BIRT RCP Report Designer (Bugzilla 225009)
Comment 10 Linda Chan CLA 2008-04-24 05:08:01 EDT 
Enhanced handling of parameter markers and named variables in M7 (bug 228611).
Comment 11 Linda Chan CLA 2008-06-05 19:44:28 EDT 
Added in RC1 a new DTP console editor application for users to view and update connection profiles exported to a file (bug 225866).  
System administrators can use this simple command-line tool to change a profile's connection properties for server deployment, such as the JDBC driver jar path specified in a database connection profile.