8 Dec
2011
8 Dec
'11
1:25 p.m.
On Thu, Dec 8, 2011 at 12:27 PM, Ludovic Dubost <ludovic(a)xwiki.com> 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.
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:
org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
com.xpn.xwiki.store.XWikiHibernateBaseStore.updateSchema(XWikiHibernateBaseStore.java:508)
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)
com.xpn.xwiki.plugin.wikimanager.WikiManager.createWikiDatabase(WikiManager.java:579)
com.xpn.xwiki.plugin.wikimanager.WikiManager.createNewWiki(WikiManager.java:456)
configure
_______________________________________________
devs mailing list
devs(a)xwiki.org
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
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 :
http://localhost:8080/xwiki/bin/login/XWiki/XWikiLogin?xredirect=http%3A%2F…
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 [
>
>
> ]
> 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
>
>
>
~[commons-dbcp-1.3.jar:1.3]
> at
>
>
>
~[commons-dbcp-1.3.jar:1.3]
> at
>
>
>
~[commons-dbcp-1.3.jar:1.3]
> at
>
>
>
[xwiki-platform-legacy-oldcore-3.3-20111207.222155-301.jar:na]
> at
>
>
>
[xwiki-platform-legacy-oldcore-3.3-20111207.222155-301.jar:na]
> at
>
>
>
[xwiki-platform-wiki-manager-api-3.3-20111208.040804-301.jar:na]
> at
>
>
>>
[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 >> 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