Bug fixes:

• MySQL database INTEGER fields did not show in the printed reports, and the charts (Pie, Bar and Line) did not show values originating from these fields. This was caused by the mismatch in the data types between MySQL and Scribe, where INTEGER data type in MySQL was treated as LONG by the JDBC driver, but received as INTEGER by Scribe, with subsequent loss of data.

Bug fixes:

• TIME data type in StelsCSV JDBC driver was incorrectly interpreted as DATE.

New features:

• StelsCSV driver added to the list of supported databases. StelsCSV is a JDBC driver that allows to perform SQL queries and other JDBC operations on text files (comma separated, tab separated, fixed length etc). The driver provides a view of the text files as tables of a relational database, and can seamlessly integrate them into the procedures that retrieve and update the database data. An evaluation version of StelsCSV driver is now included into the standard distribution of Scribe; the fully-enabled version of the driver can be obtained from http://www.csv-jdbc.com.
  
  NOTE: for the StelsCSV driver to take effect, you will need to edit ScribeAdmin.lax file to include the csvdriver.jar file into the classpath, as in the following example:
  
  # LAX.CLASS.PATH
  # --------------
  # the Java classpath necessary to run this application
  # Can be separated by colons (Mac OS/Unix) or semicolons (Windows)

  lax.class.path=Admin.jar;ScribeWebServer.jar;Server.jar;ResidentServer.jar;Client.jar;jai_core.jar;
  ojdbc14.jar;jcommon-0.9.0.jar;RMIclasses.jar;jfreechart-0.9.15.jar;csvdriver.jar;jai_codec.jar;
  wrapper.jar;mssqlserver.jar;msbase.jar;mimjdbc2.jar;mysql-connector.jar;jconn2.jar;mckoidb.jar;
  jhall.jar;msutil.jar;DaffodilDB_Client.jar;activation.jar;mail.jar;iText.jar;mkjdbc.jar;lax.jar

Bug fixes:

• Synchronization of HTTP requests in servlets contained some errors that could have caused malfunction under heavy load, if large reports were produced concurrently.

New features:

• Windows NT service Preference, that provides a graphical interface to the service installation/deinstallation scripts.
• Updatable resource location Preference. This allows to automate the process of updating those Scribe files that are outside of the Scribe server home directory. At this time, these resources include the servlet (Scribe.war) and the API library (ScribeConnect.jar) file.

New features:

• On Windows, the Scribe server installed as NT service can now be started through the Administrator utility, by pressing the Start button. This will start the server as NT service, as if it were done through the Windows Control Panel > Administrative Tools > Services interface.
• The Update Manager can now check for the updates without stopping the server first. Note, however, that to actually install the updates the server still must be stopped.

Scribe V.1.1 Build A28

New features:

• Dynamic construction of Value List through a user-defined Function. With the introduction of this feature it becomes possible to load the content of Value Lists from a dynamic source, such as the database table.

Bug fixes:

• ORACLE adapter modified to treat the unqualified NUMBER data type as a floating-point value.

Scribe V.1.0 Build A27

Bug fixes:

• Opening of a print template made its entry in Resources view of the Report Palette disabled, necessitating a restart of the Client.
• When the same print template was used in multiple locations in a Report Procedure, and different instances of the Print Component used different drill-down patterns (e.g. the same field was designated as a drill-down trigger in one Print Component, but not in another to achieve a "selective" drill-down effect), the designated drill-down fields in the generated report did not trigger the lower-level reports.

Scribe V.1.0 Build A26

Bug fixes:

• Charts (Pie, Bar and Line) were not displayed in the Web-based reports. Requires reloading and redeployment of Scribe.war file.
• Under Linux in Java 1.5.0 the size of the windows was sometimes miscalculated, resulting in excessively large windows. This is specific to Java 1.5.0, the behavior of windows under Java 1.4.2 was not afected.

Scribe V.1.0 Build A25 - production release

This the first fully supported production release of Scribe.

New features:

• Support for the HTML format of reports - both in the Client-based and Web browser-based reports.
• Support for Java 1.5.0.

Bug fixes:

• When 3 or more tables were joined together, the Join Inspector labeled the joined tables incorrectly after saving the flowchart and reloading it again.
• The EMPTY status of the REPORT variable with no report to show was not set correctly, such that REPORT == EMPTY condition component always returned NO.
• Suppression of Report display did not work in multi-level reports and processes.
• Scribe servlet now looks for the properties file ScribeDefaults in webapps directory of Tomcat, instead of the Tomcat's home directory.

Instructions for upgrading from the beta version

After updating the Scribe Server, please do the following:

• Copy the file RMIclasses.jar from the Server installation directory to each Client directory. The new version of Scribe Client loads this file automatically from the server, but the beta version does not have this mechanism. What's more, even after upgrading, the beta version of Scribe Client will still lack the ability to automatically update this file for the future releases, so you should eventually download and install the production version of Scribe Client to avoid copying the file manually in the future.
• If you run Scribe Server as the NT service, update the wrapper.conf file in the Server installation directory. This is an ASCII file, and it can be edited with any text editor. The line to edit is third from the top, and it should read now:
  
  wrapper.app.parameter.1=ResidentServerConnection.ServerStarter
  
  (the ServerStarter class has been moved into the ResidentServerConnection package, and now must be qualified with the package name).
  
  Alternatively, you can force the update of this file by simply changing the currently selected database adaptor in the Setup tab of the Administrator utility, and then setting it back to the old value.
