I'm refering to the groovy tutorial in
http://groovy.codehaus.org/Tutorial+6+-+Groovy+SQL
I had also tried this ->
/ *Groovy code*#* /
import groovy.sql.Sql
class groovyClass {
String SQL_conn() {
def sql = Sql.newInstance("jdbc:mysql://localhost:3306/mysql",
"root","amma", "com.mysql.jdbc.Driver")
sql.eachRow("select * from db") {return "${it.Db}"}
}
}
/ *# /
but when I call the function SQL_conn() through a velocity page I only get
'$groovyObject.SQL_conn()' itself as the output !!!
Can you please show me the API ?
vmassol wrote:
>
> Hi,
>
> Don't call the database directly. XWiki offers API for doing this.
>
> What tutorial are you referring to?
>
> Thanks
> -Vincent
>
> On Oct 30, 2007, at 11:53 AM, V. Harikrishnan Nair wrote:
>
>>
>> Hi all...
>>
>> I am learning how to read from the default xwiki database xwiki_db
>> using
>> groovy. This is the code I got from the tutorial ->
>>
>> -------------
>> import groovy.sql.Sql
>> sql =
>> Sql.newInstance("jdbc:jtds:sqlserver://serverName/dbName-
>> CLASS;domain=domainName",
>> "username",
>> "password", "net.sourceforge.jtds.jdbc.Driver")
>> sql.eachRow("select * from tableName", { println it.id + " --
>> ${it.firstName} --"} );
>> ------------
>>
>> This is the code which is edited by me ->
>>
>> -----------
>> import groovy.sql.Sql
>> sql =
>> Sql.newInstance("jdbc:jtds:sqlserver://localhost/xwiki_db-
>> CLASS;domain=domainName",
>> "sa",
>> "", "net.sourceforge.jtds.jdbc.Driver")
>> sql.eachRow("select * from XWIKIDOC", { println it.id + " -- $
>> {it.firstName}
>> --"} );
>> ----------
>>
>> Can anyone please rectify any errors here ? Especially the closure
>> in the
>> third line as I don't know the fields present in XWIKIDOC table...
>>
>> Thanks,
>> Harikrishnan
>
> _______________________________________________
> users mailing list
> [email protected]
> http://lists.xwiki.org/mailman/listinfo/users
>
>
--
View this message in context:
http://www.nabble.com/Sample-Groovy-Code-tf4717685.html#a13492691
Sent from the XWiki- Users mailing list archive at Nabble.com.
_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users
