groovy SQL

[G Horie]

Hi,

I'm a groovy newbie. I've been trying different example SQL against mysql, but I've been getting this exception:

 $ groovy mysql_test.groovy
Caught: java.lang.ExceptionInInitializerError
        at mysql_test.query(mysql_test.groovy:6)
        at mysql_test.run(mysql_test.groovy:15)
 

I'm not sure where I'm going awry. The javadoc say this:

An ExceptionInInitializerError is thrown to indicate that an exception occurred during evaluation of a static initializer or the initializer for a static variable.

To figure out what classes are being created, I did a 'groovyc mysql_test.groovy' and found the following 2 classes compiled:
mysql_test.class
mysql_test$_query_closure1.class

So I'm assuming its the mysql_test.class is throwing the exception, but I'm not sure why. Here's my code:

import groovy.sql.Sql

def query() 
{
    def sql = Sql.newInstance("jdbc:mysql://localhost:3306/mydb", "user",
    "pass", "com.mysql.jdbc.Driver")
    sql.eachRow("select name from users") 
    { 
        println "${it.name}" 
    }
}

query() 

Any help is appreciated.

Thanks,

- G.

[Gregg Bolinger]

I just ran your code and it worked fine. What version of Groovy are you using?

[Peter Johnson]

Is the MySQL JDBC driver JAR file in your classpath?

[G Horie]

Sorry its taken me so long to respond. My wife had a baby last week, so I went offline until now. Its a girl.

For the version, I'm using groovy v.1.6.3. For the jar, I copied it to {user.home}/.groovy/lib.

Any thoughts?

Thanks.