Revision: 4645
Author: [email protected]
Date: Thu Dec 1 01:14:55 2011
Log: Created wiki page through web user interface.
http://code.google.com/p/openmeetings/source/detail?r=4645
Added:
/wiki/Configuration_Oracle.wiki
=======================================
--- /dev/null
+++ /wiki/Configuration_Oracle.wiki Thu Dec 1 01:14:55 2011
@@ -0,0 +1,97 @@
+#summary Documentation about Oracle
+
+_this feature is available since version 1.9.x (r4641)_
+
+== Before you start ==
+
+ * Download the latest JDBC Driver from Oracle for your database version.
Place those JARs into $Red5/webapps/openmeetings/WEB-INF/lib
+ * If you encounter issues, you can drop the db again and delete the file
$red5/webapps/openmeetings/conf/install.xml and then run the web based
installer again
+
+=== Steps todo ==
+ #
Rename<br/>$red5/webapps/openmeetings/WEB-INF/classes/META-INF/oracle_persistance.xml<br/>to<br/>$red5/webapps/openmeetings/WEB-INF/classes/META-INF/persistance.xml
+ # Prepare Database Settings - go to
openmeetings_version_no_xx/webapps/openmeetings/WEB-INF/classes/META-INF/persistance.xml
+ Alter config values in `persistance.xml` connectionURL, username and
password with your values
+ # Run red5-service and goto the web-based installer:
http://localhost:5080/openmeetings/install
+
+== Oracle Sample Configuration ==
+
+File for reference in the SVN:
+http://code.google.com/p/openmeetings/source/browse/trunk/singlewebapp/src/META-INF/oracle_persistence.xml
+{{{
+<?xml version="1.0" encoding="UTF-8"?>
+<!-- persistence.xml schema -->
+<persistence xmlns="http://java.sun.com/xml/ns/persistence";
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xsi:schemaLocation="http://java.sun.com/xml/ns/persistence
http://java.sun.com/xml/ns/persistence/persistence_2_0.xsd"; version="2.0">
+ <persistence-unit name="openmeetings" transaction-type="RESOURCE_LOCAL">
+
<provider>org.apache.openjpa.persistence.PersistenceProviderImpl</provider>
+
<class>org.openmeetings.app.persistence.beans.adresses.Adresses</class>
+
<class>org.openmeetings.app.persistence.beans.adresses.States</class>
+
<class>org.openmeetings.app.persistence.beans.basic.Configuration</class>
+
<class>org.openmeetings.app.persistence.beans.basic.ErrorType</class>
+
<class>org.openmeetings.app.persistence.beans.basic.ErrorValues</class>
+
<class>org.openmeetings.app.persistence.beans.basic.LdapConfig</class>
+
<class>org.openmeetings.app.persistence.beans.basic.Naviglobal</class>
+
<class>org.openmeetings.app.persistence.beans.basic.Navimain</class>
+
<class>org.openmeetings.app.persistence.beans.basic.Navisub</class>
+
<class>org.openmeetings.app.persistence.beans.basic.OmTimeZone</class>
+
<class>org.openmeetings.app.persistence.beans.basic.Sessiondata</class>
+
<class>org.openmeetings.app.persistence.beans.basic.SOAPLogin</class>
+
<class>org.openmeetings.app.persistence.beans.calendar.Appointment</class>
+
<class>org.openmeetings.app.persistence.beans.calendar.AppointmentCategory</class>
+
<class>org.openmeetings.app.persistence.beans.calendar.AppointmentReminderTyps</class>
+
<class>org.openmeetings.app.persistence.beans.calendar.MeetingMember</class>
+
<class>org.openmeetings.app.persistence.beans.domain.Organisation</class>
+
<class>org.openmeetings.app.persistence.beans.domain.Organisation_Users</class>
+
<class>org.openmeetings.app.persistence.beans.flvrecord.FlvRecording</class>
+
<class>org.openmeetings.app.persistence.beans.flvrecord.FlvRecordingLog</class>
+
<class>org.openmeetings.app.persistence.beans.flvrecord.FlvRecordingMetaData</class>
+
<class>org.openmeetings.app.persistence.beans.flvrecord.FlvRecordingMetaDelta</class>
+
<class>org.openmeetings.app.persistence.beans.invitation.Invitations</class>
+
<class>org.openmeetings.app.persistence.beans.lang.FieldLanguage</class>
+
<class>org.openmeetings.app.persistence.beans.lang.Fieldlanguagesvalues</class>
+
<class>org.openmeetings.app.persistence.beans.lang.Fieldvalues</class>
+
<class>org.openmeetings.app.persistence.beans.logs.ConferenceLog</class>
+
<class>org.openmeetings.app.persistence.beans.logs.ConferenceLogType</class>
+
<class>org.openmeetings.app.persistence.beans.poll.PollType</class>
+
<class>org.openmeetings.app.persistence.beans.poll.RoomPoll</class>
+
<class>org.openmeetings.app.persistence.beans.poll.RoomPollAnswers</class>
+
<class>org.openmeetings.app.persistence.beans.recording.ChatvaluesEvent</class>
+
<class>org.openmeetings.app.persistence.beans.recording.Recording</class>
+
<class>org.openmeetings.app.persistence.beans.recording.RecordingClient</class>
+
<class>org.openmeetings.app.persistence.beans.recording.RecordingConversionJob</class>
+
<class>org.openmeetings.app.persistence.beans.recording.RoomClient</class>
+
<class>org.openmeetings.app.persistence.beans.recording.RoomRecording</class>
+
<class>org.openmeetings.app.persistence.beans.recording.RoomStream</class>
+
<class>org.openmeetings.app.persistence.beans.recording.WhiteBoardEvent</class>
+
<class>org.openmeetings.app.persistence.beans.rooms.RoomModerators</class>
+
<class>org.openmeetings.app.persistence.beans.rooms.Rooms</class>
+
<class>org.openmeetings.app.persistence.beans.rooms.RoomTypes</class>
+
<class>org.openmeetings.app.persistence.beans.rooms.Rooms_Organisation</class>
+
<class>org.openmeetings.app.persistence.beans.sip.OpenXGReturnObject</class>
+
<class>org.openmeetings.app.persistence.beans.user.PrivateMessages</class>
+
<class>org.openmeetings.app.persistence.beans.user.PrivateMessageFolder</class>
+
<class>org.openmeetings.app.persistence.beans.user.Salutations</class>
+
<class>org.openmeetings.app.persistence.beans.user.UserContacts</class>
+
<class>org.openmeetings.app.persistence.beans.user.Userdata</class>
+
<class>org.openmeetings.app.persistence.beans.user.Usergroups</class>
+
<class>org.openmeetings.app.persistence.beans.user.Userlevel</class>
+
<class>org.openmeetings.app.persistence.beans.user.Users_Usergroups</class>
+
<class>org.openmeetings.app.persistence.beans.user.UserSipData</class>
+ <class>org.openmeetings.app.persistence.beans.user.Users</class>
+
<class>org.openmeetings.app.persistence.beans.files.FileExplorerItem</class>
+ <exclude-unlisted-classes>false</exclude-unlisted-classes>
+ <properties>
+ <property name="openjpa.RuntimeUnenhancedClasses"
value="supported"/>
+ <property name="openjpa.ConnectionDriverName"
value="oracle.jdbc.driver.OracleDriver"/>
+ <property name="openjpa.ConnectionProperties" value="username=SYSTEM,
password=admin"/>
+ <property name="openjpa.ConnectionURL"
value="jdbc:oracle:thin:@localhost:1521:openmeetings"/>
+ <property name="openjpa.jdbc.SynchronizeMappings"
value="buildSchema"/>
+ <property name="openjpa.Log" value="DefaultLevel=WARN,
Tool=INFO" />
+ <property name="openjpa.DataCache" value="true"/>
+ <property name="openjpa.QueryCache" value="true"/>
+ <property name="openjpa.jdbc.DBDictionary"
value="BatchLimit=100" />
+ <property name="openjpa.jdbc.DBDictionary"
value="oracle(UseTriggersForAutoAssign=true, MaxAutoAssignNameLength=28,
BatchLimit=100)" />
+ <property name="openjpa.jdbc.QuerySQLCache"
value="false"/>
+ </properties>
+ </persistence-unit>
+</persistence>
+}}}
--
You received this message because you are subscribed to the Google Groups
"OpenMeetings developers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/openmeetings-dev?hl=en.
