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,
project_trainees@... 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@...
>
http://lists.xwiki.org/mailman/listinfo/users>
_______________________________________________
users mailing list
users@...
http://lists.xwiki.org/mailman/listinfo/users
