Thanks for the helping in fixing the issue
On Wed, Nov 25, 2015 at 1:18 PM, Tomasz Guziałek <[email protected]>
wrote:
> Hello Arunkumar,
>
> You cannot call toString method on a NULL value, you can only do it when
> there is a real object assigned to the variable (unless Scala or whatever
> language you are using has some special treatment for such situation). Try:
>
> while (ds.next()) {
> val row:Row= ds.getRow()
> val column1= row.getValue(0)
> val column2= row.getValue(1)
> if (column1 != null) {
> val column1StrVal = column1.toString
> }
> if (column2 != null) {
> val column2StrVal = column2.toString
> }
> }
>
> BTW I also fixed indexes in the getValue calls - there were two times 0. I
> hope that helps!
>
> Pozdrawiam / Regards / Med venlig hilsen
> Tomasz Guziałek
>
> 2015-11-25 5:59 GMT+01:00 Arunkumar Pillai <[email protected]>:
>
> > 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.
> >
>
--
Thanks and Regards
Arun
