Laserfiche WebLink
The StateDMI application has been developed using Java 1.4.0 and has been configured to run in <br />the State's computer environment parallel to existing software. Because Makenet, Watright and <br />DemandTS are being incorporated into the StateDMI in Tasks 137-139, the main reason to <br />recompile the existing applications with a newer version of Java is to maintain stand-alone <br />versions of these tools, prior to their inclusion in StateDMI, for backward-compatibility. <br />All current CDSS components run on personal computers under the Windows <br />95/98/NT/2000/XP operating systems. In addition to running on individual computers, CDSS <br />software has been installed on the State's central servers in Denver and the Division offices. <br />Upgrading to Java 1.4.0 will initially be done at RTi, after which software on the State's server <br />will be upgraded. Finally, a release to the public will occur. <br />The upgrade to Java 1.4.0 that occurs in task 155.1 is expected to require only minor changes to <br />the existing code, but testing will be needed to verify that the new version does not introduce <br />errors. Tasks 155.2 - 155.4 are enhancements that take advantage of Java 1.4.0 features. <br />In addition to upgrading applications to utilize Java 1.4.0 features, a number of overall design <br />upgrades will occur to database components compatible with the State's "System Methodology <br />Policy for Retrieving and Updating Data from the Division of Water Resource's Information <br />Database." The original low-level code developed in CRDSS to allow applications to interact <br />with HydroBase will be replaced with a newer version that has recently been developed by RTi. <br />This updated design uses less code, centralizes database interaction code, and can utilize stored <br />procedures. As graphical interfaces (e.g., the Structures view in StateView/CWRAT) are <br />updated, the new design will be phased into use in applications. These enhancements will be <br />coordinated with other software tasks. The general Java upgrades will focus on basic graphical <br />interface and technology upgrades whereas specific enhancement tasks will focus on new or <br />modified functionality. Tasks 155.2 and 155.4 will result in updates to low-level code that <br />interacts with HydroBase and this approach will be carried over when enhancements are made to <br />StateDMI in Tasks 137-139, 141 (e.g., time series query code will be developed once and reused <br />where appropriate). <br />The approach of using stored procedures is well suited for a SQL Server HydroBase database <br />but is not supported in Microsoft Access. Recently, Microsoft has released the Microsoft Data <br />Engine (MSDE) driver as an alternative to the JET Engine that is used with Access. The MSDE <br />driver allows applications to connect to a local copy of an "msf' file using a local SQL Server <br />"lite". The Java software can use the MSDE driver to connect to a SQL Server "mdf' file, with <br />little change in code after the connection is made. State of Colorado staff will create division <br />and statewide "mdf' files for testing and distribution, similar to how Access "mdb" files are <br />currently created. The "mdf' files will contain stored procedures necessary to support software <br />functionality. State of Colorado staff will develop, test, and document stored procedures. RTi <br />will perform final tests of stored procedures in applications. The packaging and distribution of <br />the database files and related database drivers is expected to occur outside of this contract as part <br />of overall CDSS maintenance. The software upgrades described herein will support the MSDE <br />stored procedure. Support for older Microsoft Access databases will be discontinued in the Java <br />1.4.0 versions of CDSS software unless additional resources are allocated outside of this scope. <br />