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).
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