1 Nov
2007
1 Nov
'07
8:14 p.m.
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