[gradebook2-dev] correct oracle conversion sql?

[Thomas Amsler]

I forgot to add that we already have a JIRA for this:

http://jira.sakaiproject.org/browse/GRBK-735

I will document in there as we start cleaning things up.

-- Thomas

On Tue, Oct 12, 2010 at 12:12 AM, Thomas Amsler <tpamsler at ucdavis.edu>wrote:

> 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/d30d23ec/attachment.html