Allora Release Notes

Click here to view a list of supported JDBC drivers and driver problems.
 

Version	Date	Changes
6.0-1	10/13/09	Engine Added support for timestamp and timestamptx for Oracle; Added support for the number data type provided in the jdbc-odbc Oracle driver; Added support for Sybase's driver JConnect 6.0 (new class name); Included a character range check when writing XML contents. Mapper an item to the Mapper Tools menu to generate a text report of mappings. An equivalent API function is also available: public java.lang.String getCsvReport(boolean bSkipRootNode,charfieldDelimiterCharacter); Added the ability to view table relations diagrammatically in addition to the existing tabular format; Added options in the Marshal and Unmarshal Settings dialog for custom formatting of date and datetime fields; Added an option to remove header and footer lines when unmarshalling text files; Created a new sample project with a script that uses a Java Class. Setup Fixed a problem with the setEnvAlloraAPISample batch files (.sh, .bat): an extra set of double quotes in %JDBC_DRIVER_CLASSPATH% was sometimes generating an error.
5.0-7	10/30/08	Workflow Manager Updated the Send Email task with SMTP authentication when required by the outgoing mail server. Setup Added .exe setup file for Windows installation.
5.0-6	05/09/08	Mapper Fixed a problem with complex XMLSchemas when the “Show Namespace Prefix for Nodes” was set to true. Some elements in the marshal output file were missing the namespace prefix. Setup Removed some download files for specific OS. Current download files are *.zip and *.tar formats.
5.0-5	11/20/07	Mapper Fixed a problem that occurred when regenerating tables from XML schema; Fixed a problem that occurred when creating xsd:key nodes for primary key columns while generating an XML schema from database tables; Fixed a problem that occurred when connecting to database, if the database and project values for a numeric column property did not match because one was ‘null’ and the other was ‘0’, a column property mismatch was shown. This mismatch is now ignored; Added support for parsing xsd:pattern and enumeration values to understand the length of a node’s value so that the length of the database column generated for these nodes can be set. Workflow Manager Fixed a problem that occurred when deleting loop tasks. Even if the user selected to delete the task without deleting subtasks, the subtasks were being deleted; Added a Send Email task. Engine Configured the Progress OpenEdge JDBC driver to work with Allora.
5.0-4	06/28/07	DBConnector for Funambol Fixed a problem with updating database records when key node is auto-incremental.
5.0-3	04/16/07	Mapper Fixed a problem loading imported schemas with no namespace specified; Fixed a problem loading table information for Gupta SQLBase database.
5.0-2	03/28/07	Mapper Fixed a problem in reading constraining facets like length, maxLength, totalDigits and fractionDigits from XML schemas so that these values can now be used to determine size of table columns in generated tables.
5.0-1	03/22/07	Mapper Added support for redefined XML schemas; Improved performance of code to select XML nodes for table generation; Fixed a problem in resolving relative paths of external schemas; Added options to unmarshal code generation: intermediate commit, continue to unmarshal even if it fails for some records. Workflow Manager Introduced a new application to aid in design of tasks involving marshalling and unmarshalling operations. The Workflow Manager allows users to lay out, schedule and run a series of interrelated tasks as a workflow. It can be used for any Java tasks, but is particularly useful in designing workflows that involve marshalling and/or unmarshalling operations. Engine Added support for fixed length text files where each record is on a new line, the last field does not need to be padded. Previously an IndexOutOfBoundsException error was being thrown during unmarshalling.
4.2-9	10/25/06	Mapper Added an option to enable Xpriori XMS database from the Preferences dialog. Fixed a problem related to incorrect namespace prefixes for referred attributes in an XML schema. DBConnector (formerly Sync4jConnector) Added support for Funambol version 3.0.
4.2-7	07/18/06	Mapper Added support for auto-incremental columns to be mapped and set as unique. Engine Support for ANTS Data Server Database; Support for MaxDB database; Added support for auto-incremental columns to be mapped and set as unique. Sync4jConnector Added support to synchronize based on user or device. If user is selected then records are synchronized by principal user and if device is selected then records are synchronized by principal id.
4.2-4	05/12/06	Mapper Added support for JDeveloper 10.1.3; Fixed a problem loading combine key settings for hidden attributes. Engine Added an API to access statistics of a marshal and unmarshal operation.
4.2-3	04/05/06	Mapper Added an option to automatically commit a transactional unmarshal; Fixed some minor problems with code generation; Fixed an error in the runMapper.sh script file. Engine Fixed a problem in parsing XML files starting with byte order marks of their encoding; Fixed a problem when doing an unmarshalXMLStream with a mapping file containing primary keys mapped to XML expressions; Overcame the limitation that required the unique columns to be non null when the property “Check Unique Cols In” was set to “Input File”. An exception was reported during the unmarshal process when a null value was assigned to a unique column.
4.2-1	03/13/06	Mapper Added support for text files; Added support for displaying mapping lines for expression mappings; Added new date/time conversion functions to XML expressions; Added ability to add/remove alias by right-clicking on a table node in the Mappings tab; Fixed a problem with BLOB/CLOB fields in a SQL query project when using Oracle RDBMS; Fixed a problem with code generation when generating record-level code and also when using lookup files; Fixed a problem of projects getting deleted when saving syncsources in the Sync4j connector; Fixed a problem with the w3c datatype not being evaluated for elements and attributes that are not global or do not refer to global complexType or SimpleType nodes. Because of this no columns were generated for elements with mixed content having child elements/attributes; Fixed a problem with the Allora datatype being shown for auto-incremental columns in databases which do not have a difference in the numeric datatype names for auto-incremental and non auto-incremental columns; Added support to create batch/script files for executing generated code on another machine. Engine Added support for text files.
4.1-3	08/29/05	Mapper Fixed problem in loading predicate expressions containing sub-expressions; Removed automatic conversion of the "Uniqueness Check Domain" from "Database" to "XML document" if a database table has an auto-incremental column set as unique. Engine Fixed a problem with "Split XML output in mutiple files." When combine was set, the attributes on the root node were not saved in the output file; Added support for namespace in marshal DOM output.
4.1-1	06/15/05	Mapper Added support for Multiple Select Statements during marshal (also called Split Map Feature); Added support for null values and blank strings in Lookup files; Added support for complex database expressions; Added support for stored procedures in Oracle packages; Added support to highlight relations for a given table; Improved support for namespaces saved to marshal output file; Fixed problems with the Find Node function; Fixed problem in loading java class script files; Fixed problem when displaying table qualifiers page in the Marshal and Unmarshal wizards even if the mapping file was based on a SQL query or stored procedure. Engine Fixed problem with UpdateOnInsert when the XMLRecord contained some null columns; Fixed a problem with output parameters of a stored procedure with no resultset; The cause for XMLRecordsetException and XMLMappingException exceptions thrown by engine can now be obtained if coding using jdk1.4 or higher. IDE Added support for Netbeans 4.0; Added support for Multiple Select Statements mapping file.
4.0-6	01/13/05	Mapper Added support for selecting/deselecting predicates to include in the mapping file; Added support for Oracle join expressions in SQL expressions; Fixed ArrayIndexOutOfBounds exception when parsing XML file used to select XML schema nodes for table generation; Fixed a problem in the set of XML schema nodes selected for table generation when an input XML file was used; Fixed a problem where the save button was not enabled when the project's schema file location is changed; Fixed a problem where namespace declarations for XML node namespaces were not present in the generated output file; Fixed a problem for certain databases like MSAccess that do not accept database identifiers containing the dot character, even if the identifier is quoted. The dot character is replaced with the underscore character for generated table and column names when generating tables from an XML schema.
4.0-5	12/03/04	Setup Added a setup program for Solaris platforms Mapper Moved option "Show Tables and Views only" to panel containing database table tree. This change appears in the New Project wizard and Add/Remove Tables dialog. The option is no longer editable from the Project Properties dialog. Added dynamic retrieval of database tables. Added new tab "Warnings" in the Marshal Settings and Unmarshal Settings dialog to allow user to hide warnings appearing before marshal/unmarshal and code generation. Improved performance of mappings/settings analysis before running marshal. Changed DOM XML parse to SAX XML parse for XML input file specified to select XML schema nodes for table generation. Fixed a problem in the Table Properties tab. Now, if the user selects an Allora(hitns) datatype starting with "auto_", the autoIncremental property for the column is set to true and vice-versa. Similarly if the user changes autoIncremental property, the Allora datatype property is updated. Fixed a problem in the Lookup File Editor where the rule status (in file, in project) tooltip was not appearing on the rule nodes. Added a message dialog asking the user to confirm deletion of mappings from the DB tree in the Mappings tab. The text of the option to hide this warning (shown in the Preferences dialog) also changed. Engine Fixed a problem where encoding was overwritten when set for the mapping file. IDE Added support for lookup files. Users can now specify a look-up file and look-up ruleset.
4.0-4	11/11/04	Mapper Added support for from Computer Associates IDMS database. Engine Fixed a problem when performing "update on insert"with a key that has a null value. IDE Fixed a problem with the Allora wizard for Oracle JDeveloper 10g.
4.0-3	10/22/04	Mapper Added support for Stored Procedures; Added support for parametrical SQL queries; Added the ability to generate java code for marshal/unmarshal operations; Renamed Quick Marshal Wizard and Quick Unmarshal Wizard to Marshal Wizard and Unmarshal Wizard respectively; Added support for creating a Mapper project with an XML File instead of an XML schema; Added support for Lookup or substitution rules on mapped nodes; Introduced auto-set for combined nodes by analyzing an XML file; Introduced auto-selection of XML schema nodes to use during database table generation by analyzing an XML file; Enhanced support for modifying database tables generated from XML schema; Added support for specifying preferences like length, precision & scale for columns in generated database tables; Added support for generating tables without generating table relations; Added support for applying database restrictions on column name size when generating database table from XML Schema; Added support for regenerating database tables in a Mapper project; Added support for refreshing database contents in a Mapper project; Added an option to automatically connect to the database when opening a Mapper project; Added the ability to change the "Show Tables and Views Only" option in an open Mapper project; Improved support for abstract complex types in XML Schema; Added support to allow XML schemas with cyclic includes or imports; Changed XML schema validation procedure from validating record-by-record to validating a complete XML document; Changed default settings for marshal option "Add XML Document Element" to facilitate validation of generated output against XML schema. Also added warnings and suggestions in this regard; Changed behavior to generate marshal output file even if there is a validation error; Added support to find nodes in XML Schema and Database trees; Separated primary key and unique column settings; Added support for new datatype "auto_bigint"; Added ability to map a database column to a database expression that is valid in a SQL INSERT statement and will be usedduring an unmarshal operation; Added ability to reorder database column sequence for tables not present in database; Added ability to add text (Example: comments) to the start of the marshal output file; Added ability to specify applications to use for viewing script, XML and HTML files; Added help topics for complex warning appearing before marshal/unmarshal; Changed mapper help from JavaHelp to HTML help. Engine Table/column names automatically generated by the mapper should now follow the size restriction of DB; Fixed a problem with validation; Added support for database expressions in Unmarshal (current time stamp, curr val, next val for sequence, ext); Added support for stored procedures in marshalling; Added support for parameters in a SQL Query Mapper project; Added support for bigint identity data type; Added differentiation between "Is unique" database columns and "Primary key" columns; Added a getConnection method to the XMLSchemaMapper interface to use in the start script; Added a header for output XML; Added support for Lookup, or substitution, rules for marshal & unmarshal; Added support for unsigned number; Managed "create index" for creating relations (DB2 and SQLBase)"; Fixed a limitation regarding a commit in the middle of an unmarshal. Configurator Added buttons to re-order DSN's; Added check to see if selected drivers are supported by Allora (JDBC and ODBC); Enhanced license check; Added ability to automatically detect Allora Home folder for the non-setup version; Added feature to configure the API sample "setEnvAlloraAPISamples" batch/script. New application: Allora API Samples Added an application to run the API samples using the database connections configured in the Configurator; Added support for choosing a DSN, activating a trace, and setting a table qualifier; Added support for configuring an external viewer to see the XML output/input and the sample Java code.
3.6-2	09/21/04	Setup Fixed a problem where a "Main class not found" message was displayed when launching the mapper. This was caused by a JDBC driver containing spaces in the folder name. Engine Fixed a problem with ArrayOutOfBoundException when using setParameter from the start function in a script; Fixed a performance problem checking unicity with decimal or numeric keys connecting to a Sybase ASE database; Fixed a NullPointerException that occurred when setting unicity on an autoincremental field; Fixed a problem using a Java class script in an application server: ClassNotFoundException in the script class; Added support for BigInt identity datatype.
3.6-1	07/14/04	Engine Fixed a problem that occurred when using the combine feature under certain conditions. Mapper: The datasource use in a project is now remembered when attempting to reconnect to the database; Fixed a problem loading certain schema; Fixed problem where mappings were lost when changing a table qualifier .IDE integration; Added support for Oracle jDeveloper X; Added support for the database "Solid Database Engine.
3.6-0	07/01/04	Introduced a new installation program for Windows and Linux platforms; Enhanced the configuration program: Allora Configurator; Changed the product name from jAllora to Allora throughout the graphical user interface and documentation; Added concept of datasource, defining a database connection with a user-defined name, that can be use in any Allora DB connection. (Mapper project, IDE integration wizards, Quick Marshal and Unmarshal). Datasources can be created and edited from the Allora Configurator; Added integration with XMLSpy. Engine Changed the Allora API constant name XMLRecordset.DISABLE_RECORD_VALIDATATION to DISABLE_RECORD_VALIDATION; Added a getRecordset method to the XMLSchemaMapper interface and a getConnection method to the XMLRecordset interface to expose the internal JDBC Connection object to scripts.
3.5-11	05/19/04	Engine: Added support for Microsoft Visual FoxPro database using the Sun JDBC-ODBC bridge and the Visual FoxPro ODBC driver.
3.5-8	04/08/04	Engine: Fixed problem during unmarshal occurring if 2 XML nodes are mapped to the same DB field. Mapper: Fixed problem in supporting included schemas that do not have the targetNamespace specified; Added support for abstract complexTypes; Made changes in XML schema file parsing to support UCCNET schemas where some included schemas do not have the targetNamespace specified; Fixed a problem where, for a node that was disabled for mapping, all its descendant nodes should also be disabled for mapping.
3.5-4	03/09/04	Engine: Fixed a problem with marshalOVLT methods in the jAllora API; Fixed a problem in loading a mapping file with combine settings. The loading failed with the error: “[Error] Error in the complexType "*Combine_Key_n": the xml node "" is not a descendent of the element "". The problem was introduced in build 3.5-3. Mapper: Fixed a problem with the xmlschema namespace prefix in the mapping file.
3.5-3	03/03/04	Engine: Added support for GUPTA SQL Base JDBC driver; Fixed problem with connection pooling; Fixed a problem where the output XML file remained locked until the end of the Java application when schema validation was set. Mapper: Added support for GUPTA SQL Base JDBC driver.
3.5-1	12/30/03	Engine: Added support for namespace prefixes. Mapper: Added support for namespace prefixes in XML schemas; Added support for substitutionGroup in XML schemas; Added dialog to allow renaming of namespace prefixes; Added option to select all XML schema nodes for table generation in the New Project wizard; Improved DB Connection wizard to allow deliberate change of table qualifiers; Improved Quick Marshal and Quick Unmarshal wizards so that last settings are remembered when wizard is displayed; Fixed problem in comparing DB identifiers for databases like MySQL that do not support mixed case identifiers; Improved the column property mismatch warnings shown to the user in the DB connection wizard; Improved DB connection from Marshal dialog or Unmarshal dialog: You can now connect directly from the "Not connected to DB" warning message dialog that appears from either the Marshal dialog or the Unmarshal dialog; Added option in the New Project wizard to save XML schema file to project folder; Added option in the Preferences dialog for user to specify the max. size of a file to open in text viewer. If file exceeds this size a warning is shown to user before opening file; Improved: The dialog to select combine keys (in the Combine Node wizard) now has a tree with checkbox nodes.
3.5-0	11/11/03	Engine: Added new APIs to rename table qualifiers loaded from a mapping file: this is useful when you want to execute a marshal/unmarshal on a database different from the database used to build the mapping file. In this case the catalog, schema or table name stored in the mapping file might be different in the new database; Added new API setEmptyStringValue. Helps resolve the problem with Oracle databases where empty string values are converted to NULL; Added support for reserved words: a column name or table name can now be a database reserved word; Added the ability to choose the top-level element (root node) in the resulting output XML or input XML. The user has also the option of not adding a top-level node; Added an option to split output file into multiple files; Introduced the ability to add hidden attributes or elements to the mapping file; Added support for creating keys and foreign keys in unmarshaling when creating tables; Added support for FrontBase JDBC driver; Added handling of XML schema data types; Added Xpath-Xquery support; Introduced a new Predicate class to add SQL predicates to an existing mapping; Enhanced support for Namespaces and schema location; Added the following XMLRecordset options (see javadoc for more information): - IGNORE_XMLSCHEMA_DATATYPES - CREATE_TABLE_KEYS - CREATE_TABLE_RELATIONS - DISABLE_RECORD_VALIDATATION - USE_SELECT_DISTINCT - SPLIT_OUTPUTXML_FILE Added support for Advantage Ingres database; Enhanced support for SQL expressions by adding SQL-specific Function Configuration for database expressions; Added an option to skip entity references in input XML file (unmarshal). Mapper: Added a Project Explorer to manage project files; Introduced support for SQL Select Query to generate result set for mapping; Modified Project Properties dialog; Modified Options dialog (re-named, now Preferences dialog); Added a new RHS type called “Range” in the DB predicate and XML predicate dialogs to specify the RHS value when the predicate operator is “BETWEEN”; Added the ability for a user to replace mapping without first unmapping a node; Enhanced SQL expression dialog: For most databases, we now only show functions supported by the database; Added new dialogs to set marshal and unmarshal properties (Marshal Settings & Unmarshal Settings); Added Marshal/Unmarshal statistics display; Added support for Root Node (technical term used in Mapper is “XML Document Element”); Added support for split marshal output files; Added support for adding “schemaLocation” information to marshal output file; Added support for using the “SELECT DISTINCT” statement instead of “SELECT” during marshal; Provided a SQL View window to allow users to view SQL Select statements generated for marshal from the Mapper; Added support for specifying XML encoding for marshal output and unmarshal input files; Added support to skip references to entities present in unmarshal input file; Added support for allowing users to create table relations and primary keys in the database when creating tables during an unmarshal process; Introduced dynamic schema loading (this resolved problem of cyclic refs); Introduced new approach for generating tables from XML schema (allowing users to select nodes for which tables are to be generated) to workaround problem of Mapper getting stuck if schema is too big; Enhanced table/column generation by giving users the option to generate tables/columns using upper case/lower case/ same case as XML schema nodes; Enhanced table/column generation by making use of “xsd:key” definitions in XML schema when generating database tables; Added support for hidden XML schema attributes; Introduced a new wizard to set combine properties in the XML Structure tab; Added support for XML schema datatypes; Allowed renaming of table qualifiers for tables in a Mapper project. Also allow renaming of table qualifiers from the Quick Marshal and Quick Unmarshal wizards; Allowed changing DB connection for Mapper project; Added new Table Properties tab for setting unmarshal attributes at table/column level; Added support for setting sequence of columns in a composite key; Added support for Identify columns with auto-incremental properties for Sybase; Allowed users to specify values for dynamic parameters present in mapping file from the Quick Marshal and Quick Unmarshal wizards; Introduced complete jAllora help (javahelp) available from Mapper. jAllora Wizards: Added support for IBM Visual Age Wizard; Added support for WebSphere Studio/Eclipse Wizard.
3.1-16	09/17/03	Engine: Added: support for the MySQL Connector/J JDBC driver; Fixed a problem calling setParameter(s) after a marshal operation: the parameter value was not set to the new value; The update and delete methods now require a unique index defined on the table or in the mapping file and that index is used to locate the record to delete/update. Mapper: Changed the description of a check box in the DBConnection tab of the New Project Wizard from "Hide System Tables" to "Show tables and views only". The functionality has not changed.
3.1-15	06/12/03	Engine: Added: Support for reserved words; Optimized: The unmarshalling process when the root is combined but unmapped.
3.1-13	05/20/03	Engine: Fixed problem where rootName was set to null and the marshal process didn't return any records (empty output file). An 'invalid output file' exception was returned; Added support for namespaces when the rootName is null; Added setRootNode API in XMLRecorset; Fixed: Auto-incremetal columns not mapped and not used in any relation were ignored and not updated with the sequence value. Mapper: Fixed problem with column names being written in table-definitions of mapping file; Updated runMapper.* files to support space characters in the jAllora Home directory; Fixed problem: Prefix “auto” was not being added to auto-incremetal columns in the mapping file.
3.1-9	03/03/03	Engine: Fixed a problem with JDK 1.2.2 calling the JDBC getBigDecimal method; Fixed a problem with predicates expression using Oracle version 8 or earlier. Mapper: Fixed bug: Max connection exceeded license exception was being thrown if the number of times the marshal/unmarshal process operation failed = max connections allowed for license; Fixed bugs 744 & 745 related to SQL Expression parsing; Fixed bug: The “isUnique” unmarshal attribute was not being loaded correctly while opening project in offline mode; Fixed bug: 741; Fixed bug: If alias name in the mapping file was quoted, when the project was reloaded the alias name contained the surrounding quotes
3.1-8	02/14/03	New Features Added a new method to generate DataBase Tables from XMLSchema; New option to choose one global element from the schema; Added support for JDataStore JDBC driver.
3.1-7	01/27/03	New Features Added readme files to the samples directory for configuring JMS providers; Added a list of recent projects opened to the File menu. Changes Fixed a problem where a SQL error could happen if a column name containing special characters was used in the unicity check; Fixed a problem where Oracle sequences containing special characters could generate an SQL error; Fixed a problem using the addColumn method in an unmarshal script; Fixed a performance problem that occurred when saving the mapping file if the mapping file is too large; Changed formatting of mapping file to use 2 space characters instead of a tab to indent XML data for consistency across various editors; Changed predicate support to allow users to create a string constant with only space characters; Improved font in the Script editor; Fixed a problem where the URL for a Java-CLASS script written to the mapping file was not working on Unix systems; Fixed a problem where an exception occurred while trying to add/remove XML nodes if a DTD was used instead of an XML schema; Fixed problem where a DTD was not loading with jdk1.3; Fixed some problems with duplicate key settings in the XML Structure tab; Fixed a problem where an unmarshal process creates tables in the database but those tables disappear from the Mapper if the add/remove tables dialog is used.
3.1-5	12/16/02	New Features Added ability to view multiple mapping lines in the Mappings tab; Added ability to create predicate expressions; Added support for IN, BETWEEN, LIKE operators in predicates; Added XML Structure tab for setting combine features (combine key, group, eliminate duplicates); Added support for optimized combine of nodes in XML output file; Added sorting of XML output results--in memory or using ORDER BY clause with SQL query; Added ability to expand combined nodes in XML input files during unmarshalling; Added ability to generate relational database schema from XML schema; Added automatic mapping between nodes and columns when generating a schema from database tables or database tables from a schema; Added feature to regenerate XML schema after initially generating then modifying table selections and database relations in the Mapper; Added ability to set transaction level when unmarshalling in the Mapper; Added validation of marshal output and unmarshal input against the XML schema of project; Added new feature: RunMapper script files can be called from the command line with additional arguments like the name of the project to open; Added ability to integrate with Forte. Enables a user to double-click on a .amp file in the Forte file system and view the contents in the jAllora Mapper opened as a tab in the Forte editor workspace; Added new feature: XML input/output from URL for marshalling/unmarshalling can come from a URL; Added: Runtime generation of mapping file based on a SQL query. Changes Modified licensing support for developer and runtime license; Enhanced support for Microsoft updategrams.
3.0-12	07/30/02	Engine: Changes Fixed a problem using xml-expression containing unmapped xml-nodes; Fixed a problem with unmarshal using tables containing auto-incremental fields; Fixed a problem using tables name or fields containing special characters. Mapper: New Features Added XML schema nodes used in XML expressions to the mapping file by default (even if they are not mapped); Added more trace statements to know the java system properties. Changes Fixed bug with XML Expressions. No error was being displayed if expressions were invalid; Fixed problem with the XML Schema being generated from a database with tables having a space char in their name. Also fixed problem of hierarchy of tables in the XML schema based on relations; Fixed problem with predicates panel: The 'edit' and 'delete' predicate buttons were disabled if only one selected row was present in the table; Fixed bug of duplicate user-defined relations appearing when reloading a project built with Ms Access as the database.
3.0-11	06/24/02	New Features A list of Supported JDBC drivers and driver problems ; Added support for Mapper Projects to manage mapping files and other files associated with the mapping file; Added support for table aliases created in the Mapper; Added support for Parametric Predicates in the Mapper and Engine. You can create predicates (WHERE conditions) that use dynamic parameters; Added support for creating XML Predicates in the Mapper and using them in the engine to filter data in an XML document when unmarshalling to a database; Added support for XML expressions in the Mapper and Engine; Added DBCS support for using the Mapper and Engine on a double-byte system to connect to a double-byte database; Added Mapper options for unmarshalling data to a database, including updating existing records and checking record uniqueness using an Unmarshal Attributes pane in the Mappings tab; Added Mapper and Engine support for executing scripts during marshalling and unmarshalling operations. There is now a Scripts tab in the Mapper and scripts can be written in JavaScript, Jython and Java; Added Engine support for block inserts (XMLRecordset.setBlockInsertSize) for better performance during unmarshalling. Note that not all JDBC drivers support block inserts; Added support for saving Mapper marshalling and unmarshalling properties in a mapping file to be used by the Engine; Added support in the Mapper for working offline (without connecting to a database); Added APIs allowing OEM customers to integrate the Mapper with their application; Added a sort option in the Mappings tab for sorting database columns; Added Quick Marshal and Quick Unmarshal wizards to the Mapper for marshalling/unmarshalling without a project; Added sample Mapper projects in the samples/Mapper directory. Changes Removed Marshalled XML Content dialog for cardinality and incorporated functionality in the Mappings tab toolbar; Added a tab to the XML Mappings pane on the Mappings tab to display mappings for marshalling and mappings for unmarshalling; Changed the Table Relations tab to display existing table relations and create relations for use in jAllora; Created a Predicates tab to define WHERE conditions for marshalling and filters for unmarshalling; Enhanced the API addWhereCondition method; Enhanced sendUpdategram method. Known Problems Drag and drop problems may occur if using JDK 1.4.0. If you try to map an XML node to the same database column twice, you get an error. This is a reported problem for JDK 1.4.0 in the Java bug database. The bug ID is 4623377. The problem has been fixed in JDK 1.4.1(beta); When using the Mapper wizards (New Project, Quick Marshal, Quick Unmarshal), the image that appears on the left side of the wizard window is not always visible.
2.5.0	11/20/01	Incompatibilities with Earlier Releases 1. When mapping files contain table definitions This version of jAllora includes a more flexible approach to handling different data types in JDBC drivers. This means that mapping files containing a table definition will not load correctly in jAllora 2.5. You need to edit the mapping file in a text editor and remove the table definition, then load the mapping file into the jAllora 2.5 Mapper to create a new table definition (From the Mapper Options menu, choose Settings.) Save the mapping file with the new table definition. 2. When using jAllora's wizards for Forte for Java The .jar file name for the wizards have changed. If you have installed the .jar files for the jAllora 2.0 release, you need to uninstall them and install the new .jar files. Remove the old .jar files(allora_fw.jar and allora_ft.jar) from the Forte modules directory. Open the installedModules.xml file in the modules directory. Remove the following text: <module codenamebase="com.hitsw.wizards.forte" release="-1" specversion="1.2" base="central" url="allora_fw.jar" enabled="true" /> <module codenamebase="com.hitsw.tools.forte" release="-1" specversion="1.3" base="central" url="allora_ft.jar" enabled="true" /> Launch Forte. From the Tools menu, choose Global Options. In the window that is displayed, click the Menu button on the left panel to display a list of sub-menu items. Click Wizard to display all the wizards. Select each jAllora wizard (starts with com.hitsw.wizards.forte), right-click and choose Delete. Click Tools to display all the tools. Select com-hitsw-tools-forte-Mapper, right-click and choose Delete. Exit Forte and put the new jAlloraForte.jar and jAlloraForteMapper.jar in the modules directory. Launch Forte to use the new modules. New Features Added jAllora Web Service for developing client applications that accessa remote database. Added support for combining and sorting nested XML elements (one-to-manyrelations, from the database perspective) in the Mapper and underlyingengine: Combine Duplicates and Sort properties in the Mapper andUSE_SORT_COMBINE option in the API , set to true by default. Modified internal handling of different JDBC driver characteristics. This means that mapping files containing a table definition will not loadcorrectly in jAllora 2.5. You need to edit the mapping file and remove thetable definition before loading the file into jAllora 2.5. Added sample code and documentation for the jAllora Web Service. Added XMLRecordset.writeDocument to output a recordset's DOM document toa writer. Renamed MapperGUI.jar to jAlloraMapper.jar, allora-fw.jar tojAlloraForte.jar, mapper-ft.jar to jAlloraForteMapper.jar, allora-jw.jar tojAlloraJBuilder.jar, mapper-jt.jar to jAlloraJBuilderMapper.jar.
2.0.20	10/03/01	Updated the documentation; Updated the batch file for Mapper: RunMapper.bat; Updated jAllora.jar: More datatypes supported; Updated Mapper: Resolved problem when performing a Marshal test with DB2
2.0.19	09/19/01	In the Mapper application, link line now also shows for a subtree of elements instead of just a single element; In the Mapper application, database tables and columns now appear in ascending order in the Database pane.
2.0	08/15/01	Tested JDBC drivers: Database Drivers SQL Server BEA WebLogic jDriver(tm) for MSSQLServer Opta2000 i-net JDBC driver for Microsoft SQL Server Oracle Oracle JDBC/OCI Driver Oracle Thin JDBC Driver Sybase Sybase jConnect for JDBC (Check with HiT Software if using Identity fields) DB2 UDB (Windows NT) HiT JDBC/DB2 (Check with HiT Software if using longvarchar) IBM DB2 UDB for iSeries (formerly AS/400) HiT JDBC/400 IBM Toolbox for Java TimesTen TimesTen JDBC Support MS Access Sun JDBC-ODBC bridge and Microsoft Access Driver (Table relations not visible in Mapper due to limitation in JDBC-ODBC bridge.) Tested Java environments: Microsoft Windows (Java 2 Platform from Sun Microsystems), Solaris[tm] Operating Environment, Intel Platform Edition (Java 2 Platform from Sun Microsystems), Linux (Java 2 Platform from Sun Microsystems), IBM AIX (IBM Developer Kit for AIX, Java Technology Edition); Renamed product from Allora for Java to jAllora. Some jar files have been renamed accordingly; Added mapping API to support mapping XML schemas and DTDs to relational database tables; Added Mapper application to provide a GUI for creating mappings between XML schemas/DTDs and database tables; Modified existing APIs to add methods/parameters to support mapping. Deprecated methods are described in the docs/api directory; Modified wizards for Borland JBuilder and Sun Forte for Java to support mapping; Added tools to launch Mapper from Borland JBuilder and Sun Forte for Java; Removed HiT DOM and SAX implementations. Now use standard JAXP1.1 implementation; Updated samples and documentation to demonstrate/explain mapping feature; Modified release format, providing .zip files with and without supporting JAR files and .gzip file with and without supporting JAR files; Created new directory structure in release: added lib, bin and logs directories.
1.6	07/02/01	Added wizards for Borland JBuilder and Sun Forte for Java; Changed installation to use JAR files; No longer includes JAXP distribution.
1.53	03/28/01	Added support for JAXP1.1
1.5	03/15/01	Added data binding via the XMLRecordsetBuilder class, XMLRecordset interface and XMLRecord class; Added support for message queues by implementing the JMS (Java Message Service) API; Added the ability to write back to a database via the JAXP XMLDocumentBuilder class; JDK 1.3 for application development needed if running the JDBC-ODBC Bridge against ADO 2.5 or ADO 2.6 on Microsoft Windows.