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. 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
