[Building Sakai] Melete 2.9 Oracle issue (w/ possible fix)

[Adams, David]

I just wanted to alert anyone using Melete 2.9 and Oracle, that there's a SQL statement with a MySQL-only keyword in ModuleDB.java as of 2.9 that prevented at least some functionality from working. The tell-tale log statement, for what it's worth, was "java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected". The "fix" such as it is was to remove the "straight_join" keyword from two SQL statements in ModuleDB.java. Since Melete is not in the community JIRA, I'm reporting this here and attaching the patch we've used to address the problem.

-dave
-------------- next part --------------
A non-text attachment was scrubbed...
Name: remove-straight-join-from-moduledb.patch
Type: text/x-patch
Size: 4065 bytes
Desc: remove-straight-join-from-moduledb.patch
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130405/33e79d83/attachment.bin