On Thu, Dec 8, 2011 at 1:25 PM, Thomas Mortagne <[email protected]> wrote: > 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.
(Remove "fail") > >> >> 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 -- Thomas Mortagne _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
