On Thu, Dec 8, 2011 at 1: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. > I think the hsqldb package is build to do shallow automated tests that were testing minor stuff on the main wiki IIRC. Subwiki creation and testing could not be performed since embedded databases like hsqldb and derby are/were not compatible. > But my question is which database can I use (except MySQL) to test Manual or automated? , as I > already have many DBs in MySQL and cannot use it to test. > Why is that? Because you don`t want to risk losing the existing databases or why? 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. > Well, as you can see in http://jira.xwiki.org/browse/XWIKI-1740 Derby is also not yet supported, just like HSQLDB. Sergiu or Thomas should know better what the status on that is. Postgresql should work, but this is just an assumption. Thanks, Eduard > > 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 > _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