• Replace the Scribe servlet (Scribe.war file) in the Tomcat webapps directory with the production version. Also, move the Scribe properties file ScribeDefaults to webapps directory.
• If you made use of the Scribe API library for running reports from your own applications, replace ScribeConnect.jar file.

Scribe V.1.0 beta2 Build A24

New features:

• Direct SQL form of the Database Retrieval component.

Scribe V.1.0 beta2 Build A23

Bug fixes:

• Aggregate function COUNT removed from the Group By section of the Array Inspector.

New features:

• Array components can now be shared between different procedures. Arrays can be passed into and out of procedures through Parameter and Return value components.

Scribe V.1.0 beta2 Build A22

New features:

• A new aggregate function (COUNT) has been added to the pop-up list:

• "Distinct" checkbox in the Database Retrieval Inspector now applies to Single Row retrievals with aggregate functions. The "Query returns" box has been slightly modified to reflect the fact that the checkbox can be used with either option (Multiple Rows or Single Row):

When the "Distinct" option is applied to the Single Row mode, the aggregated functions are formatted with the "distinct" clause before the field name, e.g. COUNT(distinct Quantity).

Scribe V.1.0 beta2 Build A21

Bug fixes:

• Multi-level table field names were not recognized by the Syntax Check if the fields were retrieved in a Retrieval component with joined tables.
• When Retrieval components that belonged to different data sources were added or deleted, table field names referenced in other Components (e.g. Calculation, Condition, Array etc.) did not change their qualifier level according to the Retrieval components present in the Workspace.

New features:

Calculation and Condition components now have scrollable text. If the amount of text in these components exceeds the capacity of the editable text area, a vertical scroller is automatically added to the area:

Executable and Print components have been provided with popup menu triggered by a right mouse button:

Scribe V.1.0 beta2 Build A20

Changed features:

Stop-and-Show option in the Database Retrieval Inspector now differentiates between selection of a single row from the browser, and selection of multiple rows.

New feature:

Stop-and-Show functionality added to the Array component. This works similarly to the Database Retrieval's feature, and is set in the Inspector's tab view:

Scribe V.1.0 beta2 Build A19

Bug fixes:

• Variables of REPORT type can be checked for being EMPTY in a Conditional component.
• Alert component with no buttons can be used to log messages in the background jobs; the messages can be reviewed upon completion in Saved Reports or Saved Processes window.

Scribe V.1.0 beta2 Build A18

Bug fixes:

• Background jobs were stalled due to the incorrectly set configuration schema name.
• Drill-down report setting in Print component Inspector failed to show parameters of the connected report, due to the internally misformatted field names.

New features:

• For the reports called through Function components, the display can be suppressed in the Inspector's newly added checkbox.
• The server now prints the version of Java in its log.

Scribe V.1.0 beta2 Build A17

Bug fixes:

• When syntactical errors were detected, the Workspace displayed a Tool icon on the Check Syntax button, and became non-editable, but dragging-and-dropping of components into it was still possible. The fix prevents landing of components into the Workspace in the non-editable state.
• Print Template Preview window: Window > Close menu option dismissed the window, but left the Preview button disabled. Fixed.
• Print Template: Pie, Bar and Line Chart components displayed a wrong resizing cursor at the control points.
• The font Selection panel now follows the action of the parent window from which it was invoked, and is removed from the screen when the window is minimized or closed.
• YYYYMMDD date format added to the list of pre-installed formats.
• When the Date Format list is edited, the changes in the list are reflected in the Date Format Preferences view.
• Edit > Edit Date Formats and Edit > Edit Value Lists menu options renamed to Edit > Date Formats... and Edit > Value Lists... for consistency.
• Font settings of newly added Ptint Template fields is inherited from the most recently selected field.
• Paint Editor and Stroke Editor window entries are removed from the Windows menu when they are closed.
• Paint and Stroke lists are updated in the Chart Inspector pop-up lists when they are edited.

Scribe V.1.0 beta2 Build A16

Bug fixes:

• Closing the Delete confirmation panel without selection defaulted to the "Delete" action in Functions, Reports, Processes and Print Templates. Changed to "Cancel" action.
• Order of buttons in the Delete confirmation panel in Print Templates reversed, to keep it in line with other Delete panels.
• Print Template Preview window: Report > Close menu option did not dismiss the window. Fixed.
• Print Field Inspector, Underline Inspector, Title Inspector, Page Layout panel: toggle buttons made look "pushed-in" when selected, with sharper edges.

Scribe V.1.0 beta2 Build A15

Bug fixes:

• Updating/inserting CLOB failed when language settings of Oracle database mismatched the Windows registry key (replaced the Oracle JDBC driver with the latest release).
• Connecting lines on Ctrl-drag were partially clipped by the procedure component (see the figure below):

Scribe V.1.0 beta2 Build A14

New features:

1. Resizable objects show appropriate mouse cursor over their control points:

2. New feature tracker (this window)

Bug fixes:

• Text of the Title component is now selected on the first mouse click.
• Table name qualifier (Connection + Schema + Table) is now formatted properly on the drag-and-drop.