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