[Building Sakai] auto.ddl failed on Oracle DB for 2.9

[Liu, Peter]

I have also tried to use Sakai 2.8.x source code to against the Oracle 11g.  It has the same issue like Sakai 2.9 (trunk) and only the same partial tables are created by auto.ddl.  Strange thing is that the table's sequences are created successfully.  I have attached the info about what tables, sequences, indexes are created.  The bad thing is that it goes silently during the table-creation and until it hits the 'table or view not exists' error as you mentioned below.

Have anyone successfully used auto.ddl against 11g?  Could be some privilege issue on the Database to prevent something to happen?  So far, there is no error on Database log file.

Thanks a lot!
Peter

-----Original Message-----
From: Jean-Francois Leveque [mailto:jean-francois.leveque at upmc.fr] 
Sent: Friday, September 23, 2011 5:57 AM
To: Liu, Peter
Cc: Maurer, Christopher Wayne; sakai-dev Dev
Subject: Re: [Building Sakai] auto.ddl failed on Oracle DB for 2.9

Peter,

I think the first worrying log is:

2011-09-22 11:35:13,952  WARN Thread-2 
org.sakaiproject.springframework.orm.hibernate.AddableSessionFactoryBean 
- Unsuccessful schema statement: comment on table ASN_SUP_ATTACH_T is 
'This table is for assignment supplement item attachment.'
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Chris,

SVN trunk on Oracle 10g (trunk/sakai) tomcat log is not showing the 
errors Peter has. Is it still 10G or 11G already?

There is an error with dav.war deploying.

Cheers,

J-F

On 22/09/2011 18:16, Liu, Peter wrote:
> Please see the log error messages as attached file. Hope it will help.
>
> Thanks,
>
> Peter
>
> *From:*Maurer, Christopher Wayne [mailto:chmaurer at iupui.edu]
> *Sent:* Thursday, September 22, 2011 12:08 PM
> *To:* Liu, Peter; sakai-dev Dev
> *Subject:* Re: [Building Sakai] auto.ddl failed on Oracle DB for 2.9
>
> Peter,
>
> I don't suppose there's anything useful in the logs, is there?
>
> The nightly instance is having the DB upgraded to Oracle 11G this
> afternoon, so we'll know soon enough if there are other problems!
>
> Chris
>
> *From: *"Liu, Peter" <peter.liu at yale.edu <mailto:peter.liu at yale.edu>>
> *Date: *Thu, 22 Sep 2011 16:04:19 +0000
> *To: *sakai-dev Dev <sakai-dev at collab.sakaiproject.org
> <mailto:sakai-dev at collab.sakaiproject.org>>
> *Subject: *[Building Sakai] auto.ddl failed on Oracle DB for 2.9
>
> Hi all,
>
> I am trying to set up a Sakai 2.9 (trunk code) on Tomcat 7.x. I have
> problem with the auto.ddl on Oracle DB. Some tables are not
> automatically created such as tables for Chat2. It works perfect on
> Mysql DB.
>
> Is this a known issue on Oracle 11g on auto.ddl?
>
> Thanks a lot!
>
> Peter
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: indexes.txt
Url: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110923/34d377fd/attachment.txt 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: sequences.txt
Url: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110923/34d377fd/attachment-0001.txt 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: tables.txt
Url: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110923/34d377fd/attachment-0002.txt