Hi
I'm using select query to fetch records and my code is as follows
val connection = DB.getConnection()
val dataContext:DataContext =
DataContextFactory.createJdbcDataContext(connection)
var query:Query =
dataContext.query().from("TABLE_NAME").select("COLUMN1").select("COLUMN2").toQuery
val ds:DataSet= dataContext.executeQuery(query)
while (ds.next()) {
val row:Row= ds.getRow()
val column1= row.getValue(0).toString
val column2= row.getValue(0).toString
}
if any of the value is NULL then it breaks there. Any suggestions or help
would be highly appreciated.
