Re: [xwiki-users] Sample Groovy Code
Hi, Don't call the database directly. XWiki offers API for doing this. What tutorial are you referring to? Thanks -Vincent On Oct 30, 2007, at 11:53 AM, V. Harikrishnan Nair wrote: Hi all... I am learning how to read from the default xwiki database xwiki_db using groovy. This is the code I got from the tutorial - - import groovy.sql.Sql sql = Sql.newInstance(jdbc:jtds:sqlserver://serverName/dbName- CLASS;domain=domainName, username, password, net.sourceforge.jtds.jdbc.Driver) sql.eachRow(select * from tableName, { println it.id + -- ${it.firstName} --} ); This is the code which is edited by me - --- import groovy.sql.Sql sql = Sql.newInstance(jdbc:jtds:sqlserver://localhost/xwiki_db- CLASS;domain=domainName, sa, , net.sourceforge.jtds.jdbc.Driver) sql.eachRow(select * from XWIKIDOC, { println it.id + -- $ {it.firstName} --} ); -- Can anyone please rectify any errors here ? Especially the closure in the third line as I don't know the fields present in XWIKIDOC table... Thanks, Harikrishnan ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Xwiki file and attachment storage
Is that what you mean? And is this Jackrabbit stuff ready by v1.1? Nope. This is 1.2 stuff. Well, 1.2 is almost here... is the jackrabbit stuff ready, and can I store attachments in files?? -- View this message in context: http://www.nabble.com/Xwiki-file-and-attachment-storage-tf4214945.html#a13494689 Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Xwiki file and attachment storage
Hi, On Oct 30, 2007, at 9:03 PM, bjquinn wrote: Is that what you mean? And is this Jackrabbit stuff ready by v1.1? Nope. This is 1.2 stuff. Well, 1.2 is almost here... is the jackrabbit stuff ready, and can I store attachments in files?? Sorry but no. The scope for 1.2 was changed a long time ago. More importantly Artem who was working on it has stopped participating to XWiki for some time since he's busy on other stuff. He'll join us back later but there's no ETA right now on the JCR implementation. However I'm curious to know why you need attachments stored in the file system. Thanks -Vincent ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Xwiki file and attachment storage
Vincent Massol wrote: Sorry but no. The scope for 1.2 was changed a long time ago. More importantly Artem who was working on it has stopped participating to XWiki for some time since he's busy on other stuff. He'll join us back later but there's no ETA right now on the JCR implementation. However I'm curious to know why you need attachments stored in the file system. Thanks -Vincent Sorry if jumping in this thread is not the most elegant way of collaborate, but I've missed this option, to store attachments in the file system, today. For instance: we use a lot of high resolution pictures in our work. If I can store this images in the file system I can access them by using regular drive mapping, web server access, sftp,... I mean: I could keep relying on different clients to read the files while I could rely on XWiki to easy the way users load files in the system. Hope this makes sense for you. Cheers, Ricardo -- Ricardo RodrÃguez Your XEN ICT Team ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] Sample Groovy Code
Hello Vincent, I've found out QueryPluginApi from the docs. But even if this is the API you meant, why is it not possible to use Groovy to access the database of my choice to display my data ? Harikrishnan vmassol wrote: Hi, Don't call the database directly. XWiki offers API for doing this. What tutorial are you referring to? Thanks -Vincent On Oct 30, 2007, at 11:53 AM, V. Harikrishnan Nair wrote: Hi all... I am learning how to read from the default xwiki database xwiki_db using groovy. This is the code I got from the tutorial - - import groovy.sql.Sql sql = Sql.newInstance(jdbc:jtds:sqlserver://serverName/dbName- CLASS;domain=domainName, username, password, net.sourceforge.jtds.jdbc.Driver) sql.eachRow(select * from tableName, { println it.id + -- ${it.firstName} --} ); This is the code which is edited by me - --- import groovy.sql.Sql sql = Sql.newInstance(jdbc:jtds:sqlserver://localhost/xwiki_db- CLASS;domain=domainName, sa, , net.sourceforge.jtds.jdbc.Driver) sql.eachRow(select * from XWIKIDOC, { println it.id + -- $ {it.firstName} --} ); -- Can anyone please rectify any errors here ? Especially the closure in the third line as I don't know the fields present in XWIKIDOC table... Thanks, Harikrishnan ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users -- View this message in context: http://www.nabble.com/Sample-Groovy-Code-tf4717685.html#a13502522 Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
[xwiki-users] Adding a document in XWiki.org
Hello... I've been able to read and enter data into my personal MySQL database (after a very long night, finally!) and I think this should be added into the documentation for XWiki.org but first, I want to get data from a textbox into the database... Because the first thing that newbies like me wanted to do was to communicate with a personal database (especially through the use of forms), I believe this is important. How can I add a document in XWiki.org ? Do I have editing rights ? Harikrishnan -- View this message in context: http://www.nabble.com/Adding-a-document-in-XWiki.org-tf4723188.html#a13503839 Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users