[Building Sakai] 2.9.0 conversion hibernate_sequence exists

[Matthew Jones]

Yea, in the past we were trying to catch these and move them to their own
proper sequences. It involves setting a param name on the hibernate
generator in the xml file.

https://jira.sakaiproject.org/browse/CHK-28

I'm not paying as much attention to the Oracle files as I used to since
most (almost all) of my current clients are Mysql based. It should be filed
as a JIRA but would require a plsql conversion to fix it at this point so
probably won't get fixed. :/
https://jira.sakaiproject.org/browse/EVALSYS-803

The only real problem is with anything that tries to make use of it outside
of hibernate or migrating outside of this database could have problems with
everything being on this one sequence.


On Mon, Mar 25, 2013 at 4:47 PM, Joshua Swink <joshua.swink at gmail.com>wrote:

> The 2.9.0 oracle conversion script tries to create hibernate_sequence, but
> it already exists. This seems harmless. Is that correct?
>
> SQL> create sequence hibernate_sequence
> ERROR at line 1:
> ORA-00955: name is already used by an existing object
>
> This occurs in the lesson builder section ("Start Lesson Builder table
> creation (if no auto.ddl)").
>
> Josh
>
> _______________________________________________
> 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"
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20130325/89fef4c4/attachment.html