==> DFS COMPONENT NAME: MaskTracker ==> DFS COMPONENT RELEASE NUMBER: 2.9.3 ==> DFS RELEASE TYPE: minor ==> DELIVERED BY: User Support Systems team ON: 02-Nov-2005 ==> MAIN REASON OF THE DELIVERY: This is a beta OHS 2.5 Release ==> DEADLINE FOR DELIVERY TO USERS: 15-JUL-2003 ==> CONFIGURATION REQUIRED FOR INTEGRATION TESTS: Standard test plan. ==> LIST AND LOCATION OF SPECIFIC TEST DATA TO BE RETRIEVED AND USED FOR INTEGRATION TESTS: N/A ==> POINTS ALREADY CHECKED DURING UNIT TESTS: ==> POINTS TO BE CAREFULLY CHECKED DURING INTEGRATION TESTS: ==> COMPLETE LIST OF ACTION ITEMS/PROBLEMS REPORTS ADDRESSED BY THIS RELEASE: RELEASE NOTES FOR 2.9.3. [5042] In order to make the current OT compatiable with Version 2.10 Some bad sql code which uses a SELECT * instead of specifying the column names needs to be replaced in the current version. This has affected 2 files in the build of ot and masktracker DbaseHandlerMaskQueue.java TmpDBIO.java. The cvs difference for the source code tree is here Index: dbase/phase2/DbaseHandlerMaskQueue.java =================================================================== RCS file: /project1/CVS/OLDOHS/src/org/eso/ohs/dbase/phase2/Attic/DbaseHandlerMaskQueue.java,v retrieving revision 1.6 retrieving revision 1.6.6.1 diff -r1.6 -r1.6.6.1 118c118 < TmpDBIO.copyQueueReferenceData(aQueue.getId(),obrepDbName_ + ".." + EXEC_SEQ, --- > TmpDBIO.copyExecReferenceData(aQueue.getId(),obrepDbName_ + ".." + EXEC_SEQ, Index: dbase/phase2/TmpDBIO.java =================================================================== RCS file: /project1/CVS/OLDOHS/src/org/eso/ohs/dbase/phase2/Attic/TmpDBIO.java,v retrieving revision 1.7 retrieving revision 1.7.6.2 diff -r1.7 -r1.7.6.2 65,66c65,66 < String sqlText= "INSERT INTO " + destinationTable + < " SELECT * FROM " + sourceTable + --- > String sqlText= "INSERT INTO " + destinationTable + > " (sch_id,ob_id,sequence,start_time,end_time) SELECT sch_id,ob_id,sequence,start_time,end_time FROM " + sourceTable + 74a75,99 > > /** > *Copies all queue referincing data from a table to another one > *@param queueId specifies the Id of selected queue > *@throws an SQLExcception if an SQL error occurs > */ > public static void copyExecReferenceData(long queueId, > String sourceTable, > String destinationTable, > Statement stmt) > throws SQLException > { > String sqlText= "INSERT INTO " + destinationTable + > " (sch_id,ob_id,sequence) SELECT ob_id,sch_id,sequence FROM " + sourceTable + > " WHERE " + sourceTable + ".sch_id = " + > Config.getCfg().uniqueToTableId(queueId); > > > > stdlog_.debug(sqlText); > stmt.executeUpdate(sqlText); > } > > > RELEASE NOTES FOR 2.9.1 [4423] Removed redundant verify call when adding OB to exec sequence [4440] Removed eph and readme files from masktracker RELEASE NOTES FOR MASKTRACKER 2.9.1beta1 Run standard regression tests. RELEASE NOTES FOR MaskTracker 2.9.3 **************************************** * [2468] Fixed bug: Adding to exec sequence. * [2237,2239] NEW: Applications and stored procedures can now support Observing Run descriptors A-Z. * [2294] NEW: Added support for ~ (tilde) in configuration files, meaning the user's home directory. * [2131] NEW: Applications now handle more gracefully database connection errors (time-outs, etc.) * [2196] Fixed bug: in a database browser it was possible to select a sort criterion without selecting the corresponding column, leading to unexpected result sets. * [2154] Fixed bug: applications now report an error message if the database configuration file is missing. * [2075] Changed Linux runtime setup * [2065] Code cleanup: removed Eclipse compilation warnings. * [2508] Updated SQL documentation (file obrep2-create-tables.sql). ==> LIST AND ISSUE OF UPDATED DOCUMENTS: None. ==> ADDITIONAL COMMENTS: None. $Id: SEG-RELEASE-NOTES-masktracker,v 1.4.8.4 2005/10/31 14:09:46 tcanavan Exp $