I am trying to fetch entire data from a table and the outcome should be a comma seperated string. Here is my code which is working fine.
import groovy.sql.Sql; import java.sql.ResultSet; def temp=""; def temp1=""; sql = Sql.newInstance("jdbc:oracle:thin:@localhost:1521:XE","username", "password", "oracle.jdbc.driver.OracleDriver") sql.eachRow("select * FROM employee") { temp1=it.toRowResult().values().join(", ") if(temp=="") { temp=temp1; } else { temp=temp+"\n"+temp1 } } Is there any better approach of doing this which can increase the performance -- View this message in context: http://groovy.329449.n5.nabble.com/Better-Approach-to-fetch-entire-data-from-the-table-Groovy-Sql-tp5734309.html Sent from the Groovy Dev mailing list archive at Nabble.com.