As I mentioned in my post?Learning Groovy,I am writing Groovy scripts to automate some simple tasks. Now I want to share the scripts with others. I did not want them to install Groovy just to run the scripts. I had the groovy-all-1.8.0.jar,so I typed the following in the command prompt:
|
1
2 |
C:temp
>java -jar groovy-all-1.8.0.jar Hello.groovy
Hello |
It worked. Simple. Now I tried to run my script that retrieved the XMLs from a database.
|
1
2 3 4 |
C:workFetchData
>java -jar groovy-all-1.8.0.jar FetchData.groovy
Caught: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver at FetchData.fetch (FetchData.groovy:51 ) at FetchData.run (FetchData.groovy:3 ) |
Of course I need the driver jar in the classpath. So I added the sqljdbc.jar to the classpath.
|
1
2 3 4 |
C:workFetchData
>java -cp sqljdbc.jar -jar groovy-all-1.8.0.jar FetchData.groovy
Caught: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver ? ? ? ? at FetchData.createCSV (FetchData.groovy:51 ) ? ? ? ? at FetchData.run (FetchData.groovy:3 ) |
Looks like the script is run with a different classloader and the java classpath is not passed to it. I did some?lazy googling?but did not find the answer I was looking for. So I looked at how eclipse is doing it. Eclipse used GroovyStarter and GroovyMain to run scripts. Not knowing which to use,I just used GroovyMain:
|
1
2 |
C:workFetchData
>java -cp lib/groovy-all-1.8.0.jar;lib/sqljdbc.jar groovy.ui.GroovyMain FetchData.groovy
Fetched Data ! |
It worked! I just added the command in a batch file to share the script.