[Contrib: Evaluation System] SQL conversion scripts fail

[Jim Eng]

It looks like the DDL files were added in rev 49590, and the only updates made to them were done by Nicola and me.  I will work through changes to the HBM files since rev 49590 and try to get them into the DDL scripts and the conversion scripts.  

I'd like to get a commitment from other people in this project that any future changes related to the database will be reflected in the hibernate mapping files, the DDL files and the conversion scripts.   

Thanks.

Jim


On Sep 30, 2011, at 9:01 AM, Jim Eng wrote:

> We tried the Oracle conversion scripts to upgrade table from evalsys 1.2.x to 1.4.x (i.e. trunk).  This involves running two scripts -- from 1.2 to 1.3 and from 1.3 to 1.4.  After the conversion, the evaluation tool fails with a nasty stack trace in the UI.  The immediate problem is that the SQL to create the EVAL_ADMIN table is not in either conversion script.  It's also not in the DDL files.  I have created a JIRA ticket for that (http://bugs.sakaiproject.org/jira/browse/EVALSYS-1142) and I will track this down and add the SQL for the EVAL_ADMIN table to the various DDL and conversion files.  
> 
> But this raises a question: Are there any other critical DDL statements missing from the SQL scripts?  
> 
> I am going to try to track down changes to HBM files in evalsys to see if any of them were not accompanied by changes to the SQL files.  But I'd like help.  If you know of any hibernate changes that were not also included in the SQL, please let me know.  
> 
> Thanks.
> 
> Jim 
> 
> _______________________________________________
> evaluation mailing list
> evaluation at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/evaluation
> 
> TO UNSUBSCRIBE: send email to evaluation-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
> 
>