Revision: 4319
Author: [email protected]
Date: Thu Sep 29 10:17:16 2011
Log: Edited wiki page Configuration_IBM_DB2 through web user interface.
http://code.google.com/p/openmeetings/source/detail?r=4319
Modified:
/wiki/Configuration_IBM_DB2.wiki
=======================================
--- /wiki/Configuration_IBM_DB2.wiki Thu Sep 29 06:09:17 2011
+++ /wiki/Configuration_IBM_DB2.wiki Thu Sep 29 10:17:16 2011
@@ -4,15 +4,93 @@
== Database Setup ==
-Tested IBM DB2 Express-C 9.7.xx:
+_Tested with IBM DB2 Express-C 9.7.x_
Get the IBM Data Server Driver for JDBC and SQLJ from IBM website:
https://www14.software.ibm.com/webapp/iwm/web/preLogin.do?source=swg-idsdjs
-Copy JDBC driver xyz.JAR to WEB-INF/lib/
-
-Create database for !OpenMeetings:
-http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=%2Fcom.ibm.db2.udb.admin.doc%2Fdoc%2Fr0000929.htm
-
-Todo: Check param: AppendExtendedExceptionText
-
-== DB Sample Configuration ==
+Copy JDBC driver db2jcc4.jar to webapps/openmeetings/WEB-INF/lib/
+
+Create database for !OpenMeetings using a pagesize bigger or equal 8K,
sample query_
+CREATE DATABASE openmeet AUTOMATIC STORAGE YES ON 'C:' DBPATH ON 'C:'
USING CODESET UTF-8 TERRITORY DE COLLATE USING System PAGESIZE 16 K
+
+== DB2 Sample Configuration ==
+
+see for a current up-to date mapping:
+http://code.google.com/p/openmeetings/source/browse/trunk/singlewebapp/src/META-INF/db2_persistence.xml
+
+replace user/db/pass/port with your values of course!
+
+{{{
+<?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.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="com.ibm.db2.jcc.DB2Driver"/>
+ <property name="openjpa.ConnectionProperties" value="username=db2admin,
password=admin"/>
+ <property name="openjpa.ConnectionURL"
value="jdbc:db2://localhost:50000/openmeet"/>
+ <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.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.
