Hi Lukas, thanks for the help, I'm not using Eclipse but Intellij.
I noticed that this happens when the record I'm trying to access through
GET is null, the reference to the table is not null only the table records
in my database are null.
[image: jooq_issue.png]
Select
try {
ctx = DSL.using(connection, SQLDialect.MYSQL);
Result<?> result = ctx.select(RH.LNUM, RH.SNOME, RH.SAPELIDO, RH.SRG,
RH.SEMAIL, RH.ICARGO, RH.SCPF)
.from(RH)
.fetch();
for (Record r : result) {
pesquisaRhDto = new PesquisaRhDto();
pesquisaRhDto.setRhId(r.get(RH.LNUM));
pesquisaRhDto.setNome(r.get(RH.SNOME));
pesquisaRhDto.setApelido(r.get(RH.SAPELIDO));
String fotoExt = r.get(RH.SFOTOEXT).toString();//Exception
pesquisaRhDto.setEmail(r.get(RH.SEMAIL));
pesquisaRhDto.setCpf(r.get(RH.SCPF));
rhList.add(pesquisaRhDto);
}
} catch (Exception e) {
log.error(e.toString());
} finally {
if (ctx != null) {
ctx.close();
}
}
return rhList;
}
Thanks Again...
Em terça-feira, 23 de outubro de 2018 16:17:35 UTC-3, Junior Manzini
escreveu:
>
> Hi Lukas, when I get a null value an exception is thrown
>
> java.lang.IllegalArgumentException:* Field (null) is not contained in Row*
>
> pesquisaRhDto.setFotoUrl(r.get(RH.SFOTOEXT));
>
>
> using jOOQ 3.9.1
> Thanks
>
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
