you MUST 1) update persistence.xml file with valid DB connection information host/port/DB name/user/pass 2) put valid jar file with DB drivers of your choice ro webapps/openmeetings/WEB-INF/lib
that it On Sat, Apr 11, 2015 at 2:41 AM, Susheel Jalali < [email protected]> wrote: > 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&useUnicode=true&createDatabaseIfNotExist=true& > amp;characterEncoding=utf-8&connectionCollation=utf8_ > general_ci&cachePrepStmts=true&cacheCallableStatements=true& > amp;cacheServerConfiguration=true&useLocalSessionState= > true&elideSetAutoCommits=true&alwaysSendSetIsolation=false& > amp;enableQueryTimeouts=false&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> > > -- WBR Maxim aka solomax
