[Building Sakai] 2.6+Oracle: sakai_event_delay table missing

[Adams, David]

As a further followup, there are hardcoded SQL references to the
RESOURCE field in Java code that also cause Oracle errors (eg on file
uploads) once this table is actually created. I've filed
http://bugs.sakaiproject.org/jira/browse/SAK-15910 and rated it as
critical for 2.6. I was able to patch the code to work by adding quotes
around the field name, but I'm not sure how that would affect other DBs.
It seems like the field name should be changed.

David Adams

> -----Original Message-----
> From: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-
> bounces at collab.sakaiproject.org] On Behalf Of Adams, David
> Sent: Friday, March 20, 2009 3:01 PM
> To: Sakai Dev
> Subject: [Building Sakai] 2.6+Oracle: sakai_event_delay table missing
> 
> I just ran into a problem with 2.6 and Oracle, namely that the new
> sakai_event_delay table doesn't get created by auto.ddl. This was
> reported in http://bugs.sakaiproject.org/jira/browse/SAK-15805.
> 
> Apparently the SQL file responsible
> (content/content-impl-
> providers/impl/src/sql/oracle/sakai_event_delay.sq
> l) doesn't actually work on Oracle. The fix is to apply the
> sak-14939_oracle.diff patch from
> http://bugs.sakaiproject.org/jira/browse/SAK-14939. I see that this
fix
> has made it into trunk, but not 2.6.
> 
> Could someone put this fix into 2-6-x, please?
> 
> David Adams
> Director of Learning Systems Integration and Support
> Virginia Tech Learning Technologies
> 
> 
> _______________________________________________
> sakai-dev mailing list
> sakai-dev at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
> 
> TO UNSUBSCRIBE: send email to sakai-dev-
> unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"