Re: OpenMeetings 3.0.5 Installation Failed

Fri, 10 Apr 2015 13:45:45 -0700 

Dear Maxim,
Based on the following two links (http://stackoverflow.com/questions/26063219/how-to-connect-openjpa-spring-and-postgresql, http://grepcode.com/file/repo1.maven.org/maven2/org.apache.openjpa/openjpa-slice/2.3.0/META-INF/persistence.xml), we have found potential cause of the following issues. It relates to interface between OpenMeetings and RDBMS. 

Problems

   ·OM 3.0.5.r1670841-02-04-2015_0849 is failing during installation
   (when we click "FINISH" after Web install):

   org.springframework.transaction.CannotCreateTransactionException: Could not open JPA EntityManager for 
transaction; nested exception is <openjpa-2.3.0-r422266:1540826 fatal user error> 
org.apache.openjpa.persistence.ArgumentException: A connection could not be obtained for driver class 
"org.apache.commons.dbcp.BasicDataSource" and URL "null".  You may have specified an 
invalid URL.

 
   Caused by: <openjpa-2.3.0-r422266:1540826 fatal user error> org.apache.openjpa.persistence.ArgumentException: A connection could not be obtained for driver class "org.apache.commons.dbcp.BasicDataSource" and URL "null".  You may have specified an invalid URL.

        at 
org.apache.openjpa.jdbc.schema.DataSourceFactory.newConnectException(DataSourceFactory.java:255)

Error 2:


Caused by: java.lang.ClassNotFoundException: 
org.apache.commons.dbcp.BasicDataSource
at 
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1720)


   ·OM 3.0.4 with MariaDB does not show drives (public, home) in the
   left pane of File Explorer


Causes

*Cause 1:  In the directory **dist/red5/webapps/openmeetings/WEB-INF/lib/
***

   ·OM 3.0.4 instance has commons-dbcp-jar-1.4.jar

   ·OM 3.0.5 instance has commons-dbcp2-jar-2.1.jar


Does this have any implication on our installation of OM 3.0.5 failing 
in CentOS 7, Java 7u76 and MariaDB?



*Cause 2:  There is not mariadb.persistence.xml in 
dist/red5/webapps/openmeetings/WEB-INF/classes/META-INF directory*



Should we create a “mariadb.persistence.xml” file with configuration 
parameters that connects OpenJPA, Spring and MariaDB?  Could you provide 
us the following information so that we could create it?**



(1)Should we need to use enhanced OpenJPA Runtime Classes:  <property 
name="openjpa.RuntimeUnenhancedClasses" value="unsupported" />?


(2)We changed DriverClassName

From

value="DriverClassName=com.MYSQL.jdbc.Driver

to

value="DriverClassName=com.MARIADB.jdbc.Driver

When recompiled, it gave ONE MORE ADDITIONAL error:Caused by: 
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 
'com.mariadb.jdbc.Driver'


(3)Should we add this string to “value=…” of DriverClassName.  Only 
MySQL.persistence.xml has this string. Other *.persistence.xml files do 
not have it.


autoReconnect=true&amp;useUnicode=true&amp;createDatabaseIfNotExist=true&amp;characterEncoding=utf-8&amp;connectionCollation=utf8_general_ci&amp;cachePrepStmts=true&amp;cacheCallableStatements=true&amp;cacheServerConfiguration=true&amp;useLocalSessionState=true&amp;elideSetAutoCommits=true&amp;alwaysSendSetIsolation=false&amp;enableQueryTimeouts=false&amp;prepStmtCacheSize=3000&amp;prepStmtCacheSqlLimit=1000

(4)Should we add these parameters to the two property names:

<property name="openjpa.QueryCache" value="false" />

<property name="openjpa.jdbc.DBDictionary" value="batchLimit=100" />


Thank you.

Sincerely,

Susheel Jalali

Customer Operations Leader,

Coscend Communications Solutions


Elite Premio Complex Suite 200 Survey No 7 & 8 Balewadi Pune 411045 
Maharashtra India


Cell +91-9011000233

[email protected]_


Web site:www.CoscendCommunications.com 
<http://www.coscendcommunications.com/>


------------------------------------------------------------------

*Coscend’s**Software Service Factory*


"*Coscend Communications* is ... *pioneering a new approach*to ... 
software applications development, and systems integration."


*Light Reading Network, *December, 2007


"*Coscend*is at the*vanguard of a new evolution*in telco OSS/BSS systems 
integration."


*Caroline Chappell*
A leading authority in the communications services software industry


"There are *innovative*…*tools*from ... *Coscend *bubbling up, which 
will help accelerate the data consolidation process and reduce its cost."


*Dennis Mendyk, */Editor,/Building a *Telco Service Factory*

------------------------------------------------------------------


CONFIDENTIALITY NOTICE: See 'Confidentiality Notice Regarding E-mail 
Messages from Coscend Communications Solutions' posted at: 
http://www.CoscendCommunications.com/Terms_and_Conditions.html 
<http://www.coscendcommunications.com/Terms_and_Conditions.html>
























					Reply via email to