that's two of us as 'idiots' as i msde that same mistake as you, just
earlier ;-D
Parts of the learning curve me thinks LOL
Have a GR8 Monday woncha ?
k/r
Jim
On 11 January 2016 at 05:38, Richard Heintze <sieg_hein...@yahoo.com> wrote:
> 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 <
> james.north...@orange.fr> 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.
>
> Thanks
> Siegfried
>
>
>
>
>
