On Thu, Dec 8, 2011 at 12:27 PM, Ludovic Dubost <[email protected]> wrote: > Hi Edy, > > Yes you should gracefully fail if the database is not supported + we should > not build an hsqldb package if it's not working. > > But my question is which database can I use (except MySQL) to test, as I > already have many DBs in MySQL and cannot use it to test. > So is Derby or Postgres supported ? Is there a way to test with it and > maybe we could build a package for a supported DB.
You can indicate a database name prefix and change the main database name in the xwiki.cfg (xwiki.db and/or xwiki.db.prefix) fail to be able to use the same MySQL with several XEM. > > Ludovic > > 2011/12/8 Eduard Moraru <[email protected]> > >> What do you mean by test and avoid MySQL? >> >> There is a method in the protected api: XWiki.isMySQL() that we could use >> to display a proper message instead of trying to install the template on a >> non MySQL database. >> >> On Thu, Dec 8, 2011 at 12:28 PM, Ludovic Dubost <[email protected]> wrote: >> >> > What is an easy way to test and avoiding MySQL as I already have Databaes >> > in my MySQL install ? >> > >> > Envoyé de mon iPhone >> > >> > Le 8 déc. 2011 à 11:25, Eduard Moraru <[email protected]> a écrit : >> > >> > > Hi Ludovic, >> > > >> > > Yes, that's the problem. HSQLDB was never supported for XEM. >> > > http://jira.xwiki.org/browse/XWIKI-1740 >> > > >> > > Thanks, >> > > Eduard >> > > >> > > On Thu, Dec 8, 2011 at 11:04 AM, Ludovic Dubost <[email protected]> >> > wrote: >> > > >> > >> I tried it withe jetty/hsqldb package. Maybe that's the reason. >> > >> >> > >> I see this error in the log: >> > >> >> > >> 2011-12-08 10:00:56,219 [ >> > http://localhost:8080/xwiki/bin/view/Main/WebHome >> > >> ] >> > >> WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of getter >> > >> [com.xpn.xwiki.api.XWiki.getQueryManager] in unknown namespace@6,39 >> > >> 2011-12-08 10:00:56,225 [ >> > http://localhost:8080/xwiki/bin/view/Main/WebHome >> > >> ] >> > >> WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method >> > >> [org.xwiki.query.internal.SecureQueryManager.xwql] in unknown >> > namespace@6 >> > >> ,52 >> > >> 2011-12-08 10:01:01,794 [ >> > >> >> > >> >> > >> http://localhost:8080/xwiki/bin/login/XWiki/XWikiLogin?xredirect=http%3A%2F%2Flocalhost%3A8080%2Fxwiki%2Fbin%2Fview%2FMain%2FWebHome >> > >> ] >> > >> WARN o.x.v.i.DefaultVelocityEngine - Deprecated usage of method >> > >> [com.xpn.xwiki.api.XWiki.parseMessage] in /templates/login.vm@29,33 >> > >> 2011-12-08 10:01:06,950 [ >> > >> http://localhost:8080/xwiki/bin/loginsubmit/XWiki/XWikiLogin] WARN >> > >> o.x.v.i.DefaultVelocityEngine - Deprecated usage of method >> > >> [com.xpn.xwiki.api.XWiki.parseMessage] in /templates/login.vm@29,33 >> > >> 2011-12-08 10:01:07,547 [ >> > http://localhost:8080/xwiki/bin/view/Main/WebHome >> > >> ] >> > >> ERROR .x.x.s.XWikiHibernateBaseStore - Failed updating schema while >> > >> executing query [create table workspacetemplate.activitystream_events >> > >> (ase_eventid varchar(48) not null, ase_requestid varchar(2000), >> > ase_stream >> > >> varchar(255), ase_date timestamp, ase_priority integer, ase_type >> > >> varchar(255), ase_application varchar(255), ase_user varchar(255), >> > ase_wiki >> > >> varchar(255), ase_space varchar(255), ase_page varchar(255), ase_url >> > >> varchar(2000), ase_title varchar(2000), ase_body varchar(2000), >> > ase_version >> > >> varchar(30), ase_param1 varchar(2000), ase_param2 varchar(2000), >> > ase_param3 >> > >> varchar(2000), ase_param4 varchar(2000), ase_param5 varchar(2000), >> > primary >> > >> key (ase_eventid))] >> > >> java.sql.SQLException: invalid schema name: WORKSPACETEMPLATE in >> > statement >> > >> [create table workspacetemplate.activitystream_events] >> > >> at org.hsqldb.jdbc.Util.sqlException(Unknown Source) >> > >> ~[hsqldb-1.8.0.7.jar:private-2006/09/24-10:30:15] >> > >> at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) >> > >> ~[hsqldb-1.8.0.7.jar:private-2006/09/24-10:30:15] >> > >> at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source) >> > >> ~[hsqldb-1.8.0.7.jar:private-2006/09/24-10:30:15] >> > >> at >> > >> >> > >> >> > >> org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) >> > >> ~[commons-dbcp-1.3.jar:1.3] >> > >> at >> > >> >> > >> >> > >> org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) >> > >> ~[commons-dbcp-1.3.jar:1.3] >> > >> at >> > >> >> > >> >> > >> org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228) >> > >> ~[commons-dbcp-1.3.jar:1.3] >> > >> at >> > >> >> > >> >> > >> com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:508) >> > >> [xwiki-platform-legacy-oldcore-3.3-20111207.222155-301.jar:na] >> > >> at >> > >> >> > >> >> > >> com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:325) >> > >> [xwiki-platform-legacy-oldcore-3.3-20111207.222155-301.jar:na] >> > >> at com.xpn.xwiki.XWiki.updateDatabase(XWiki.java:935) >> > >> [xwiki-platform-legacy-oldcore-3.3-20111207.222155-301.jar:na] >> > >> at >> > >> >> > >> >> > >> com.xpn.xwiki.plugin.wikimanager.WikiManager.createWikiDatabase(WikiManager.java:579) >> > >> [xwiki-platform-wiki-manager-api-3.3-20111208.040804-301.jar:na] >> > >> at >> > >> >> > >> >> > >> com.xpn.xwiki.plugin.wikimanager.WikiManager.createNewWiki(WikiManager.java:456) >> > >> [xwiki-platform-wiki-manager-api-3.3-20111208.040804-301.jar:na] >> > >> at >> > >> >> > >> Maybe hsqldb is not supported for the XEM distribution. In this case >> we >> > >> should not create a jetty / hsqldb distribution, though it could be >> > nice to >> > >> have it working for testing. >> > >> >> > >> Ludovic >> > >> >> > >> 2011/12/8 Ludovic Dubost <[email protected]> >> > >> >> > >>> >> > >>> Hi, >> > >>> >> > >>> I just tried the XEM snapshot and got an error when trying to >> configure >> > >> it. >> > >>> >> > >>> I get this after login as Admin: >> > >>> >> > >>> Workspace Manager translations have been successfully installed. >> > >>> Workspace search suggestions have been successfully installed. >> > >>> Error installing workspace template. null >> > >>> Workspace template features can not be installed without the >> workspace >> > >>> base template being installed first. >> > >>> >> > >>> I also agree with Denis that any install should be done with a >> > >>> confirmation. >> > >>> >> > >>> Ludovic >> > >>> >> > >>> -- >> > >>> Ludovic Dubost >> > >>> Founder and CEO >> > >>> Blog: http://blog.ludovic.org/ >> > >>> XWiki: http://www.xwiki.com >> > >>> Skype: ldubost GTalk: ldubost >> > >>> >> > >>> >> > >> >> > >> >> > >> -- >> > >> Ludovic Dubost >> > >> Founder and CEO >> > >> Blog: http://blog.ludovic.org/ >> > >> XWiki: http://www.xwiki.com >> > >> Skype: ldubost GTalk: ldubost >> > >> _______________________________________________ >> > >> devs mailing list >> > >> [email protected] >> > >> http://lists.xwiki.org/mailman/listinfo/devs >> > >> >> > > _______________________________________________ >> > > devs mailing list >> > > [email protected] >> > > http://lists.xwiki.org/mailman/listinfo/devs >> > _______________________________________________ >> > devs mailing list >> > [email protected] >> > http://lists.xwiki.org/mailman/listinfo/devs >> > >> _______________________________________________ >> devs mailing list >> [email protected] >> http://lists.xwiki.org/mailman/listinfo/devs >> > > > > -- > Ludovic Dubost > Founder and CEO > Blog: http://blog.ludovic.org/ > XWiki: http://www.xwiki.com > Skype: ldubost GTalk: ldubost > _______________________________________________ > devs mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/devs -- Thomas Mortagne _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
