Re: Wanted: help with using jdbc grapes in groovy shell?

[James Northrop]

Bonjour Richard,

Got a bit farther by changing the : symbols to = symbols as:

@GrabConfig(systemClassLoader=true)
@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");
println "--- the end ---"

but still failed to work on my sys as i do not have 
null\Documents\bin\BackupRecords.mdb  so maybe if u try this version you may 
have some joy !  Have a GR8 day !
thx jim




















On Jan 10, 2016, at 7:25 AM, Richard Heintze wrote:

> @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");