Re: [xwiki-users] database related issue while upgrading to the brand new 7.0 release

wrote:

________________________________ De: Vincent Massol [vmassol(a)gmail.com] en nombre de vincent(a)massol.net [ vincent(a)massol.net] Enviado: jueves, 02 de abril de 2015 13:09 Para: XWiki Users CC: Rodriguez Fernandez, Ricardo Julio Asunto: Re: [xwiki-users] database related issue while upgrading to the brand new 7.0 release On 2 Apr 2015 at 12:57:48, ricardo.julio.rodriguez.fernandez(a)sergas.es ( ricardo.julio.rodriguez.fernandez(a)sergas.es(mailto: ricardo.julio.rodriguez.fernandez(a)sergas.es)) wrote: version 5.1.28 works? Yes, this is at least what is happening here. The upgrade process seems to have been correctly completed. Here the log records I can see in when I shutdown and restart Tomcat with 5.1.28 on place... http://atriumkm.idisantiago.es/bin/download/ICT/XWikiUpgradeIssues/tomcatEr… "memory leak" is a word combination that affrighting me! Please, let me know if and how I could be of any futher help! Cheers, Ricardo that we can put it on the XWiki MySQL document page... vincent(a)massol.net] brand new 7.0 release 11.2.0.2.0 with ojdbc6.jar and it worked fine! :) since ojdbc6 doesn’t support JDBC 4.1 according to: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-0902… > Thanks > -Vincent > On 2 Apr 2015 at 10:22:05, vincent(a)massol.net (vincent(a)massol.net (mailto:vincent@massol.net)) wrote: > > Hi Ricardo, > > > We realized, after the release of XWiki 7.0 that due to our upgrade of DBCP to version 2.1 we’ve introduced a new requirement: JDBC 4 (I’m not sure if we require JDBC 4.0 or 4.1 actually, still trying to find out). http://www.xwiki.org/xwiki/bin/view/ReleaseNotes/ReleaseNotesXWiki70#HIssue… http://www.xwiki.org/xwiki/bin/view/ReleaseNotes/ReleaseNotesXWiki70#HIssue… ) > http://www.xwiki.org/xwiki/bin/view/ReleaseNotes/ReleaseNotesXWiki70#HIssue… ) JDBC4 compliant and version 5.1.x certainly are too. > > > Thomas has just tested XWiki 7.0 on MySQL with version 5.1.28 and it was working fine for him. > > > The error you get is strange. ATM I don’t understand it. We’re going to do more tests on various DBs to see whether we need to rollback the DBCP upgrade or not. > > > Stay tuned. > > > Sorry about the problem > > > Thanks > > -Vincent > > > On 2 Apr 2015 at 09:39:45, ricardo.julio.rodriguez.fernandez(a)sergas.es (ricardo.julio.rodriguez.fernandez(a)sergas.es(mailto: ricardo.julio.rodriguez.fernandez(a)sergas.es)) wrote: > > > > Hi all! > > > > > We have successfuly updated our XWiki 6.x installation along the whole 6 cycle, but I'm in troubles with the new 7.0 release. I think that with only the first four lines of the error stack > > > > > XWiki initialization failed ! > > > > > Exception thrown during job execution > > > class java.lang.AbstractMethodError: null org.apache.commons.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:914) org.apache.commons.dbcp2.DelegatingConnection.isValid(DelegatingConnection.java:914) > > > ... > > > > > Here you could find all catalina.out logged me after a Tomcat shutdown/start cycle and a call to XWiki in that server... > > > > http://atriumkm.idisantiago.es/bin/download/ICT/XWikiUpgradeIssues/tomcatEr… > > > > > > > XWiki is running in a CentOS box... > > > > > [root@idis1 /]# cat /etc/centos-release > > > CentOS release 6.5 (Final) > > > > > With the following XWiki relevant pieces... > > > > > [root@idis1 /]# java -version > > > *java version "1.8.0_11" > > > Java(TM) SE Runtime Environment (build 1.8.0_11-b12) > > > Java HotSpot(TM) 64-Bit Server VM (build 25.11-b03, mixed mode) > > > ... concerning JDBC > > > Since 1.7 -- new in the JDBC 4.1 API and part of the Java SE platform, version 7 > > > > > *INFO: Starting Servlet Engine: Apache Tomcat/7.0.55 > > > To the best of my knowledge, compatible with the new Servlet Spec as per... > > > http://tomcat.apache.org/whichversion.html > > > ... from XWiki 7.0 Release Notes > > > > > mysql> status > > > -------------- > > > *mysql Ver 14.14 Distrib 5.5.38, for Linux (x86_64) using readline 5.1 > > > > > *mysql-connector-java-5.0.8-bin.jar (2007-10-09) > > > Well, this piece is a good candidate for being identified as the poblem, but updating it to the last available release... > > > mysql-connector-java-5.1.35-bin.jar (2015-03-23) > > > ...doesn't solve the issue. > > > > > > > As they are a lot of versions between mysql-connector-java-5.0.8-bin.jar (working for us nicely so far) and the newest mysql-connector-java-5.1.35-bin.jar (failing for us, at least with this combination of Java, Tomcat and MySQL), please, could you tell us if we are in the right direction? Should we update any other component but mysql-connector-java-x.y.z-bin.jar to get XWiki 7.0 working? Should we start trying one by one mysql-connector-java-x.y.z-bin.jar newer releases? Do you know which release introduces JDBC 4.1 support? > > > > > > > Thanks you so much for your help! > > > > > Ricardo ________________________________ Nota: A información contida nesta mensaxe e os seus posibles documentos adxuntos é privada e confidencial e está dirixida únicamente ó seu destinatario/a. Se vostede non é o/a destinatario/a orixinal desta mensaxe, por favor elimínea. A distribución ou copia desta mensaxe non está autorizada. Nota: La información contenida en este mensaje y sus posibles documentos adjuntos es privada y confidencial y está dirigida únicamente a su destinatario/a. Si usted no es el/la destinatario/a original de este mensaje, por favor elimínelo. La distribución o copia de este mensaje no está autorizada. See more languages: http://www.sergas.es/aviso_confidencialidad.htm _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users