Sorry, I am idiot!In previous versions of groovy console this "@Grab" syntax
did not work you needed to use a function call of Groovy.grape.Grape.grab
instead and this was a problem with the system class loader jdbc requires.
Apparently groovy console now works with "@Grab".Sorry for the spam.
On Sunday, January 10, 2016 12:21 AM, James Northrop
<[email protected]> wrote:
just saw this too: the env var USERPROFILE may be obsolete but i tried
up = System.getenv("USER");println up;
and that says'Jim'
;-)
On Jan 10, 2016, at 7:25 AM, Richard Heintze wrote:
Why does the groovy shell require a special syntax?
I'm trying to make this work in the groovyConsole.
@GrabConfig(systemClassLoader=true)
groovy.grape.Grape.grab(group:'net.sf.ucanaccess', module:'ucanaccess',
version:'3.0.1')
sql = groovy.sql.Sql.newInstance("jdbc:ucanaccess://"+
System.getenv()['USERPROFILE']+
"\\Documents\\bin\\BackupRecords.mdb","net.ucanaccess.jdbc.UcanaccessDriver");
sql.eachRow("SELECT pattern FROM FileNamePattern, (SELECT idFileNamePattern
FROM FileNamePatternGroupToFileNamePattern WHERE idFileExclusionGroup=( SELECT
idFileExclusionGroup FROM Directory WHERE directory=:dir)) WHERE id =
idFileNamePattern ", [dir:"%USERPROFILE%\\Documents\\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
