[Building Sakai] Sequence Name for Lit-2.1.2 Oracle DB

Liu, Peter peter.liu at yale.edu
Thu Mar 13 14:37:46 PDT 2014


Hi,

I am trying to upgrade our Lti 1.3 to Lti 2.1.2 version and have some issues with the sequence for these three LTI tables in Oracle Database as attached.

Since I cannot turn on the 'auto.ddl = true' on our Oracle DB, there is no way for me to find out what the Sequence-name is for the tables.

Does anyone know what the Sequence name for these three table's ID?  Then I can create these SEQs in Oracle DB.

Thanks a lot!
Peter


#####  error log #############
When I try to add one external tool info via External Tool UI page:

at org.sakaiproject.blti.tool.LTIAdminTool.doToolPut(LTIAdminTool.java:534)
        ... 48 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140313/e8d7e0c6/attachment.html 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: Lti_2.1.2_createTablesScriptOracle.sql.txt
Url: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20140313/e8d7e0c6/attachment.txt 


More information about the sakai-dev mailing list