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

[Liu, Peter]

Hi,

We have finally made the audo.ddl working on Oracle 11.2g database for Sakai 2.9.  The problem for us is that the user's privilege has too much than too few.  

Our db-access user-account has been assigned with a 'Developer' role, which allows the user_account to have a 'select' access to all other DB-Schemas in the database as well.  Since we have another sakai26-schema running on the same database, this causes the confusion and let it thinking that the tables are already existed.  That is why the tables are not created in this new Schema.

Now, everything are working fine.  I hope this might help others in the future.

Thanks,
Peter liu

-----Original Message-----
From: Liu, Peter 
Sent: Friday, September 23, 2011 2:05 PM
To: Liu, Peter; Maurer, Christopher Wayne; Seth Theriault
Cc: sakai-dev Dev
Subject: RE: [Building Sakai] auto.ddl failed on Oracle DB for 2.9

I have some progress on Oracle 11g.  I have downloaded the Oracle 11gExpress for Windows and installed on my local machine.  It works fine with tables-creation via auto.ddl.

I am thinking it might be possible that the our Oracle 11g Enterprise Edition setup is somehow not allowed to execute the table-creation via auto.ddl smoothly.

Thanks a lot!
Peter

-----Original Message-----
From: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] On Behalf Of Liu, Peter
Sent: Friday, September 23, 2011 11:11 AM
To: Maurer, Christopher Wayne; Seth Theriault
Cc: sakai-dev Dev
Subject: Re: [Building Sakai] auto.ddl failed on Oracle DB for 2.9

I have turned on the auto.ddl=true.  It is using the:
hibernate.dialect=org.hibernate.dialect.Oracle10gDialect

I have used the odjbc6.jar since it is running on Java 6.

Thanks,
Peter

-----Original Message-----
From: Maurer, Christopher Wayne [mailto:chmaurer at iupui.edu] 
Sent: Friday, September 23, 2011 10:37 AM
To: Maurer, Christopher Wayne; Seth Theriault; Liu, Peter
Cc: sakai-dev Dev
Subject: Re: [Building Sakai] auto.ddl failed on Oracle DB for 2.9

You might also want to make sure you are using a reasonable up-to-date
driver.
Looks like the one on nightly is 10.2.0.3.0, so probably not the newest.

Chris

On 9/23/11 10:27 AM, "Maurer, Christopher Wayne" <chmaurer at iupui.edu>
wrote:

>Nightly uses this:
>hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
>
>
>Chris
>
>On 9/23/11 10:12 AM, "Seth Theriault" <slt at columbia.edu> wrote:
>
>>Liu, Peter wrote:
>>
>>> I have also tried to use Sakai 2.8.x source code to against
>>> the Oracle 11g.
>>
>>What hibernate.dialect setting are you using in
>>sakai.properties? I seem to recall some issues with Oracle 11
>>because it doesn't really have its own dialect....
>>
>>Seth
>>
>>_______________________________________________
>>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"

_______________________________________________
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"