[Building Sakai] Oracle database for sakai

[DAVID ROLDAN MARTINEZ]

Hi Mathieu,

We are running Sakai under Oracle. If you send me a list of the issues you want to know, I can forward it to our DBA.

David

De: sakai-dev-bounces at collab.sakaiproject.org [mailto:sakai-dev-bounces at collab.sakaiproject.org] En nombre de Mathieu Cantin
Enviado el: lunes, 16 de noviembre de 2009 15:18
Para: Seth Theriault
CC: sakai-dev at collab.sakaiproject.org List
Asunto: Re: [Building Sakai] Oracle database for sakai

Thanks for the info.  My concerns are more about the database creation parameters as sakai creates its own schema into the database at tomcat first startup.  What I want to know is what is the ideal database size.  We are using a profile similar to the mini one so there is about 96 tables.  Maybe I would have to calculate the tables fields and indexes to approximate the size and I would also ask to use utf8 character set.  Is that waht you did prior to database creation?

Thank you very much.

Mathieu

-------- Message original --------
Sujet : Re: [Building Sakai] Oracle database for sakai
De : Seth Theriault <slt at columbia.edu><mailto:slt at columbia.edu>
Pour : Steve Swinsburg <steve.swinsburg at gmail.com><mailto:steve.swinsburg at gmail.com>
Copie à : Mathieu Cantin <mathieu.cantin at hec.ca><mailto:mathieu.cantin at hec.ca>, "sakai-dev at collab.sakaiproject.org List"<mailto:sakai-dev at collab.sakaiproject.orgList> <sakai-dev at collab.sakaiproject.org><mailto:sakai-dev at collab.sakaiproject.org>
Date : 2009-11-13 17:29


Steve Swinsburg wrote:





If you are using Oracle 11g, I have heard the connection string

needs to be changed.





If you are running Oracle 9i instead of 10g, you need to use this

setting for hibernate.dialect:



hibernate.dialect=org.hibernate.dialect.Oracle9iDialect



Seth



_______________________________________________

sakai-dev mailing list

sakai-dev at collab.sakaiproject.org<mailto: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<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"





-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20091127/f2fb00a5/attachment.html