How to configure a timeout for an SQL query in Groovy?

Question

How do I create a timeout for this operation: ?

def db = Sql.newInstance("jdbc:mysql://${mysql_host}:3306/${dbName}", 
    user, pass, 'com.mysql.jdbc.Driver')
db.eachRow(query) { row ->
  // do something with the row
}

Similar question can be found [here](http://groovy.329449.n5.nabble.com/SQL-set-timeout-for-query-td372263.html). — dmahapatro, Sep 08 '13 at 18:08

score 9 · Accepted Answer · answered Sep 08 '13 at 16:33

9

I believe the correct way would be something like this:

sql = Sql.newInstance("jdbc:oracle:thin:@localhost:1521:XE", "user", 
                  "pwd", "oracle.jdbc.driver.OracleDriver") 

sql.withStatement { 
   stmt -> stmt.queryTimeout = 10 
} 

sql.eachRow("select * from someTable", { 
 println it 
} )

of course, this is where I'd used Oracle, but I hope this can give you an idea.

answered Sep 08 '13 at 16:33

VictorCreator

724
1
7
17

If this answer helped, please don't forget to "accept as answer". It helps newbies(like me!) and the community as a whole :-) – VictorCreator Sep 08 '13 at 16:37
Thanks. Is there a reference you can cite? – ripper234 Sep 08 '13 at 16:45

score 0 · Answer 2 · answered Sep 08 '13 at 16:24

0

I believe there might not be a general answer, but rather a database/driver-specific answer via parameters to the connection URL.

E.g. for mysql, I think that adding connectTimeout=something&socketTimeout=something might do the trick.

answered Sep 08 '13 at 16:24

ripper234

222,824
274
634
905

How to configure a timeout for an SQL query in Groovy?

2 Answers2

Linked