[Building Sakai] conversion scripts

[Matthew Jones]

Though not *everyone* runs the scripts the pl/sql, and that has never been
a requirement in the past. I've routinely ran Oracle scripts through
Oracle's SQL Developer or even Hen Plus, as it's often more convenient than
having the full sqlplus installed available.

Though if it was documented what software needs to be used to run the
scripts and it's something that's widely available that could be okay. We
generally some difficulty in the community getting anyone to verify and
update the Oracle scripts as-is. Generally it falls on Michigan, IU or some
other developer watching the trunk nightly logs. At the moment looking at
the logs there are a variety of oracle errors

4 x java.sql.SQLException: ORA-00955: name is already used by an existing object

7 x java.sql.SQLException: ORA-01408: such column list already indexed

I used to keep updated with this at Michigan and I know Seth also looked at
this, but most of my interest is in MySQL now, so it would be for whoever
uses Oracle to decide and keep this up-to-date.


On Fri, Jun 14, 2013 at 7:04 PM, Steve Swinsburg
<steve.swinsburg at gmail.com>wrote:

> Oracle doesn't support the 'if not exists' syntax however the create table
> statement could be wrapped in a pl/SQL block and the error trapped, so that
> it doesn't fail the script. It's only a few extra lines.
>
> Cheers
> Steve
>
> Sent from my iPhone
>
> On 14/06/2013, at 22:24, Aaron Zeckoski <azeckoski at unicon.net> wrote:
>
> > That is mysql 5.1 documentation that you referenced. Oracle (the
> > company) owns mysql now but that doesn't mean oracle database (the
> > product) has the same syntax rules.
> >
> > This is a link to the oracle database documentation for create table:
> >
> http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_7002.htm
> >
> > As I mentioned, oracle database does not support this "if not exists"
> syntax.
> > -AZ
> >
> >
> > On Fri, Jun 14, 2013 at 7:43 AM, Nguni Phakela <nguni52 at gmail.com>
> wrote:
> >> I checked this documentation also to see if it will work on oracle
> >> http://docs.oracle.com/cd/E17952_01/refman-5.1-en/create-table.htmland from
> >> what is written there it seems that it would also work for oracle,
> unless
> >> They haven't updated the documentation or I read the wrong version of
> the
> >> documentation.
> >>
> >>
> >>
> >>
> >> On Fri, Jun 14, 2013 at 1:38 PM, Aaron Zeckoski <azeckoski at unicon.net>
> >> wrote:
> >>>
> >>> That kind of syntax only works in MySQL (or a few others like MSSQL)
> >>> so I guess you are suggesting we do this for the MySQL scripts only.
> >>> I'm not sure why this would be needed and I am not sure we want to
> >>> support differences in the scripts like this (it is extra effort over
> >>> time since the behavior is no longer the same)?
> >>>
> >>> The scripts are stored in the code itself in
> reference/docs/conversion/.
> >>>
> >>> -AZ
> >>>
> >>>
> >>> On Fri, Jun 14, 2013 at 7:09 AM, Nguni Phakela <nguni52 at gmail.com>
> wrote:
> >>>> Hi All,
> >>>>
> >>>> Is it possible that we can change the conversion scripts such that the
> >>>> ones
> >>>> about creating tables have a IF NOT EXISTS part to them. I can
> >>>> definitely do
> >>>> this if anyone can let me know how I can update those pages and
> everyone
> >>>> is
> >>>> in agreement.
> >>>>
> >>>> Kind Regards,
> >>>>
> >>>> --
> >>>> Nguni Phakela
> >>>>
> >>>> _______________________________________________
> >>>> 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"
> >>>
> >>>
> >>>
> >>> --
> >>> Aaron Zeckoski - Software Architect - http://tinyurl.com/azprofile
> >>
> >>
> >>
> >>
> >> --
> >> Nguni Phakela
> >
> >
> >
> > --
> > Aaron Zeckoski - Software Architect - http://tinyurl.com/azprofile
> > _______________________________________________
> > 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"
> _______________________________________________
> 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/20130717/5f3d259f/attachment.html