I'm not sure if this is the correct venue for reporting an issue with a
"recommended" extension? After installing Task Manager 2.4.1, when I visit
the Task Manager page it shows an empty task list. Fine, but there is also
an error reported.
Failed to execute the [velocity] macro. Cause: [The data types text and
nvarchar are incompatible in the equal to operator.].
The error message ends with these:
Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception
while hibernate execute
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1333)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:1394)
at
com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:165)
... 163 more
Caused by: org.hibernate.exception.SQLGrammarException: could not execute
query
at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:92)
at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.loader.Loader.doList(Loader.java:2545)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
at org.hibernate.loader.Loader.list(Loader.java:2271)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
at
org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
at
org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at
com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor$1.doInHibernate(HqlQueryExecutor.java:174)
at
com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor$1.doInHibernate(HqlQueryExecutor.java:166)
at
com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:1327)
... 165 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The data types
text and nvarchar are incompatible in the equal to operator.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:217)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1655)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:440)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:385)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2444)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:166)
at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:297)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at
org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at
org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
at
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
at org.hibernate.loader.Loader.doList(Loader.java:2542)
... 175 more
--
View this message in context: http://xwiki.475771.n2.nabble.com/Install-Task-Manager-Application-2-4-1-ve…
Sent from the XWiki- Users mailing list archive at Nabble.com.
Hey,
I have googled for quite some time but wasn't able to find an answer to my question.
Is it possible to exclude the "raw content" from the solr search? I don't want it to be indexed and I don't want it to be shown as result. At the moment every "{{html}}" (and so on) can be found via search.
I am using XWiki 7.1.1.
Best regards,
Patrick Enste
Hi,
Is it possible to have multiple xForms on one page when the objects to be edited are not on the same page.
We have a object of class "child" and a object of Class "parent"; each object is stored on it's own page.
But users would like to be able to modify the object of class "header" while they are editing the object of class
In my headerClass sheet I have...
{{velocity}}
## You can modify this page to customize the presentation of your object.
## At first you should keep the default presentation and just save the document.
#if(!$headerDoc)
#set($headerDoc = $xwiki.getDocument("Sandbox.testHeader"))
#end
#set($classHeader = $headerDoc.getObject('Sandbox.classHeader').xWikiClass)
#foreach($prop in $classHeader.properties)
; $prop.prettyName
: $headerDoc.display($prop.getName())
#end
{{/velocity}}
In my childClass sheet I have:
{{velocity}}
#set($headerDoc = $xwiki.getDocument("Sandbox.testHeader") )
{{display reference="$headerDoc"/}}
## You can modify this page to customize the presentation of your object.
## At first you should keep the default presentation and just save the document.
#set($class = $doc.getObject('Sandbox.classChild').xWikiClass)
#foreach($prop in $class.properties)
; $prop.prettyName
: $doc.display($prop.getName())
#end
{{/velocity}}
When I create or edit the page holding the childClass object I do get the impression I can Edit the header object, but when I save only the properties of the child object are saved?
Gerritjan Koekkoek
Vader van Rai Koekkoek (cdls) en voorzitter vereniging CdLS
Visit our website<http://www.cdlsworld.org>
Facebook<https://www.facebook.com/gerritjan.koekkoek>
email<gerritjan(a)cdlsworld.org>
I have the openoffice server configured to import from word docs and it does
quite well. However a direct copy/past from word still loses the images
while keeping much of the formatting. This is just how it is, correct? To
preserve Word formatting and embedded images, the import process must be
used? Or is there a workaround? It's not a show stopper just want to know if
I'm missing anything. Possibly a later version of Word would work better,
I've tried using 2003 and 2010.
--
View this message in context: http://xwiki.475771.n2.nabble.com/Copy-Paste-from-Word-loses-images-tp76023…
Sent from the XWiki- Users mailing list archive at Nabble.com.
Howdy again,
I just upgraded to 8.4.4 via the Ubuntu packages, and the Navigation Panel has no content whatsoever! It’s blank except for the title. Is there a quick or obvious fix for this?
Thanks,
Craig
Hi All,
I am exporting old xwiki workspace to new version 8.2.1 xwiki instance. While import I need to select form available pages in .XAR file. I went through the xwiki documents which says that we should only import the content written by user.
Can anyone help me to know the way I can differentiate the contents? If I import any content created by main xwiki instance then this information may override on newer version same content.
Thanks & Regards
Piyush
Hi All,
I exported older xwiki contents and imported them back into newer xwiki 8.2.1.
I can see that few pages are breaking asking below issue:
org.xwiki.rendering.macro.MacroExecutionException: The execution of the [velocity] script macro is not allowed. Check the rights of its last author or the parameters if it's rendered from another script.
at org.xwiki.rendering.macro.script.AbstractScriptMacro.execute(AbstractScriptMacro.java:178)
at org.xwiki.rendering.macro.script.AbstractScriptMacro.execute(AbstractScriptMacro.java:58)
Can anyone tell me that how to enable rights for macro?
Thanks & Regards,
Piyush
_____________________________________________
From: Kumar, Piyush
Sent: Friday, January 13, 2017 4:45 PM
To: 'users(a)xwiki.org'
Subject: Help needed to distinguish xwiki contents created by user
Hi All,
I am exporting old xwiki workspace to new version 8.2.1 xwiki instance. While import I need to select form available pages in .XAR file. I went through the xwiki documents which says that we should only import the content written by user.
Can anyone help me to know the way I can differentiate the contents? If I import any content created by main xwiki instance then this information may override on newer version same content.
Thanks & Regards
Piyush
Hi, I have changed the font using LESS-CODE. I want to know maybe this
LESS-Code is under renovation or what because, I have change the font (small
the font for heading 2), Under this preview, when i select the doc, the font
is changed. But in main xwiki, i mean main page. no changes for this font
for heading 2.
I have try and error so many times, cut and paste again the code but still
the same(the font is not changed). You can see the picture below:
<http://xwiki.475771.n2.nabble.com/file/n7602322/heading2.png> As you see
here, the font for heading 2 which is 1.1 System Developing is changed.
<http://xwiki.475771.n2.nabble.com/file/n7602322/mainPage-heading2_is_not_ch…>
(the font for heading 2 is not change)
--
View this message in context: http://xwiki.475771.n2.nabble.com/Editing-font-using-LESS-Code-tp7602322.ht…
Sent from the XWiki- Users mailing list archive at Nabble.com.
In developing an in house app using XWiki I am having difficulty getting a page to display with more than one object.
Currently using XWiki Enterprise 7.4.4.
For testing purposes I have 2 classes: SetupHY32 and SetupUniqueValues.
I create a new page located in Sandbox called ObjGroupTest.
Selecting Object Editor I add the 2 classes and fill in data in each property for each class.
When I save and view, only the first object is displayed. When I go back to edit the objects, all the data is there.
The fully qualified name for each object is Sandbox.SetupHY32.Code.SetupHY32Class (1) and Sandbox.SetupUniqueValues.Code.SetupUniqueValuesClass (1).
According to XWiki data model page each page can have multiple objects.
So the ultimate question is, how can more than one object be displayed on a page?
Thanks,
Steve
Hi All,
In our existing Xwiki application for each Xwiki a workspace is getting created. WE are now migrating to the new version 8.2.1 and wanted to export whole workspace of a created xwiki and reimport it to newer version.
While import it displays below directories to select files to import:
AnnotationCode
AppWithinMinutes
Bolg
ColorThemes
Dashboard
Extensions
Faq
Invitation
Main
News
Panels
Sandbox
Scheduler
Stats
Xwiki
I am selecting all the directory and importing it but the pages are not coming proper.
Please suggest if in above directories I should unselect some of them which may override on the newer xwiki 8.2.1 instance.
Please suggest if some other reason could be the problem.
Thanks & Regards,
Piyush
Hello, fellow XWiki community members,
Since XWiki will be participating at this year's FOSDEM (www.fosdem.org)
open source meeting in Brussels and since we never did spend some time to
think about XWiki sticker that would help promote our community, we invite
everybody to chip in with *ideas on how XWiki stickers should look like*.
We would like to focus on *thumb-sized* (vertical/badge; horizontal with
text) stickers in a couple of formats:
1) X logo + "xwiki.org" under (standard XWiki sticker)
2) Horizontal message/quote + "xwiki.org" under it (get creative on the
messages)
3) FOSDEM or other open source event flavored sticker (we have one idea,
others are welcomed)
4) Anything text/graphic XWiki-related (or about open source, wikis, etc.),
within the size restrictions, for the more talented/creative ones out there
:)
Other inspiration and resources:
http://www.unixstickers.com/stickershttp://design.xwiki.org/xwiki/bin/view/Standards/ColorsLogohttps://www.xwiki.org/xwiki/bin/view/Main/Mediahttps://www.xwiki.org/xwiki/bin/view/Main/Logo
Please use this wiki page to share your ideas or designs (or even reply to
this mail, but the wiki page would be nicer :) ):
http://design.xwiki.org/xwiki/bin/view/Proposal/XWikiStickers
The deadline is *end of Wednesday, 11th January, 2016*. You can continue
contributing after this date as well, since ideas are always welcomed, but
they will probably be printed for future events.
It`s a short notice, but FOSDEM is close and we can do more brainstorming
rounds in the future as well.
XWiki SAS is going to handle the printing of the logos around the end of
this week or next week.
We will come back with the results and you can come to FOSDEM at XWiki's
booth to talk to us and grab some stickers to enjoy and share yourself ;)
The plan is to eventually create a stickers page on xwiki.org where
everybody can download and print XWiki stickers themselves. It should
include both generally approved XWiki stickers but also community made ones.
Looking forward to your ideas,
Thanks,
Eduard
Hi guys, I am so confused in this editing matters.
I am editing the font in LESS-Code, but when I save it is not appear in the
main xwiki page.
Some of user ask me to clear the cache browser and I had done it but when i
change /edit the code back, seems no changes and I had to clear the cache
again.
My question is, how many times I need to do so (oftenly clear the cache) and
run the xwiki.
Is there any solution for this? Please advise
--
View this message in context: http://xwiki.475771.n2.nabble.com/Problem-with-editing-page-tp7602349.html
Sent from the XWiki- Users mailing list archive at Nabble.com.
I know xwiki can import various kinds of data one at a time per
http://platform.xwiki.org/xwiki/bin/view/Features/Imports. Here is my more
complex scenario.
We have been adding text files, or doc files, to a windows file system set
of folders. The normal pattern has been something like this:
*-dir root*
--*dir acronis backup*
---*dir 20150101 install on server01*
----text file somename.txt
---*dir 20150520 update to version x.x*
----text file re.txt
----image screenshot01.png
--*dir backblaze*
---*dir 20140105 install and configure*
----txt file re.txt
etc
So, there are topic areas at the highest level (acronis, backblaze) and
normally under them folders named for the date (20150101) with a title
(install on server01). Inside the folder is a mix of text files, word
documents, and images.
I would use the top level folder as a category or topic area inside xwiki.
I would use the date as a data point on the wiki entry, to make sure I can
sort by date of occurrance.
The text or word files are often named re.txt. Sometimes they have a more
distinctive name, but mostly the file name is not a viable name for a wiki
entry. The second part of the folder name would be better for that.
So, no one needs to parse all the details of our existing folder/file hive.
I realize there is no way that any wiki system can simply import and
translate that into something that would be presentable inside the wiki. I
expect to write some code (non-php, I'd probably use vb) that traverses the
hive that we have, and writes elements of what it finds into an xml file or
something else that can otherwise be pulled into xwiki. the text and doc
files would be converted into pages and the images...I'm not familiar enough
with xwiki to know if it'd be best to leave those files in place on the disk
and simply references them in the related wiki entry, or better to move them
into the wiki system somehow.
I could even write the wiki entries directly into the database. xwiki has an
api, possibly that would be useful for this purpose?
Probably an issue that has been encountered many times in the past. I'd
appreciate any tips and or pointers to articles about this.
--
View this message in context: http://xwiki.475771.n2.nabble.com/Importing-a-file-system-based-set-of-fold…
Sent from the XWiki- Users mailing list archive at Nabble.com.
Hi guys, I am facing a problem in xwiki editing font. I dont know why.
Once i change the font/color/link color in a theme. once preview it saved.
But when I open on main page, main title and want to view it again seems it
have a problem. All the changes i made in editing theme, success but when
viewed it again in main page, not success. It appear the old one not the
changes one.
Maybe problem with xwiki?? WHy this happen..please help me
--
View this message in context: http://xwiki.475771.n2.nabble.com/Anyone-face-the-same-problem-like-me-tp76…
Sent from the XWiki- Users mailing list archive at Nabble.com.
I want to ask, i am importing a page using split document.
I want to know how to xexport it for overall page. i try to export but it
only download the certain page not the whole page/topic..
Can anyone advise how?
--
View this message in context: http://xwiki.475771.n2.nabble.com/Export-page-in-split-document-tp7602244.h…
Sent from the XWiki- Users mailing list archive at Nabble.com.
Greetings,
I am trying to install XWiki 8.4.3 in Tomcat 9.0.0.M15.
The instructions at http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationMySQL say :
mysql -u root -e "grant all privileges on *.* to xwiki@localhost identified by 'xwiki'"
This was failing for me with a message about password complexity until I said, in mysql, "uninstall plugin validate_password;"
Apologies if this has already been raised here; I don't see a way to search the archives yet.
Thanks
Doug
The information contained in this transmission may contain West Marine proprietary, confidential and/or privileged
information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are
hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited.
If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original
message. To reply to our email administrator directly, please send an email to netadmin(a)westmarine.com.
Greetings,
Another one of these. A Java stacktrace looking very very much like the one reported Aug 10 2016 by Tom Neumann on the Forum, http://dev.xwiki.org/xwiki/bin/view/Community/Forum
However, his error was at line 233 of hibernate.cfg.xml, whereas mine is at line 244:
Caused by: org.xml.sax.SAXParseException; lineNumber: 244; columnNumber: 21; The content of element type "session-factory" must match "(property*,mapping*,(class-cache|collection-cache)*,event*,listener*)".
The thing is, the file is only 245 lines long. I don't see the error. I have commented out the hsqldb section at line 90. I have uncommented the MySQL section by moving the closing comment from line 138 to line 124.
Can anyone see what I've done wrong? Many thanks-
#cat hibernate.cfg.xml
<?xml version="1.0" encoding="UTF-8"?>
<!--
* See the NOTICE file distributed with this work for additional
* information regarding copyright ownership.
*
* This is free software; you can redistribute it and/or modify it
* under the terms of the GNU Lesser General Public License as
* published by the Free Software Foundation; either version 2.1 of
* the License, or (at your option) any later version.
*
* This software is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this software; if not, write to the Free
* Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA
* 02110-1301 USA, or see the FSF site: http://www.fsf.org.
-->
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://www.hibernate.org/dtd/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<!-- Please refer to the installation guide on
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation for configuring your
database. You'll need to do 2 things:
1) Copy your database driver JAR in WEB-INF/lib or in some shared lib directory
2) Uncomment the properties below for your specific DB (and comment the default
database configuration if it doesn't match your DB)
-->
<!-- Generic parameters common to all Databases -->
<property name="show_sql">false</property>
<property name="use_outer_join">true</property>
<!-- Without it, some queries fail in MS SQL. XWiki doesn't need scrollable result sets, anyway. -->
<property name="jdbc.use_scrollable_resultset">false</property>
<!-- DBCP Connection Pooling configuration. Only some properties are shown. All available properties can be found
at http://commons.apache.org/proper/commons-dbcp/configuration.html
-->
<property name="dbcp.defaultAutoCommit">false</property>
<property name="dbcp.maxTotal">50</property>
<property name="dbcp.maxIdle">5</property>
<property name="dbcp.maxWaitMillis">30000</property>
<property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
<!-- Setting "dbcp.poolPreparedStatements" to true and "dbcp.maxOpenPreparedStatements" will tell DBCP to cache
Prepared Statements (it's off by default). Note that for backward compatibility the "dbcp.ps.maxActive" is also
supported and when set it'll set "dbcp.poolPreparedStatements" to true and "dbcp.maxOpenPreparedStatements" to
value of "dbcp.ps.maxActive".
Note 1: When using HSQLDB for example, it's important to NOT cache prepared statements because HSQLDB
Prepared Statements (PS) contain the schema on which they were initially created and thus when switching
schema if the same PS is reused it'll execute on the wrong schema! Since HSQLDB does internally cache
prepared statement there's no performance loss by not caching Prepared Statements at the DBCP level.
See http://jira.xwiki.org/browse/XWIKI-1740.
Thus we recommend not turning on this configuration for HSQLDB unless you know what you're doing :)
Note 2: The same applies to PostGreSQL.
-->
<!-- BoneCP Connection Pooling configuration.
<property name="bonecp.idleMaxAgeInMinutes">240</property>
<property name="bonecp.idleConnectionTestPeriodInMinutes">60</property>
<property name="bonecp.partitionCount">3</property>
<property name="bonecp.acquireIncrement">10</property>
<property name="bonecp.maxConnectionsPerPartition">60</property>
<property name="bonecp.minConnectionsPerPartition">20</property>
<property name="bonecp.statementsCacheSize">50</property>
<property name="bonecp.releaseHelperThreads">3</property>
<property name="connection.provider_class">com.xpn.xwiki.store.DBCPConnectionProvider</property>
-->
<!-- Configuration for the default database.
Comment out this section and uncomment other sections below if you want to use another database.
Note that the database tables will be created automatically if they don't already exist.
If you want the main wiki database to be different than "xwiki" (or the default schema for schema based engines)
you will also have to set the property xwiki.db in xwiki.cfg file
-->
<!-- Commented out by DKL, 1/3/2017
<property name="connection.url">jdbc:hsqldb:file:${environment.permanentDirectory}/database/xwiki_db;shutdown=true</property>
<property name="connection.username">sa</property>
<property name="connection.password"></property>
<property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<property name="hibernate.connection.charSet">UTF-8</property>
<property name="hibernate.connection.useUnicode">true</property>
<property name="hibernate.connection.characterEncoding">utf8</property>
<property name="connection.url">jdbc:mysql://localhost/xwiki</property>
<property name="connection.username">xwiki</property>
<property name="connection.password">xwiki</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
<property name="hibernate.connection.charSet">UTF-8</property>
<property name="hibernate.connection.useUnicode">true</property>
<property name="hibernate.connection.characterEncoding">utf8</property>
-->
<mapping resource="xwiki.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
<mapping resource="activitystream.hbm.xml"/>
<mapping resource="instance.hbm.xml"/>
<mapping resource="mailsender.hbm.xml"/>
<!-- MySQL configuration.
Uncomment if you want to use MySQL and comment out other database configurations.
Notes:
- if you want the main wiki database to be different than "xwiki"
you will also have to set the property xwiki.db in xwiki.cfg file
-->
<property name="connection.url">jdbc:mysql://localhost/xwiki?useSSL=false</property>
<property name="connection.username">xwiki</property>
<property name="connection.password">xwiki</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="dialect">org.hibernate.dialect.MySQL5InnoDBDialect</property>
<property name="dbcp.poolPreparedStatements">true</property>
<property name="dbcp.maxOpenPreparedStatements">20</property>
<mapping resource="xwiki.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
<mapping resource="activitystream.hbm.xml"/>
<mapping resource="instance.hbm.xml"/>
<mapping resource="mailsender.hbm.xml"/>
<!-- HSQLDB configuration.
Uncomment if you want to use HSQLDB and comment out other database configurations.
Notes:
- if you want the main wiki schema to be different than "PUBLIC" (the default HSQLDB schema)
you will also have to set the property xwiki.db in xwiki.cfg file
<property name="connection.url">jdbc:hsqldb:file:${environment.permanentDirectory}/database/xwiki_db;shutdown=true</property>
<property name="connection.username">sa</property>
<property name="connection.password"></property>
<property name="connection.driver_class">org.hsqldb.jdbcDriver</property>
<property name="dialect">org.hibernate.dialect.HSQLDialect</property>
<mapping resource="xwiki.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
<mapping resource="activitystream.hbm.xml"/>
<mapping resource="instance.hbm.xml"/>
<mapping resource="mailsender.hbm.xml"/>
-->
<!-- PostgreSQL configuration.
Uncomment if you want to use PostgreSQL and comment out other database configurations.
Notes:
- "jdbc.use_streams_for_binary" needs to be set to "false",
see https://community.jboss.org/wiki/HibernateCoreMigrationGuide36
- "xwiki.virtual_mode" can be set to either "schema" or "database". Note that currently the database mode
doesn't support database creation (see http://jira.xwiki.org/browse/XWIKI-8753)
- if you want the main wiki database to be different than "xwiki" (or "public" in schema mode)
you will also have to set the property xwiki.db in xwiki.cfg file
<property name="connection.url">jdbc:postgresql:xwiki</property>
<property name="connection.username">xwiki</property>
<property name="connection.password">xwiki</property>
<property name="connection.driver_class">org.postgresql.Driver</property>
<property name="dialect">org.hibernate.dialect.PostgreSQLDialect</property>
<property name="jdbc.use_streams_for_binary">false</property>
<property name="xwiki.virtual_mode">schema</property>
<mapping resource="xwiki.postgresql.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
<mapping resource="activitystream.hbm.xml"/>
<mapping resource="instance.hbm.xml"/>
<mapping resource="mailsender.hbm.xml"/>
-->
<!-- Oracle configuration.
Uncomment if you want to use Oracle and comment out other database configurations.
Notes:
- the 2 properties named "connection.SetBigStringTryClob" and
"jdbc.batch_size" are required to tell Oracle to allow CLOBs larger than 32K.
- "jdbc.use_streams_for_binary" needs to be set to "false",
see https://community.jboss.org/wiki/HibernateCoreMigrationGuide36
- if you want the main wiki schema to be different than "xwiki"
you will also have to set the property xwiki.db in xwiki.cfg file
<property name="connection.url">jdbc:oracle:thin:@localhost:1521:XE</property>
<property name="connection.username">xwiki</property>
<property name="connection.password">xwiki</property>
<property name="connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
<property name="dialect">org.hibernate.dialect.Oracle10gDialect</property>
<property name="connection.SetBigStringTryClob">true</property>
<property name="jdbc.batch_size">0</property>
<property name="jdbc.use_streams_for_binary">false</property>
<property name="dbcp.poolPreparedStatements">true</property>
<property name="dbcp.maxOpenPreparedStatements">20</property>
<mapping resource="xwiki.oracle.hbm.xml"/>
<mapping resource="feeds.oracle.hbm.xml"/>
<mapping resource="activitystream.hbm.xml"/>
<mapping resource="instance.hbm.xml"/>
<mapping resource="mailsender.oracle.hbm.xml"/>
-->
<!-- Derby configuration.
Uncomment if you want to use Derby and comment out other database configurations.
Notes:
- if you want the main wiki schema to be different than "APP" (the default Derby schema)
you will also have to set the property xwiki.db in xwiki.cfg file
<property name="connection.url">jdbc:derby:/some/path/xwikidb;create=true</property>
<property name="connection.driver_class">org.apache.derby.jdbc.EmbeddedDriver</property>
<property name="dialect">org.hibernate.dialect.DerbyDialect</property>
<property name="dbcp.poolPreparedStatements">true</property>
<property name="dbcp.maxOpenPreparedStatements">20</property>
<mapping resource="xwiki.derby.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
<mapping resource="activitystream.hbm.xml"/>
<mapping resource="instance.hbm.xml"/>
<mapping resource="mailsender.hbm.xml"/>
-->
<!-- H2 configuration.
Uncomment if you want to use H2 and comment out other database configurations.
Notes:
- if you want the main wiki schema to be different than "PUBLIC" (the default H2 schema)
you will also have to set the property xwiki.db in xwiki.cfg file
<property name="connection.url">jdbc:h2:${environment.permanentDirectory}/database/xwiki</property>
<property name="connection.username">sa</property>
<property name="connection.password"></property>
<property name="connection.driver_class">org.h2.Driver</property>
<property name="dialect">org.hibernate.dialect.H2Dialect</property>
<mapping resource="xwiki.hbm.xml"/>
<mapping resource="feeds.hbm.xml"/>
<mapping resource="activitystream.hbm.xml"/>
<mapping resource="instance.hbm.xml"/>
<mapping resource="mailsender.hbm.xml"/>
-->
</session-factory>
</hibernate-configuration>
The information contained in this transmission may contain West Marine proprietary, confidential and/or privileged
information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are
hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited.
If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original
message. To reply to our email administrator directly, please send an email to netadmin(a)westmarine.com.
Hi All,
I am importing .XAR file which has exported from my older xwiki version. I am importing it to Xwiki 8.2.1 and it is breaking for >XAR size more than specified limit.
Please help.
Thanks & Regards,
Piyush
Dear devs,
over the past few months we have moved over to using xwiki as a replacement for your old sharepoint and mediawiki servers. Meanwhile we have accumulated a list of problems and questions we are unable to solve. Some of which open JIRA bugs might already exist.
In my opinion this mailinglist is not suitable for this many questions (needs attachments, screenshots). How may we proceed? Should we create a jira entry for every issue?
An extract of some problems (now running 8.4.3):
- PDF Export: The pdf misses some elements of the page, for example display of info/warn/error marcros (see your sandbox page info and warning macro examples) and other stuff. Layout has big issues (images cut off, Tables cut off)
- Multipage PDF Export: Pdf export collection extension is broken, MultipagePdfExport Space Export extension too.
- No image lightbox by default, unclear how to implement it in the wysiwyg editor
- Document tree is really cumbersome for normal users (we use currently use some velocity to show children), new children macro insufficient (shows translations and attachment)
- DocumentTree Macro "finder" does not work correctly (finds only some pages?)
As for just "questions", should be ask each one of them in an separate mail here on the list?
Thank you very much,
Mario