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

[Liu, Peter]

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"