groovy-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jim northrop <james.b.north...@googlemail.com>
Subject Re: Wanted: help with using jdbc grapes in groovy shell?
Date Mon, 11 Jan 2016 08:50:12 GMT
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_heintze@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.northrop@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
>
>
>
>
>

Mime
View raw message