8 Dec
2011
8 Dec
'11
3:36 p.m.
On Thu, Dec 8, 2011 at 1:25 PM, Thomas Mortagne
<thomas.mortagne(a)xwiki.com> wrote:
--
Thomas Mortagne
On Thu, Dec 8, 2011 at 12:27 PM, Ludovic Dubost
<ludovic(a)xwiki.com> wrote:
(Remove "fail")
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 <enygma2002(a)gmail.com>
--
Thomas Mortagne 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 <ludovic(a)xwiki.com> wrote:
--
Ludovic Dubost
Founder and CEO
Blog: http://blog.ludovic.org/
XWiki: http://www.xwiki.com
Skype: ldubost GTalk: ldubost
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs 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 <enygma2002(a)gmail.com> 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 <ludovic(a)xwiki.com>
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 <ludovic(a)xwiki.com>
>>
>>>
>>> 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
>> devs(a)xwiki.org
>> http://lists.xwiki.org/mailman/listinfo/devs
>>
> _______________________________________________
> devs mailing list
> devs(a)xwiki.org
> http://lists.xwiki.org/mailman/listinfo/devs
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs
_______________________________________________
devs mailing list
devs(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/devs