[
https://issues.apache.org/jira/browse/OPENMEETINGS-488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13528865#comment-13528865
]
Mikael Kurula commented on OPENMEETINGS-488:
--------------------------------------------
I don't seem to find the attach button, maybe because the issue is closed. So
here comes the persistence.xml file in plain text then:
<?xml version="1.0" encoding="UTF-8"?>
<!--
Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements. See the NOTICE file
distributed with this work for additional information
regarding copyright ownership. The ASF licenses this file
to you under the Apache License, Version 2.0 (the
"License"); you may not use this file except in compliance
with the License. You may obtain a copy of the License at
http://www.apache.org/licenses/LICENSE-2.0
Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
-->
<!-- 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.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.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.Userlevel</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>
<class>org.openmeetings.app.persistence.beans.sip.asterisk.AsteriskSipUsers</class>
<class>org.openmeetings.app.persistence.beans.sip.asterisk.Extensions</class>
<class>org.openmeetings.app.persistence.beans.sip.asterisk.MeetMe</class>
<exclude-unlisted-classes>false</exclude-unlisted-classes>
<properties>
<property name="openjpa.RuntimeUnenhancedClasses"
value="unsupported"/>
<property name="openjpa.ConnectionDriverName"
value="org.apache.commons.dbcp.BasicDataSource" />
<property name="openjpa.ConnectionProperties"
value="DriverClassName=com.mysql.jdbc.Driver
,
Url=jdbc:mysql://localhost:3306/openmeetings?autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8&connectionCollation=utf8_general_ci&cachePrepStmts=true&cacheCallableStatements=true&cacheServerConfiguration=true&useLocalSessionState=true&elideSetAutoCommits=true&alwaysSendSetIsolation=false&enableQueryTimeouts=false&prepStmtCacheSize=3000&prepStmtCacheSqlLimit=1000
, MaxActive=100
, MaxWait=10000
, TestOnBorrow=true
, poolPreparedStatements=true
, Username=openmeetings
, Password=XXX"/>
<property name="openjpa.jdbc.SynchronizeMappings"
value="buildSchema"/>
<property name="openjpa.Log" value="DefaultLevel=WARN,
Tool=INFO" />
<property name="openjpa.DataCache" value="true"/>
<!-- QueryCache disabled due to changes outside of JPA
doesn't take effect with caching -->
<property name="openjpa.QueryCache" value="false"/>
<property name="openjpa.jdbc.DBDictionary"
value="batchLimit=100,tableType=myisam"/>
<property name="openjpa.jdbc.QuerySQLCache"
value="false"/>
</properties>
</persistence-unit>
</persistence>
> MySQL timeouts
> --------------
>
> Key: OPENMEETINGS-488
> URL: https://issues.apache.org/jira/browse/OPENMEETINGS-488
> Project: Openmeetings
> Issue Type: Bug
> Affects Versions: 2.0 Apache Incubator Release
> Reporter: Mikael Kurula
>
> I sometimes run into problems with MySQL timeouts because of inactivity
> overnight, getting the following error message in the openmeetings.log:
> Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last
> packet successfully received from the server was 90,881,924 milliseconds ago.
> The last packet sent successfully to the server was 90,881,924 milliseconds
> ago. is longer than the server configured value of 'wait_timeout'. You should
> consider either expiring and/or testing connection validity before use in
> your application, increasing the server configured values for client
> timeouts, or using the Connector/J connection property 'autoReconnect=true'
> to avoid this problem.
> I don't know if it is related or not, but these errors showed up when I
> finished a test recording. Then when I tried to go and watch the recording, I
> only get "The recording is not yet ready for watching" and it seems the
> recording didn't consume any disk space.
> I posted this to the openmeetings-user list, and got the following response
> from another user: "There is a connection between this error (or info) and
> recording and sharing of the OM (or I guess like that). I have the same
> problem on recordings and I am taking same response about com.mysql.jdbc...
> kind of reports from the system. I have also checked that
> "autoReconnect=true" option is already given on the connection string and
> also checked the permission or the connection of mysql server but could not
> find a proper solution. Is there a bit more specific information about error
> message?"
> By googling I found these discussions:
> http://wiki.pentaho.com/display/ServerDoc2x/Configuring+for+MySQL
> http://www.coderanch.com/t/564390/Tomcat/CommunicationsException-tomcat-mysql
> I would assume this is the problem. Can the solution outlined in the first
> link solve the problem for OM as well?
> After a while Solomax chimed in with: "We are using OpenJPA (not Hibernate)
> and already have "TestOnBorrow=true" and DB connection pool :(
> not sure what else can be done ... Never saw such exception on my machines :("
> If it's of any help, then I'm using a CentOS 6 server with the following
> version of mysql:
> mysql Ver 14.14 Distrib 5.1.66, for redhat-linux-gnu (x86_64) using readline
> 5.1
> My version of openmeetings is this:
> apache-openmeetings-incubating-2.0.0.r1361497-14-07-2012_1108.tar.gz
> ... and the version of the J connector is mysql-connector-java-5.1.22.tar.gz.
> For the time being I'll try to work around this by switching back to Derby. I
> don't expect a very heavy load and I don't need to query the database while
> OM is running.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
