Hi! I've never used a Windows standalone distribution so, please, take this ideas just as... ideas! Sharon Sahar wrote:

Hi,

I currently have XWIKI v2.3.2 (windows, standalone XWIKI installation) and have problems upgrading to the latest release, v 2.5 Milestone 2. All the following options have FAILED:

1. Upgrade according to the documentation: -------------------------------------------- - I've created a new xwiki dir, and copied all the WAR content into this dir. (still using the old DB) - When i'm trying to access the page i get the following error:

HTTP ERROR 500

Problem accessing /xwiki/bin/view/Main/. Reason:

Error number 3 in 0: Could not initialize main XWiki context Wrapped Exception: Error number 3001 in 3: Cannot load class com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager from param xwiki.store.migration.manager.class Wrapped Exception: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: Could not create a DBCP pool. There is an error in the hibernate configuration file, please review it. Caused by: ... ... Wrapped Exception:

com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute Wrapped Exception: Could not create a DBCP pool. There is an error in the hibernate configuration file, please review it. .... .... Wrapped Exception: org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class 'org.hsqldb.jdbcDriver'

Are you trying to upgrade a standalone distribution with a new war? I think you are moving to a different "domain". If you work with a standalone distribution, you have not be worried about connectors and stuff. Once you work with *.war files, you must take care about several things. Concerning HSQLDB, you must check this: http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationHSQL I guess you don't have hsqldb*.jar. in your WEB-INF/lib folder. I don't know how HSQLDB store data by default. Have you copied your database files to the new location?

2. DB export / import -------------------------------------------- - Export DB from v 2.3 - Clean install v2.5 - Import database - Got 10MB max attachment message - After changing this limit in the XWIKIPreferences, i got JAVA heap out of memory exception while trying to import my 90mb XAR.

Again, perhaps with a 90Mb wiki, even though is can't be considered as a big wiki, you must consider to move to installing a XWiki WAR manually using the database of your election. Concerning JAVA heap out memory exception, check this: http://www.xwiki.org/xwiki/bin/view/FAQ/HowToSolveAJavaHeapMemoryError

3. DB copy -------------------------------------------- - Clean install v2.5 - Copy database file from v2.3 to v2.5 dir - XWIKI loads and works but the Lucene search doesn't work (and i'm not sure what else.. for start, i'm unable to search inside attachments...)

I'm also having some problems with Lucene here. We don't know how they relate with installation or contents yet. Please, could you check you servlet container log for Lucene related errors? Following some experience with migration here, I'll stick to upgrade option number 2 but forgetting about the standalone installation and moving to a WAR customized installation where you have full control about what you are doing. I think it could be also useful to check the log of your servlet container for the export process and to check your current 2.3 installation for broken attachments. You could use this script: http://code.xwiki.org/xwiki/bin/view/Snippets/AllBrokenAttachments HTH, Ricardo -- Ricardo Rodríguez CTO eBioTIC. Life Sciences, Data Modeling and Information Management Systems