Given that I can't access outside servers from our server network (company policy), I adjusted this to reflect my own database - changing only the db name and user details. I setup a table to mimic your column name as well. On 1.1 it seems to work; though my environment is a bit different to standard release (not completely standard xwiki install).
________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Your XEN ICT Team - Ricardo Rodriguez Sent: 01 November 2007 19:15 To: XWiki Users Subject: Re: [xwiki-users] Adding a document in XWiki.org Esbach, Brandon wrote: Xwiki.org sandbox: you don't normally get programming rights (admin rights don't guarantee programming rights on the .org sites). Someone on the xwiki team will have to open and save the page for you in order to test it. Thanks for the information. I didn't realize about the required programming rights. It is perfectly reasonable that this rights must be given by an administrator. But the site is not accessible yet. This link http://sandbox.xwiki.org/xwiki/bin/view/Main/WebHome keeps generating an exception while reading document XWiki.XWikiPreferences. In any case, it there were a problem with programming rights, I understand that no script will be executed. In this case, scripts recovering a single record work fine or printing simple lines by using println work fine. If it's a local xwiki instance that's also causing the problem, I'm not sure. Accessing mysql databases seems to work fine for me for my own local databases. Could you be so kind as to trying the following script in your xwiki installation to see if it is my server the only one that is having problems while printing iterations? Thanks! <% import groovy.sql.Sql; println "This is a sample to access epec in *mire*" def sendSQL = Sql.newInstance("jdbc:mysql://mire.environmentalchange.net/epec","epec_ReadOnly", "epec_ReadOnly", "com.mysql.jdbc.Driver") sendSQL.eachRow("SELECT * FROM epec.spot s") {row ->println "${row.code}"} %> I've run it in three boxes all of them running 1.2-milestone-1.5235 and always get the same result. Please, could anybody else try this? Thank you so much. Best, -- Ricardo RodrÃguez Your XEN ICT Team
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
