Re: [xwiki-users] Programming Help

2008-05-14 Thread Vincent Massol
Hi,

On May 14, 2008, at 12:41 PM, [EMAIL PROTECTED] wrote:

 Hi,

  I have to deal some external data in xwiki. Is it require to connect
 xwiki with Mysql through Hibernate.cfg or Is it possible through  
 program
 using velocity or groovy? Is velocity enough for transactions? One
 another Qn. a groovy code should be called by a velocity code?

Everything is possible... your imagination is the limit :)

See the sql plugin for example:
http://code.xwiki.org/xwiki/bin/view/Plugins/XWikiSqlPlugin

Thanks
-Vincent
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Programming Help

2008-05-14 Thread [Ricardo Rodriguez] Your EPEC Network ICT Team
I've quoted your statement in our wiki! :-)

http://environmentalchange.net

Cheers,

Ricardo

Vincent Massol wrote:
 Hi,

 On May 14, 2008, at 12:41 PM, [EMAIL PROTECTED] wrote:

   
 Hi,

  I have to deal some external data in xwiki. Is it require to connect
 xwiki with Mysql through Hibernate.cfg or Is it possible through  
 program
 using velocity or groovy? Is velocity enough for transactions? One
 another Qn. a groovy code should be called by a velocity code?
 

 Everything is possible... your imagination is the limit :)

 See the sql plugin for example:
 http://code.xwiki.org/xwiki/bin/view/Plugins/XWikiSqlPlugin

 Thanks
 -Vincent
 ___
 users mailing list
 users@xwiki.org
 http://lists.xwiki.org/mailman/listinfo/users


   


-- 
Ricardo Rodríguez
Your EPEC Network ICT Team

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Programming Help

2008-05-14 Thread Vincent Massol

On May 14, 2008, at 2:39 PM, [Ricardo Rodriguez] Your EPEC Network ICT  
Team wrote:

 I've quoted your statement in our wiki! :-)

 http://environmentalchange.net

nice ;)

-Vincent

 Vincent Massol wrote:
 Hi,

 On May 14, 2008, at 12:41 PM, [EMAIL PROTECTED] wrote:


 Hi,

 I have to deal some external data in xwiki. Is it require to connect
 xwiki with Mysql through Hibernate.cfg or Is it possible through
 program
 using velocity or groovy? Is velocity enough for transactions? One
 another Qn. a groovy code should be called by a velocity code?


 Everything is possible... your imagination is the limit :)

 See the sql plugin for example:
 http://code.xwiki.org/xwiki/bin/view/Plugins/XWikiSqlPlugin

 Thanks
 -Vincent
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Programming Help

2008-05-14 Thread project_trainees
Hi,
  Surely right, but as beginners which is better for us? And I put sql
plugin in WEB-INF/lib directory and wrote the following code, it neither
shows any error nor changed the table.

##receive database
#set  ($mydb=$xwiki.sql.getDatabase(test))

#set ($myname=prinsi)
#set ($myid=876)
#set  ($result=$mydb.executeUpdate(
 'update projects set assignee=? where id=?',
 [$myname,$myid]))

Where assignee and id are columns of table projects, I have added
ua.gradsoft.xwikisql.SqlPlugin to list of active plugins in
webapp-root/WEB-INF/xwiki.cfg and restarted xwiki.


 On May 14, 2008, at 12:41 PM, [EMAIL PROTECTED] wrote:

 Hi,

  I have to deal some external data in xwiki. Is it require to connect
 xwiki with Mysql through Hibernate.cfg or Is it possible through
 program
 using velocity or groovy? Is velocity enough for transactions? One
 another Qn. a groovy code should be called by a velocity code?

 Everything is possible... your imagination is the limit :)

 See the sql plugin for example:
 http://code.xwiki.org/xwiki/bin/view/Plugins/XWikiSqlPlugin

 Thanks
 -Vincent
 ___
 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