[xwiki-users] How do I write a correct XWQL statement?
I tried to execute a Query and saw an error below. Caused by: org.xwiki.query.QueryException: Exception while translating [select srv from IN (doc.getObjects(Private.Network Services)) srv order by srv.port] XWQL query to the [hql] language. Query statement = [select srv from IN (doc.getObjects(Private.Network Services)) srv order by srv.port] Although I read JPQL documents, I couldn't come out with an answer. Does anybody know how to write a correct XWQL statement? ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] How do I write a correct XWQL statement?
Le 12/11/12 09:37, crocket a écrit : I tried to execute a Query and saw an error below. Caused by: org.xwiki.query.QueryException: Exception while translating [select srv from IN (doc.getObjects(Private.Network Services)) srv order by srv.port] XWQL query to the [hql] language. Query statement = [select srv from IN (doc.getObjects(Private.Network Services)) srv order by srv.port] Although I read JPQL documents, I couldn't come out with an answer. Does anybody know how to write a correct XWQL statement? Have you read http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module#HQueryLanguageExamples ? Jerome ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] How do I write a correct XWQL statement?
Yes, I read it, and it seems collection member declarations don't work in xwiki. On Mon, Nov 12, 2012 at 6:13 PM, Jerome Velociter jer...@velociter.frwrote: Le 12/11/12 09:37, crocket a écrit : I tried to execute a Query and saw an error below. Caused by: org.xwiki.query.**QueryException: Exception while translating [select srv from IN (doc.getObjects(Private.**Network Services)) srv order by srv.port] XWQL query to the [hql] language. Query statement = [select srv from IN (doc.getObjects(Private.**Network Services)) srv order by srv.port] Although I read JPQL documents, I couldn't come out with an answer. Does anybody know how to write a correct XWQL statement? Have you read http://extensions.xwiki.org/**xwiki/bin/view/Extension/** Query+Module#**HQueryLanguageExampleshttp://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module#HQueryLanguageExamples? Jerome __**_ users mailing list users@xwiki.org http://lists.xwiki.org/**mailman/listinfo/usershttp://lists.xwiki.org/mailman/listinfo/users __**_ users mailing list users@xwiki.org http://lists.xwiki.org/**mailman/listinfo/usershttp://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] How do I write a correct XWQL statement?
Hello, I think this is not correct: select srv from IN (doc.getObjects(Private.Network Services)) srv order by srv.port Should be more something like: select srv.port from Document doc, doc.object(Private.Network Services) as srv order by srv.port Replacing the select srv.port by what fields you want to retrieve. Though obviously I'm not sure about what you wanted to achieve with your request to start with ... Br, Jeremie 2012/11/12 crocket crockabisc...@gmail.com Yes, I read it, and it seems collection member declarations don't work in xwiki. On Mon, Nov 12, 2012 at 6:13 PM, Jerome Velociter jer...@velociter.fr wrote: Le 12/11/12 09:37, crocket a écrit : I tried to execute a Query and saw an error below. Caused by: org.xwiki.query.**QueryException: Exception while translating [select srv from IN (doc.getObjects(Private.**Network Services)) srv order by srv.port] XWQL query to the [hql] language. Query statement = [select srv from IN (doc.getObjects(Private.**Network Services)) srv order by srv.port] Although I read JPQL documents, I couldn't come out with an answer. Does anybody know how to write a correct XWQL statement? Have you read http://extensions.xwiki.org/**xwiki/bin/view/Extension/** Query+Module#**HQueryLanguageExamples http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module#HQueryLanguageExamples ? Jerome __**_ users mailing list users@xwiki.org http://lists.xwiki.org/**mailman/listinfo/users http://lists.xwiki.org/mailman/listinfo/users __**_ users mailing list users@xwiki.org http://lists.xwiki.org/**mailman/listinfo/users http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] How do I write a correct XWQL statement?
doc.getObjects was there since I had multiple instance of the same class. On Mon, Nov 12, 2012 at 8:32 PM, Jeremie BOUSQUET jeremie.bousq...@gmail.com wrote: Hello, I think this is not correct: select srv from IN (doc.getObjects(Private.Network Services)) srv order by srv.port Should be more something like: select srv.port from Document doc, doc.object(Private.Network Services) as srv order by srv.port Replacing the select srv.port by what fields you want to retrieve. Though obviously I'm not sure about what you wanted to achieve with your request to start with ... Br, Jeremie 2012/11/12 crocket crockabisc...@gmail.com Yes, I read it, and it seems collection member declarations don't work in xwiki. On Mon, Nov 12, 2012 at 6:13 PM, Jerome Velociter jer...@velociter.fr wrote: Le 12/11/12 09:37, crocket a écrit : I tried to execute a Query and saw an error below. Caused by: org.xwiki.query.**QueryException: Exception while translating [select srv from IN (doc.getObjects(Private.**Network Services)) srv order by srv.port] XWQL query to the [hql] language. Query statement = [select srv from IN (doc.getObjects(Private.**Network Services)) srv order by srv.port] Although I read JPQL documents, I couldn't come out with an answer. Does anybody know how to write a correct XWQL statement? Have you read http://extensions.xwiki.org/**xwiki/bin/view/Extension/** Query+Module#**HQueryLanguageExamples http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module#HQueryLanguageExamples ? Jerome __**_ users mailing list users@xwiki.org http://lists.xwiki.org/**mailman/listinfo/users http://lists.xwiki.org/mailman/listinfo/users __**_ users mailing list users@xwiki.org http://lists.xwiki.org/**mailman/listinfo/users http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] control the size of the attachments temp storage?
Hi, You can delete those files any time the server stops, unfortunately when it's running they are not safe to delete. There was an issue which lead to files accumulating over time after adverse shutdowns such as a JVM crash. http://jira.xwiki.org/browse/XWIKI-7748 To mitigate this issue with older systems it's prudent to clear out the temp directory from time to time. As far as controlling the total storage size, there isn't any method to limit it and I'm not sure how much sense that would make to add one since the attachments are already stored in the database. Thanks, Caleb On 11/11/2012 03:46 PM, Paul Libbrecht wrote: Hello XWiki experts, at www.curriki.org, our two server-nodes are reaching limits in terms of storage. One of the things that take a lot of space are the logs, we have a clue how to manage that. Another thing that takes a lot of space is /var/tmp/ which contains temporary storages for the attachment deliveries. On one of the nodes, it's made of 14Gb and 12538 files. On the other, 23Gb and 29402 files. What are the risk of deleting the old files there? Is the server touching the files when it has served them so that files older than a day could be deleted if we need? (I think I know that it takes more time to deliver from the DB and create temp-storage than to use the temp storage) thanks in advance Paul ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] New Realtime collaborative editing extension.
Thanks for the complements, it was really a team effort.. and then I came along and packaged it ;) To make simple users act more like advanced users, all you have to do is edit the velocity file: webapps/xwiki/xwikivars.vm and modify the #if directive around line 72. It's probably worthy of a discussion whether simple users should be able to choose between wiki and WYSIWYG editors. Thanks, Caleb On 11/09/2012 10:53 AM, Paul Libbrecht wrote: Caleb, I've installed a brand new 4.3M1 with this editor add-on and configured it. It looks real nice and fast. I was about to announce my installation to my partners but then realized that users need to be advanced otherwise they are offered a single edit link and not a menu. Is there a way to make advanced the default? Or allow all users to have all edit options? Or add the real-time editor as a tab? thanks in advance Paul Le 17 oct. 2012 à 07:12, Caleb James DeLisle a écrit : Hi guys, I just finished repackaging the realtime collaborative editor which was developed as part of wiki/3.0. It is now installable as an extension. It's still a bit rough around the edges but it's pretty safe to play with so everyone is invited to give it a try. * Multiple users can edit the same document at the same time and their changes are merged in real time. * The RealTime Wiki editor is an option along side WYSIWYG and Wiki so it won't break existing editors. * Easy installation by copying a .jar file and importing a .xar file, removal is simply deleting 2 XDocuments. http://extensions.xwiki.org/xwiki/bin/view/Extension/RealTime+Wiki+Editor Please feel free to share your experiences in the mailing list, on the extension wiki page and on the github bug tracker. Thanks, Caleb ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] control the size of the attachments temp storage?
Thank you Caleb, could answer the question as to whether the files with older modification dates are indeed not being served currently, provided the modification dates are older than any connection? thanks in advance Paul Le 12 nov. 2012 à 14:50, Caleb James DeLisle a écrit : Hi, You can delete those files any time the server stops, unfortunately when it's running they are not safe to delete. There was an issue which lead to files accumulating over time after adverse shutdowns such as a JVM crash. http://jira.xwiki.org/browse/XWIKI-7748 To mitigate this issue with older systems it's prudent to clear out the temp directory from time to time. As far as controlling the total storage size, there isn't any method to limit it and I'm not sure how much sense that would make to add one since the attachments are already stored in the database. Thanks, Caleb On 11/11/2012 03:46 PM, Paul Libbrecht wrote: Hello XWiki experts, at www.curriki.org, our two server-nodes are reaching limits in terms of storage. One of the things that take a lot of space are the logs, we have a clue how to manage that. Another thing that takes a lot of space is /var/tmp/ which contains temporary storages for the attachment deliveries. On one of the nodes, it's made of 14Gb and 12538 files. On the other, 23Gb and 29402 files. What are the risk of deleting the old files there? Is the server touching the files when it has served them so that files older than a day could be deleted if we need? (I think I know that it takes more time to deliver from the DB and create temp-storage than to use the temp storage) thanks in advance Paul ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] control the size of the attachments temp storage?
That's not a guarantee unless the modification date predates a restart of the wiki. If you don't want to restart (who does) a cache flush should also release the rest of the files from use. Thanks, Caleb On 11/12/2012 09:48 AM, Paul Libbrecht wrote: Thank you Caleb, could answer the question as to whether the files with older modification dates are indeed not being served currently, provided the modification dates are older than any connection? thanks in advance Paul Le 12 nov. 2012 à 14:50, Caleb James DeLisle a écrit : Hi, You can delete those files any time the server stops, unfortunately when it's running they are not safe to delete. There was an issue which lead to files accumulating over time after adverse shutdowns such as a JVM crash. http://jira.xwiki.org/browse/XWIKI-7748 To mitigate this issue with older systems it's prudent to clear out the temp directory from time to time. As far as controlling the total storage size, there isn't any method to limit it and I'm not sure how much sense that would make to add one since the attachments are already stored in the database. Thanks, Caleb On 11/11/2012 03:46 PM, Paul Libbrecht wrote: Hello XWiki experts, at www.curriki.org, our two server-nodes are reaching limits in terms of storage. One of the things that take a lot of space are the logs, we have a clue how to manage that. Another thing that takes a lot of space is /var/tmp/ which contains temporary storages for the attachment deliveries. On one of the nodes, it's made of 14Gb and 12538 files. On the other, 23Gb and 29402 files. What are the risk of deleting the old files there? Is the server touching the files when it has served them so that files older than a day could be deleted if we need? (I think I know that it takes more time to deliver from the DB and create temp-storage than to use the temp storage) thanks in advance Paul ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] How do I write a correct XWQL statement?
Isn't doc.object(Class) part of XWiki core API? I thought it was an alias of $doc.getObject(Class) I want to know what APIs XWQL has access to, but I couldn't find the information. On Mon, Nov 12, 2012 at 11:42 PM, Jeremie BOUSQUET jeremie.bousq...@gmail.com wrote: doc.getObjects(MyClass) is from the xwiki core java api, but is not part of the XWQL querying language. The query: select srv.port from Document doc, doc.object(Private.Network Services) as srv order by srv.port ... translates to select port field from all XObjects that are of class Private.Network Services, ordering by port field So this query would retrieve the value of port field from all of these XObjects (that we name srv in the query), wherever they are and whatever their count. 2012/11/12 crocket crockabisc...@gmail.com doc.getObjects was there since I had multiple instance of the same class. On Mon, Nov 12, 2012 at 8:32 PM, Jeremie BOUSQUET jeremie.bousq...@gmail.com wrote: Hello, I think this is not correct: select srv from IN (doc.getObjects(Private.Network Services)) srv order by srv.port Should be more something like: select srv.port from Document doc, doc.object(Private.Network Services) as srv order by srv.port Replacing the select srv.port by what fields you want to retrieve. Though obviously I'm not sure about what you wanted to achieve with your request to start with ... Br, Jeremie 2012/11/12 crocket crockabisc...@gmail.com Yes, I read it, and it seems collection member declarations don't work in xwiki. On Mon, Nov 12, 2012 at 6:13 PM, Jerome Velociter jer...@velociter.fr wrote: Le 12/11/12 09:37, crocket a écrit : I tried to execute a Query and saw an error below. Caused by: org.xwiki.query.**QueryException: Exception while translating [select srv from IN (doc.getObjects(Private.**Network Services)) srv order by srv.port] XWQL query to the [hql] language. Query statement = [select srv from IN (doc.getObjects(Private.**Network Services)) srv order by srv.port] Although I read JPQL documents, I couldn't come out with an answer. Does anybody know how to write a correct XWQL statement? Have you read http://extensions.xwiki.org/**xwiki/bin/view/Extension/** Query+Module#**HQueryLanguageExamples http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module#HQueryLanguageExamples ? Jerome __**_ users mailing list users@xwiki.org http://lists.xwiki.org/**mailman/listinfo/users http://lists.xwiki.org/mailman/listinfo/users __**_ users mailing list users@xwiki.org http://lists.xwiki.org/**mailman/listinfo/users http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
