Re: [xwiki-users] Sample Groovy Code

2007-10-30 Thread Vincent Massol
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

2007-10-30 Thread bjquinn

   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

2007-10-30 Thread Vincent Massol
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

2007-10-30 Thread Your XEN ICT Team - Ricardo Rodriguez
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

2007-10-30 Thread V. Harikrishnan Nair

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

2007-10-30 Thread V. Harikrishnan Nair

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