Teiid Designer 7.2 Release Notes

Development work for 7.2 release was done initially on the 7.1 SVN branch and worked under 7.1.1 JIRAs. These changes/fixes were merged into TRUNK, upgraded to Teiid 7.2 Final  binaries for this release.

 

Release Notes - Teiid Designer - Version 7.2    

Bug

  • [TEIIDDES-25] -         Undo/Redo Keyboard Accelerators In Transformation Editor Undo/Redo Both Transformation Edits And Model Object Edits In Model Editor
  • [TEIIDDES-30] -         Saving the "Model" does not save un-saved transformation
  • [TEIIDDES-72] -         Fix JDBC Importer to import CLOB as CLOB rather than string
  • [TEIIDDES-313] -         Recursion limit "spinner" does not work
  • [TEIIDDES-326] -         Excessive error reporting when virtual model's sources are removed (UUIDs, for example)
  • [TEIIDDES-476] -         JDBC Importer no longer provides ability to edit connection information
  • [TEIIDDES-482] -         Synchronizing models in a VDB does not work quite as expected
  • [TEIIDDES-488] -         DB2 Import - Source with DECIMAL datatype is being imported as LONG
  • [TEIIDDES-507] -         Teiid 7.0 Designer does not display XML results - Instead get "org.teiid.core.types.SQLXMLImpl@8f2d5e"
  • [TEIIDDES-520] -         Designer permits VDB to have no visible models - at least one should be visible
  • [TEIIDDES-522] -         Recursive XML doc model does not create mapping class structure for lower levels
  • [TEIIDDES-537] -         SQLResultsView is not displaying CLOBs
  • [TEIIDDES-540] -         Refactoring/Move view model dependant upon other view models gets errors since other view models didn't move
  • [TEIIDDES-541] -         Table data preview requires all models in project to be without validation errors - should pertain only to models required for preview
  • [TEIIDDES-550] -         Import DDL to Relational Table misses columns for primary, foreign keys
  • [TEIIDDES-555] -         Could not start Designer with Parts Examples project and perform Preview Data
  • [TEIIDDES-565] -         XML Document objects are not showing up in DTP VDB's.
  • [TEIIDDES-569] -         SQLXML type is imported as object
  • [TEIIDDES-573] -         Datatypes Editor get Unhandled event loop exception when creating subtype
  • [TEIIDDES-577] -         Models which are NOT visible should not be shown in the data roles editor
  • [TEIIDDES-578] -         Changing the contents of a VDB does not refactor/clean-up or sync with existing Data Roles in that VDB
  • [TEIIDDES-581] -         NPE importing DDL into Relational Model with "Set description of model entities to corresponding DDL statement" option checked
  • [TEIIDDES-584] -         Teiid View Should Persist View Option Settings From Session To Session
  • [TEIIDDES-586] -         Please rename "XSD Schemas" on Teiid Deisgner importers list.
  • [TEIIDDES-588] -         The "Create Data Source" dialog only displays JDBC profiles.
  • [TEIIDDES-589] -         Incorrect alias resolving upon validation with self-joined queries in Transformation Editor
  • [TEIIDDES-592] -         Issues with generated War and JBossWS-CXF 3.1.2SP6
  • [TEIIDDES-594] -         Choice criteria not being validated UUID not defined by relevant group
  • [TEIIDDES-596] -         Preview's Missing Password Required dialog ignores last character entered
  • [TEIIDDES-600] -         The 'M' on Teiid Designer Model projects is overloaded in Eclipse
  • [TEIIDDES-601] -         LDAP profile properties dialog allows 'testing' of the connection.
  • [TEIIDDES-604] -         Preview Data results do not update for changes in virtual table SQL
  • [TEIIDDES-605] -         Preview VDB doesn't contain custom function model used in transformation
  • [TEIIDDES-606] -         Criteria and Expression builder actions on Transformation Editor not enabling or not launching with editable values
  • [TEIIDDES-608] -         Able to begin to create a subtype using Read Only XSD, but get error about read-only cannot be modified
  • [TEIIDDES-609] -         Teiid QueryValidatorException opening VDB schema in Data Source Explorer for model with "hidden" table.
  • [TEIIDDES-610] -         Successfully creating a WAR file should not result in a logged WARNING
  • [TEIIDDES-611] -         NPE when executing Designer with Simple Datatypes Editor open
  • [TEIIDDES-612] -         Creating subtype from Boolean built-in type fails (Unhandled event loop exception)
  • [TEIIDDES-613] -         Default War File Generation Location Incorrect
  • [TEIIDDES-615] -         Books and Parts sample projects do not include DDL scripts nor readme telling user how to set up data sources.
  • [TEIIDDES-616] -         War Generation Needs to Consider Recursive Schema Imports
  • [TEIIDDES-617] -         UUID version of SQL in designer should be removed.
  • [TEIIDDES-618] -         War Generation Shows Success Message Even When there was an Error Generating the War
  • [TEIIDDES-619] -         Roles Editor needs to handle XML Doc, and Web service models in  addition to Relational
  • [TEIIDDES-621] -         Exiting Designer when preview server NOT running results in connection exception
  • [TEIIDDES-622] -         Refactor > Move Virtual model with diagram references to source tables in other folders results in errors
  • [TEIIDDES-623] -         Removing UUID version os SQL requires fixes to Refactor Model actions/commands.
  • [TEIIDDES-624] -         Dynamic SQL transformation validation getting: The number of transformation output symbols is zero.
  • [TEIIDDES-625] -         Web Service Operations Editor erases procedure SQL when validating, then claims transformation is empty
  • [TEIIDDES-626] -         Create Web service (from relational table) generates "*tablename" procedure - visually confusing, hard to edit/modify
  • [TEIIDDES-628] -         Hide problem markers for Preview VDB's
  • [TEIIDDES-629] -         When creating a UDF, the Invocation class and method should be optional
  • [TEIIDDES-630] -         Callback Class Fails Dynamic Compile During WS-Security War Generation
  • [TEIIDDES-634] -         Cannot Preview Data for model in a Model Project with "space" in project name (i.e. "Parts Project")
  • [TEIIDDES-635] -         NPE Deleting Model Project with Diagrams for models within that project open
  • [TEIIDDES-636] -         Missing Message for Key "WarDeploymentInfoDialog.securityPasswordTooltip" in security password field of War Generator
  • [TEIIDDES-638] -         Rose importer unable to instantiate class "com.metamatrix.rose.internal.ui.wizard.RoseImportWizard"
  • [TEIIDDES-641] -         NPE opening the JDBC Source node in model explorer for model without connection properties
  • [TEIIDDES-643] -         Create data source from Teiid view gets [AdminComponentException]The specified session ID "null" is invalid.
  • [TEIIDDES-644] -         Books example has incorrect transformation SQL in XML document model
  • [TEIIDDES-645] -         Unable to synchronize models in VDB
  • [TEIIDDES-647] -         Preview Data of Web Service Procedure without a Parameter Causes NPE
  • [TEIIDDES-648] -         NPE canceling "Edit" connection profile action in JDBC Import wizard
  • [TEIIDDES-649] -         builtInDatatypes.xsd not Resolvable in Designer Running in JBDS During War Generation
  • [TEIIDDES-650] -         Open VDB Editors Do Not Close When Their Project Is Closed
  • [TEIIDDES-651] -         WARN  [org.teiid.SECURITY] (New I/O server worker #2-1) Processing exception logged repeatedly
  • [TEIIDDES-653] -         Renaming a folder in Model Project in Model Explorer results in ClassCastException
  • [TEIIDDES-654] -         NPE while deleting dynamic web project
  • [TEIIDDES-655] -         Closing Project with VDB Editor open results in SWT exceptions
  • [TEIIDDES-656] -         Teiid Designer perspective is not opened or selected after New Model is created from non-Designer perpective.
  • [TEIIDDES-657] -         Transformation validation incorretly requires an updatable model element in an INSERT transformation.
  • [TEIIDDES-660] -         Preview WSDL action enabled for non-web-service tables
  • [TEIIDDES-661] -         Update list of DDL dialects on Export DDL dialog to reflect current DB versions
  • [TEIIDDES-664] -         Creating XML doc model from XSD gets ugly error (big red X) instead of reasonable message
  • [TEIIDDES-665] -         Find Model Object does nothing on first attempt, then gets Unhandled event loop exception
  • [TEIIDDES-666] -         Designer importer fails to correctly import metadata from Sybase when using the JConnect driver
  • [TEIIDDES-668] -         Recursion limit spinner control,once set, won't go up
  • [TEIIDDES-669] -         War Generation Compilation Process Causes NPE if Designer is Run with a JDK less than JDK 6
  • [TEIIDDES-670] -         Pasting DELETE transformation SQL always (AFAICT) requires two attempts
  • [TEIIDDES-671] -         Menu item Metadata > Reresolve References sometime enabled, when clicked always says it's disabled
  • [TEIIDDES-672] -         Restore preferences defaults not 100% - transformation editor layout & miscellaneous, for example
  • [TEIIDDES-673] -         Exported/Imported Teiid preferences does not capture all prefs
  • [TEIIDDES-674] -         Execute VDB failed on NPE due to unregistered Connection Profile listener
  • [TEIIDDES-675] -         Able to make Read-Only model transformation support updates
  • [TEIIDDES-677] -         Importing int type (JDBC type code 4) should be a runtime integer, not biginteger
  • [TEIIDDES-678] -         Issues after Refactoring Source Model Name
  • [TEIIDDES-679] -         Operation Editor won't save Input Variables
  • [TEIIDDES-680] -         Warning message text is wrong
  • [TEIIDDES-682] -         Deploy context menu option enabled but not working if no Teiid instance created
  • [TEIIDDES-684] -         Unable to import projects created by MetaMatrix 5.5.x
  • [TEIIDDES-686] -         Error Message for Failed VDB Deployment Refers to Previously Deployed VDB
  • [TEIIDDES-687] -         Cannot Create new subtype element from a built-in datatype
  • [TEIIDDES-688] -         Closing project and saving dirty editor results in ResourceException
  • [TEIIDDES-690] -         Refactor > Move source model produces preview errors
  • [TEIIDDES-691] -         JBDS 4.0 beta1 - connecting successfully to a Teiid instance shows a red icon - until it is reconnected
  • [TEIIDDES-692] -         Undo Clear Transformation gets Index Out of Bound exception
  • [TEIIDDES-693] -         Adding a Union to a transformation gets unhandled event loop exception (NPE)
  • [TEIIDDES-695] -         Cannot paste into Table Editor cell via CTRL-V - get error msg and NPE
  • [TEIIDDES-697] -         Remove workspace ("default")  from the ModeShape connection profile - PATH
  • [TEIIDDES-698] -         MarshalException when saving VDB with both "other" files and data roles
  • [TEIIDDES-699] -         No way to create an index for a relational table (either view or source)
  • [TEIIDDES-700] -         An index on a view table can be created, but opening its transformation diagram gets an exception
  • [TEIIDDES-702] -         Teiid CP's created by "Execute VDB" action should use HTTPS by default.
  • [TEIIDDES-703] -         Teiid CP's created by "Execute VDB" actions should prompt for credentials rather than use the Admin credentials.
  • [TEIIDDES-705] -         WSDL to Relational Model Importer is not resolving element refs
  • [TEIIDDES-706] -         WSDL to Relational Importer is not recognizing all instances of recusion in XSD.
  • [TEIIDDES-709] -         Problems with Operations Editor Input Variables Section behavior
  • [TEIIDDES-712] -         Text metadata - transformation SQL editor fails to parse text with reserved word enclosed in quotation marks - no escape mechanism
  • [TEIIDDES-713] -         Virtual Model Import and Export to text does not work, and inconsistent
  • [TEIIDDES-720] -         Re-connecting to existing Teiid server after server shutdown & restart causing multiple problems
  • [TEIIDDES-721] -         Several supported databases  missing in Teiid designer export menu
  • [TEIIDDES-725] -         Parsing error: invalid attribute in teiid connection profile
  • [TEIIDDES-728] -         Execute VDB Action uses incorrect connection URL.
  • [TEIIDDES-729] -         Teiid designer generates SQL*Plus specific statements
  • [TEIIDDES-730] -         Refactor > Rename XML Schema works, but gets NPE
  • [TEIIDDES-731] -         Support for Sybase missing in Teiid designer export dialog
  • [TEIIDDES-732] -         PostgreSQL imported model resolved to "jdbc-simple" translator
  • [TEIIDDES-733] -         SalesForce importer throws NPE if there are not profiles defined.
  • [TEIIDDES-735] -         Designer is not preserving newlines (and possibly other characters) in literals
  • [TEIIDDES-736] -         NPE on attempt to open context menu under XSD Model Complex type element
  • [TEIIDDES-737] -         The category that the Designer features are contined in when installing from p2 is "Metadata Modeling", should be Teiid Designer
  • [TEIIDDES-738] -         The Datatools Connectivity feature version is 0.1.0, should be 7.1.1 or 7.2
  • [TEIIDDES-739] -         Deleting a physical table from a view model deletes the table from the entire project.
  • [TEIIDDES-740] -         Adding physical tables to a transformation with "Modeling->Add to From Clause" only works once.
  • [TEIIDDES-741] -         Execute VDB Action does not always set the correct VDB name in the VDB name property.
  • [TEIIDDES-743] -         VDB manifest file is created with wrong information
  • [TEIIDDES-744] -         PostgreSQL translator not being correctly mapped during JDBC import
  • [TEIIDDES-745] -         Dialog selection is not initialized correctly.
  • [TEIIDDES-747] -         Synchronized/Visible column too big and can't be resized.
  • [TEIIDDES-748] -         Create Data Source checkboxes in JBDS Teiid Designer dialog should be radio buttons
  • [TEIIDDES-749] -         Creation of a new Teiid instance in the JBDS Teiid Designer should prompt the user to make that the default
  • [TEIIDDES-752] -         Generating WAR file causes java.lang.NullPointerException
  • [TEIIDDES-761] -         New button on SalesForce Importer brings up New Connection Profile dialog with no profile types to choose from
  • [TEIIDDES-763] -         When project has an unrelated error, cannot preview source model (which has no errors)
  • [TEIIDDES-764] -         VDB Editor Usability - when sync'ing it should also perform save
  • [TEIIDDES-765] -         SalesForce importer is not displaying existing profiles in the combo.
  • [TEIIDDES-766] -         Property names disappear upon selection in Teiid Designer's New Driver Definition dialog accessed via the Import JDBC Metadata wizard
  • [TEIIDDES-769] -         Releated to SOA-2719 - error dialog includes a typo
  • [TEIIDDES-771] -         DB2, Sybase & SQL Server Import Model Processor contributions have wrong driver class names in plugin.xml
  • [TEIIDDES-772] -         When closing a project with a VDB open in its editor, you may get Unhandled Event Loop Exception
  • [TEIIDDES-773] -         Preview will fail quietly if the JDBC connection is not sucessfully created.
  • [TEIIDDES-777] -         Data Roles: Columns may optionally not be created, but deletes only happen at the row level, so columns should be disabled for DELETEs
  • [TEIIDDES-778] -         Upgrading Eclipse target platform (org.eclipse.ui.ide) to 3.6.2 results in compile error in XsdFileSystemImportMainPage
  • [TEIIDDES-780] -         CLONE - There's no way to create a Teiid WS connection from JBDS/Teiid Designer without a WSDL.
  • [TEIIDDES-781] -         CLONE - Teiid Designer should create models for the WS translator invoke and invokeHttp procedures and the File translator getFiles procedure.
  • [TEIIDDES-793] -         Update LEGAL.txt and feature related files for 2011 copyright info
  • [TEIIDDES-796] -         WSDL to Relational Importer takes minutes to validate WSDL.
  • [TEIIDDES-797] -         WSDL to Relational Importer is displaying each Web Service connection profile twice in the combo.
  • [TEIIDDES-798] -         Missing tooltips on toolbar buttons in Teiid tools
  • [TEIIDDES-799] -         Change Default Filter for Model Explorer to Show All Files

 

Feature Request

  • [TEIIDDES-368] -         Designer: Refine the 'pre-View' action's enablement logic
  • [TEIIDDES-523] -         Add WS-Security (UsernameToken) Support to Generated JBossWS-CXF War
  • [TEIIDDES-525] -         In Import wizards, add ability to launch Connection Profile property editor (so I can easily fix bad connection props).
  • [TEIIDDES-533] -         Implement DS creation for LDAP.
  • [TEIIDDES-607] -         Need a "Set Translator Name" action to allow using custom translators with Preview Data action.
  • [TEIIDDES-667] -         Create DDL Export XSL for Postgres Dialect
  • [TEIIDDES-751] -         Warn user when deploying an unsaved VDB - avoid scary errors
  • [TEIIDDES-779] -         CLONE - There's no way to create a Teiid File connection from JBDS/Teiid Designer

 

Patch

  • [TEIIDDES-599] -         org.teiid.designer.datatools unnecessary dependencies

 

Quality Risk

  • [TEIIDDES-567] -         Refactor display node logic

 

Task

  • [TEIIDDES-460] -         Add HTTPBasic Support to Generated JBossWS-CXF War
  • [TEIIDDES-503] -         Update Designer embedded help to reflect 7.0, 7.1 and 7.1.1 changes
  • [TEIIDDES-508] -         Change default value of visibility for source (physical) models to FALSE (not visible)
  • [TEIIDDES-510] -         Remove old Designer Preferences Import & Export buttons and underlying functions
  • [TEIIDDES-511] -         Designer "Help About" lists Teiid's provider as "Red Hat, Inc." - Should be "JBoss by Red Hat" like the others
  • [TEIIDDES-562] -         Change Generate WSDL Option to Preview WSDL
  • [TEIIDDES-590] -         Add the notion of "All Users" check box to Data Role Editor which sets "any-authentication" attribute to TRUE and disables "Mapped Role Names" panel.
  • [TEIIDDES-593] -         Release 7.1.1 Code-maintenance and cleanup. I18n, etc....
  • [TEIIDDES-639] -         Allow defining the data-role for the "SYSADMIN" module.
  • [TEIIDDES-716] -         Remove importing of index information by default
  • [TEIIDDES-723] -         Create a relational processor for ModeShape to support jdbc importing according to its rules
  • [TEIIDDES-734] -         Create a WS-Relational Example
  • [TEIIDDES-791] -         Create a Web Service Model Example

 

Sub-task

  • [TEIIDDES-403] -         Eliminate use of restricted Eclipse classes
  • [TEIIDDES-756] -         When setting up a Teiid instance connection, the user must provide 2 sets of connection properties; 1)  Admin connection props  and 2)  jdbc username and password
  • [TEIIDDES-757] -         Designer should pull both, the Admin or JDBC connection info, from the default Teiid server instance
  •  

 

JBoss Tools Integration

  • [JBIDE-6399] -         when removing a plugin, must also remove refs to it in feature.xml and pom.xml that contain it
  • [JBIDE-6984] -         ModeShape and Teiid Designer plugins referenced libraries need to be updated to the ModeShape SOA-P ER5 JARs
  • [JBIDE-7493] -         Teiid preview connections can be broken by eclipse update.
  • [JBIDE-7914] -         org.drools.eclipse.core.DefaultRuleGroup cannot be cast to org.eclipse.emf.ecore.EObject