| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> |
| <HTML> |
| <HEAD> |
| <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252"> |
| <TITLE></TITLE> |
| <META NAME="GENERATOR" CONTENT="OpenOffice.org 2.0 (Win32)"> |
| <META NAME="CREATED" CONTENT="20070627;12001352"> |
| <META NAME="CHANGEDBY" CONTENT="John Graham"> |
| <META NAME="CHANGED" CONTENT="20070629;16043244"> |
| <STYLE> |
| <!-- |
| @page { size: 8.5in 11in } |
| --> |
| </STYLE> |
| </HEAD> |
| <BODY LANG="en-US" DIR="LTR"> |
| <P ALIGN=CENTER STYLE="margin-bottom: 0in"><FONT SIZE=6><B>DTP 1.5 |
| Release</B></FONT></P> |
| <P ALIGN=CENTER STYLE="margin-bottom: 0in"><FONT SIZE=6><B>News and |
| Noteworthy</B></FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT SIZE=4 STYLE="font-size: 16pt"><B>Connectivity</B></FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <UL> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>Added |
| API for supporting off-line connection mode at the framework level.</FONT></P> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>Added |
| migration hooks into profile loading code (including import).</FONT></P> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>Expanded |
| integration of connection profile repository support (still |
| experimental).</FONT></P> |
| </UL> |
| <P ALIGN=LEFT><BR><BR> |
| </P> |
| <P ALIGN=LEFT><FONT SIZE=3 STYLE="font-size: 13pt"><B>Connection |
| Profile Selection Components</B></FONT></P> |
| <P STYLE="margin-bottom: 0in">Many extenders of DTP need to select |
| connection profiles, potentially based on filter conditions. DTP now |
| has a set of components to make connection profile selection easier |
| to integrate with such tools. See Bugzilla 170130 for details.</P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT SIZE=4 STYLE="font-size: 16pt"><B>Open |
| Data Access (ODA)</B></FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT SIZE=3 STYLE="font-size: 13pt"><B>Integrate |
| connection profile framework with ODA runtime</B></FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>By |
| maintaining a dynamic reference to a connection profile in the ODA |
| runtime framework, an ODA consumer application can automatically pick |
| up any changes made to the profile's connection properties.</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT SIZE=3 STYLE="font-size: 13pt"><B>ODA |
| Web Services Data Source provider</B></FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>The |
| new ODA provider allows a client to specify a WSDL URL or file |
| location. In addition, a custom Java connection class can be |
| specified to allow refined control of how the SOAP request is made. |
| Once the data source is set up, a client can build a web services |
| data set responsible for sending the SOAP request and parsing the |
| SOAP response.</FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT SIZE=3 STYLE="font-size: 13pt"><B>ODA |
| API Enhancements</B></FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <UL> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>Adds |
| support of "boolean" data type in result set columns and |
| parameters </FONT> |
| </P> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>Provides |
| explicit setting of a null value to an input parameter </FONT> |
| </P> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>Exposes |
| the Name of a Parameter in its Runtime Meta Data</FONT></P> |
| </UL> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in">See <A HREF="http://wiki.eclipse.org/images/6/69/ODA31_API_Changes_SPEC.pdf" TARGET="_blank">ODA |
| API Change Specification</A> for details.</P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT SIZE=4 STYLE="font-size: 16pt"><B>Relational |
| Database Support</B></FONT></P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT SIZE=3 STYLE="font-size: 13pt"><B>Added |
| support for the following object types to the generic DDL generator:</B></FONT></P> |
| <UL> |
| <UL> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>Schemas</FONT></P> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>Routines</FONT></P> |
| <UL> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>Stored |
| procedures</FONT></P> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>User |
| defined functions</FONT></P> |
| </UL> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>User |
| defined types</FONT></P> |
| <UL> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>Distinct |
| types</FONT></P> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>Structured |
| types</FONT></P> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>Domain |
| types</FONT></P> |
| </UL> |
| <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: medium"><FONT SIZE=3>Assertions</FONT></P> |
| </UL> |
| </UL> |
| <P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P ALIGN=LEFT><FONT SIZE=3 STYLE="font-size: 13pt"><B>Sybase SQL |
| Anywhere v9 and v10 Enablement Support</B></FONT></P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in">DTP 1.5 contains the first drop of |
| Enablement support for the Sybase SQL Anywhere database, versions 9 |
| and 10. Following the intention of the Enablement project in DTP, |
| these components deliver support for this database directly from DTP, |
| and provide a sophisticated example of how DTP can be extended for |
| relational databases.</P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in"><IMG SRC="nn_dtp1.5M6_html_m1f064000.gif" NAME="Sybase ASA objects" ALIGN=LEFT WIDTH=349 HEIGHT=239 BORDER=0><BR CLEAR=LEFT><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in">Note the additional folders under the |
| database node. The Sybase SQL Anywhere Enablement components |
| demonstrate specialized catalog loading of such database objects.</P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in"><FONT SIZE=4 STYLE="font-size: 16pt"><B>SQL |
| Development Tools</B></FONT></P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <H2 STYLE="margin-top: 0in; margin-bottom: 0in"><A NAME="_Toc170279530"></A> |
| <FONT SIZE=4>New Features/Enhancements</FONT></H2> |
| <P><BR><BR> |
| </P> |
| <P><FONT SIZE=3 STYLE="font-size: 13pt"><B>Table Creation Wizard</B></FONT></P> |
| <P>In DTP 1.5, NEC Soft (Japan) joined the DTP team and contributed a |
| (relational) table creation wizard. This generates the DDL necessary |
| to create a given database table, and supports Apache Derby data |
| types and primary keys. The DDL generated can be executed directly in |
| the DTP SQL editor to create the table and saved for later reference.</P> |
| <P><FONT SIZE=3 STYLE="font-size: 13pt"><B>Easier Connection |
| Selection in SQL Editor</B></FONT></P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P STYLE="margin-bottom: 0in">The SQL editor has controls at the top |
| of the edit area for selection the target connection profile:</P> |
| <P STYLE="margin-bottom: 0in"><BR> |
| </P> |
| <P><IMG SRC="nn_dtp1.5M6_html_m19d03322.gif" NAME="cp selection" ALIGN=LEFT WIDTH=665 HEIGHT=127 BORDER=0><BR CLEAR=LEFT><BR><BR> |
| </P> |
| <H3><A NAME="_Toc170279531"></A><FONT SIZE=3 STYLE="font-size: 13pt">SQL |
| Scrapbook</FONT></H3> |
| <P>SQL Scrapbook Editor is added for quick <I>ad hoc</I> SQL |
| statement execution. The SQL Scrapbook can be invoked from the |
| workbench toolbar (<IMG SRC="scrapbook_button.gif" NAME="scrapbook button" ALIGN=BOTTOM WIDTH=16 HEIGHT=16 BORDER=0>). |
| It has the same functionality as the SQL (file) Editor (content |
| assist, templates, etc.), and the ability to save the SQL contents to |
| a file. User can execute the SQL against a chosen connection profile |
| and see the results in the results view.</P> |
| <P><IMG SRC="sqlscrapbook.gif" NAME="SQL Scrapbook" ALIGN=BOTTOM WIDTH=575 HEIGHT=248 BORDER=0></P> |
| <H3><A NAME="_Toc170279532"></A><FONT SIZE=3 STYLE="font-size: 13pt">SQL |
| Editor is Multi-page Editor-Aware</FONT></H3> |
| <P>DTP provides a standalone SQL Editor. With the introduction of |
| this multi-page editor aware/ready framework change, the DTP |
| community developers/vendors will be able to utilize it to implement |
| their multiform editors.</P> |
| <H3><A NAME="_Toc170279533"></A><FONT SIZE=3 STYLE="font-size: 13pt">Data |
| Source Explorer Integration</FONT></H3> |
| <P>The following usability enhancements are added:</P> |
| <UL TYPE=DISC> |
| <LI><P>Supports <B>double click</B> to open routine editor; |
| </P> |
| <LI><P><B>Links </B>routine editor with the Data Source Explorer. (<IMG SRC="synch_button.gif" NAME="link button" ALIGN=BOTTOM WIDTH=25 HEIGHT=24 BORDER=0> |
| Link with editor)</P> |
| </UL> |
| <H3><A NAME="_Toc170279534"></A><FONT SIZE=3 STYLE="font-size: 13pt">Non-UI-blocking |
| Routine/SQL statements execution</FONT></H3> |
| <P>Use a non-UI thread to run a procedural object in order not to |
| block UI.</P> |
| <P>The SQL statement execution is carried out in a new Job now so |
| that it will no longer block the UI any more.</P> |
| <H3><A NAME="_Toc170279535"></A><FONT SIZE=3 STYLE="font-size: 13pt">Connection |
| Info attachment enhancements</FONT></H3> |
| <P>A global preference is added for user to specify the default |
| connection info.</P> |
| <P>Connection info composite is added on top of the SQL |
| Scrapbook/File Editor for user to quickly switching connection info.</P> |
| <P>User can select a connection profile first before specifying the |
| server type, which will be automatically detected by the software.</P> |
| <H3><A NAME="_Toc170279536"></A><FONT SIZE=3 STYLE="font-size: 13pt">Connection |
| related enhancements</FONT></H3> |
| <P>SQL Tools will no longer ping the server for version info, instead |
| it will get version from driver template if it's not already cached |
| in connection profile properties. |
| </P> |
| <P>Connection in the launch configuration dialog is made only when |
| the user attempts to run the procedural object.</P> |
| <H2><A NAME="_Toc170279537"></A><FONT SIZE=4>New API</FONT></H2> |
| <H3><A NAME="_Toc170279538"></A><FONT SIZE=3 STYLE="font-size: 13pt">Supports |
| Trigger created in a different schema than the table it references</FONT></H3> |
| <H3><A NAME="_Toc170279539"></A><FONT SIZE=3 STYLE="font-size: 13pt">ResultSetOutputter |
| extension point is introduced to export the SQL result in a |
| customized format</FONT></H3> |
| <H3><A NAME="_Toc170279540"></A><FONT SIZE=3 STYLE="font-size: 13pt">Add |
| API for data type provider and validator into SQLDataService</FONT></H3> |
| <P>Consumers will have a unified API (instead of various utility |
| classes) to handle data types (both predefined and UDT) and the |
| default implementation can be customized freely by extenders.</P> |
| <H2><A NAME="_Toc170279541"></A><FONT SIZE=4>Major Bug Fixes</FONT></H2> |
| <H3><A NAME="_Toc170279542"></A><FONT SIZE=3 STYLE="font-size: 13pt">Launch |
| related bugs</FONT></H3> |
| <P>Prompt user to save procedural objects before launch;</P> |
| <P>Prompt user to switch perspective when a procedural object |
| breakpoint is hit;</P> |
| <P>Correctly initialize the database debug perspective layout.</P> |
| <H3><A NAME="_Toc170279543"></A><FONT SIZE=3 STYLE="font-size: 13pt">Connection |
| profile listener related bugs</FONT></H3> |
| <P>When deleting/renaming a connection profile error will occur.</P> |
| </BODY> |
| </HTML> |
