Read a File and list the record from DB using Groovy

[s nar]

This post has NOT been accepted by the mailing list yet.
I am using the following code to read a file and store it in a array and giving the array variable as a input to the query. but the query does not list any result. Please let me know what is wrong in the code.

import groovy.sql.Sql 
def sql = Sql.newInstance("jdbc:oracle:thin:@xxxx:1521:xxxx", "xxx", "xx", "oracle.jdbc.driver.OracleDriver") 
def i =0 
def ignore= new Object[10] 
new File("Test10.txt").eachLine{ line -> 
   a = line.split('[*]')
   ignore[i] = a[0]
   i = i+1 
} 

for (j in 0..9) { 
   def a = "'" + ignore[j] + "'" 

   sql.eachRow(" select ADDRESS_ID from collabadmin.address where ADDRESS_ID = ${a} "){ row -> 
      println row.ADDRESS_ID 
  } 
}

[Gregg Bolinger]

The first step is to properly format your code and place it in code tags so it is easier to read. I've taken care of that for you this time.

If you do this:

println "select ADDRESS_ID from collabadmin.address where ADDRESS_ID = ${a}"

Is the value of ${a} what you expect it to be?