[gradebook2-dev] correct oracle conversion sql?

[Thomas Amsler]

Steve,

Ok makes sense. I have seen this happen before once or twice. I will get
back to you in a couple of days regarding the proper Install instructions
w.r.t. SQL.

Best,
-- Thomas

On Mon, Oct 11, 2010 at 5:50 PM, Steve Jaegle <sjaegle at mail.uri.edu> wrote:

> Hi Thomas:
>
> In my experience auto.ddl=true does not always work properly, though I have
> never taken the time to investigate why and how in our Oracle database. I
> have seen it produce incomplete changes or an incomplete database on at
> least two or three occasions; one of those times the database came up 14
> tables short.  Knowing which file is the correct one allows me to make sure
> the changes have happened correctly.
>
> Thanks,
>
> Steve
>
> On Fri, 8 Oct 2010 17:33:53 -0700, Thomas Amsler <tpamsler at ucdavis.edu>
> wrote:
> > Stephen,
> >
> >
> >
> > If you start with v1.3.0 and you are not upgrading from an earlier
> version, then you don't need to run any conversion scripts. You would just
> set "auto.ddl=true" in sakai.properties so that all the gradebook2 related
> tables are created.
> >
>
> >
> >
> >
> > Best,
> >
> > -- Thomas
> >
> >
> > On Fri, Oct 8, 2010 at 5:07 PM, Stephen Jaegle  < sjaegle at mail.uri.edu >
>  wrote:
> >
>  Hi Folks:
> >
>
> >
> I have downloaded the gradebook2 1.3.0 tag and in the process of
> >
> preparing it for our Sakai 2.6.x/Oracle environment I notice that
> >
> there are two slightly different oracle database conversion sqls. I do
> >
> not have any earlier version installed.
> >
>
> >
> tags/1.3.0/sakai/2-6-x/INSTALL.txt refers to client/src/sql/oracle/gb-
> >
> datamodel-changes.sql, which does not seem to  exist, but there is a
> >
> client/src/sql/oracle/sakai_gradebook2.sql which will do the job. So
> >
> far so good, but there is also sakai/2-6-x/sql/oracle/
> >
> sakai_gradebook2.sql, which is similar, but not the same. Based on
> >
> looking at the svn logs, diffing the files and greping about, it looks
> >
> like the sakai/2-6-x version is the one to go with, rather than the
> >
> client/src one.
> >
>
> >
> Please let me know if I'm wrong. If I am right I would be happy to
> >
> update INSTALL.txt, but I don't  know where or to whom to submit it.
> >
>
> >
> Thanks,
> >
>
> >
> Steve
> >
>
> >
>
> >
>
> >
>
> >
>
> >
> _______________________________________________
> >
> gradebook2-dev mailing list
> >
>  gradebook2-dev at collab.sakaiproject.org
> >
>  http://collab.sakaiproject.org/mailman/listinfo/gradebook2-dev
> >
>
> >
> >
> >
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/gradebook2-dev/attachments/20101012/2890f2c3/attachment-0001.html