Ya, ive tried that, it’s the grabconfig systemClassLoader=true that is making this difficult for me (I think). I get the usual error as if I did not put the grab config in the @grab annotation …
java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@//ecprd4.hdsupply.net:1521/ecprd4 I’m still going through groovy.grape.GrabAnnotationTransformation to see how it is done there. Erick Nelson Senior Developer – IT HD Supply Facilities Maintenance (858) 740-6523 From: Paul King <pa...@asert.com.au> Reply-To: "users@groovy.apache.org" <users@groovy.apache.org>, "pa...@asert.com.au" <pa...@asert.com.au> Date: Monday, January 20, 2020 at 2:32 PM To: "users@groovy.apache.org" <users@groovy.apache.org> Subject: Re: Convert @Grab to Grape.grab ? It's certainly possible since that is what the compiler does. The compiler goes the extra step and adds the jar onto the classpath at compilation time as well but you might not need that. From a script you'd do something like: groovy.grape.Grape.grab(classLoader: getClass().classLoader, group: 'com.oracle.ojdbc', module: 'ojdbc8', version: '19.3.0.0') Depending on your context you might need to get the classloader in a slightly different way. Cheers, Paul. On Tue, Jan 21, 2020 at 6:36 AM Nelson, Erick <erick.nel...@hdsupply.com<mailto:erick.nel...@hdsupply.com>> wrote: Is it possible to convert a Grab annotation to a Grapes.grab call? Example: Convert this… @Grapes([ @GrabConfig(systemClassLoader=true), @Grab('com.oracle:ojdbc6:11.2.0.1.0'), ]) import groovy.sql.Sql to this… groovy.grape.Grape.grab(group:'com.oracle', module:'ojdbc6', version:'11.2.0.1.0') I’m assuming I’d need to add map entries for classLoader: and refObject: but I’m not sure how to assemble these if needed. I’d like to put the Grapes.grab call in my compiled library. Is this even possible? My library connects to oracle like this… Sql.withInstanceOracle(user:'tauser03',name:'ecprd4') { sql -> } The static method withInstanceOracle is a metaClass method that under the hood calls this… static Sql newInstance (Map map) { // groovy.grape.Grape.grab(group:'com.oracle', module:'ojdbc6', version:'11.2.0.1.0') Map connectionMap = buildConnectionMap(map) log.info "connecting to [${connectionMap.url}] as [${connectionMap.user}]" Sql sql = Sql.newInstance(connectionMap) sql.connection.setAutoCommit(false) sql } In my Oracle class.