Mailing-List: contact users-help@groovy.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@groovy.apache.org
Date: Sun, 10 Jan 2016 06:25:41 +0000 (UTC)
From: Richard Heintze <sieg_heintze@yahoo.com>
Reply-To: Richard Heintze <sieg_heintze@yahoo.com>
To: "users@groovy.apache.org" <users@groovy.apache.org>
Message-ID: <1696513649.2213372.1452407141758.JavaMail.yahoo@mail.yahoo.com>
Subject: Wanted: help with using jdbc grapes in groovy shell?
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_2213371_825129240.1452407141755"
References: 
 <1696513649.2213372.1452407141758.JavaMail.yahoo.ref@mail.yahoo.com>

------=_Part_2213371_825129240.1452407141755
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

 Why does the groovy shell require a special syntax?
I'm trying to make this work in the groovyConsole.
@GrabConfig(systemClassLoader=3Dtrue)
groovy.grape.Grape.grab(group:'net.sf.ucanaccess', module:'ucanaccess', ver=
sion:'3.0.1')
sql =3D groovy.sql.Sql.newInstance("jdbc:ucanaccess://"+ System.getenv()['U=
SERPROFILE']+ "\\Documents\\bin\\BackupRecords.mdb","net.ucanaccess.jdbc.Uc=
anaccessDriver"); sql.eachRow("SELECT pattern FROM FileNamePattern, (SELECT=
 idFileNamePattern FROM FileNamePatternGroupToFileNamePattern WHERE idFileE=
xclusionGroup=3D( SELECT idFileExclusionGroup FROM Directory WHERE director=
y=3D:dir)) WHERE id =3D idFileNamePattern=C2=A0 ", [dir:"%USERPROFILE%\\Doc=
uments\\WinOOP"]){ println it }
The first line does not work well! Can someone show me out to use the class=
 loader in the groovy console?
Unfortunately, the blog that explained how to do this is now gone.
ThanksSiegfried
------=_Part_2213371_825129240.1452407141755
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html><head></head><body><div style=3D"color:#000; background-color:#fff; f=
ont-family:Courier New, courier, monaco, monospace, sans-serif;font-size:16=
px"><div id=3D"yui_3_16_0_1_1452298722161_36642">  Why does the groovy shel=
l require a special syntax?</div><div id=3D"yui_3_16_0_1_1452298722161_3659=
6"><br></div><div id=3D"yui_3_16_0_1_1452298722161_36599" dir=3D"ltr">I'm t=
rying to make this work in the groovyConsole.</div><div id=3D"yui_3_16_0_1_=
1452298722161_36643" dir=3D"ltr"><br></div><div id=3D"yui_3_16_0_1_14522987=
22161_36644" dir=3D"ltr">@GrabConfig(systemClassLoader=3Dtrue)<br id=3D"yui=
_3_16_0_1_1452298722161_36618">groovy.grape.Grape.grab(group:'net.sf.ucanac=
cess', module:'ucanaccess', version:'3.0.1')<br id=3D"yui_3_16_0_1_14522987=
22161_36620">sql =3D groovy.sql.Sql.newInstance("jdbc:ucanaccess://"+ Syste=
m.getenv()['USERPROFILE']+ "\\Documents\\bin\\BackupRecords.mdb","net.ucana=
ccess.jdbc.UcanaccessDriver"); sql.eachRow("SELECT pattern FROM FileNamePat=
tern, (SELECT idFileNamePattern FROM FileNamePatternGroupToFileNamePattern =
WHERE idFileExclusionGroup=3D( SELECT idFileExclusionGroup FROM Directory W=
HERE directory=3D:dir)) WHERE id =3D idFileNamePattern&nbsp; ", [dir:"%USER=
PROFILE%\\Documents\\WinOOP"]){ println it }</div><div id=3D"yui_3_16_0_1_1=
452298722161_36645" dir=3D"ltr"><br></div><div id=3D"yui_3_16_0_1_145229872=
2161_36622" dir=3D"ltr">The first line does not work well! Can someone show=
 me out to use the class loader in the groovy console?</div><div id=3D"yui_=
3_16_0_1_1452298722161_36681" dir=3D"ltr"><br></div><div id=3D"yui_3_16_0_1=
_1452298722161_36682" dir=3D"ltr">Unfortunately, the blog that explained ho=
w to do this is now gone.</div><div id=3D"yui_3_16_0_1_1452298722161_36683"=
 dir=3D"ltr"><br></div><div id=3D"yui_3_16_0_1_1452298722161_36654" dir=3D"=
ltr">Thanks</div><div id=3D"yui_3_16_0_1_1452298722161_36684" dir=3D"ltr">S=
iegfried</div></div></body></html>
------=_Part_2213371_825129240.1452407141755--