I'm terribly sorry Rafael, but I really don't understand your question. You said you had an "object children with age and name" columns. But the code you're displaying is not using any of these terms: children, age, name.
Want to give this question one more try? You know, I'm not sitting right there with you, next to you, looking at your screen... :) I cannot guess what problem you're currently struggling with unless you write a concise, complete question with all the required details that fit together. Looking forward to hearing from you again, Lukas 2015-10-08 16:40 GMT+02:00 Rafael da Silva Monteiro Leite < [email protected]>: > ok, sorry. > > > This is my select: > > SelectOnConditionStep<Record6<Object, Object, Object, Object, Object, > Object>> on = > create.select(field("prd_id").as("codigoProduto"),field("prb_codigo_barras").as("codigoBarras"), > > field("CONCAT(prd_descricao,`prd_apresentacao`)").as("descricaoApresentacao"), > > field("fab_razao").as("razaoFabricante"),field("grp_nome").as("nomeGrupoPrincipal"), > field("prd_dt_cadastro").as("dataCadastroProduto")) > .from(table("produtosrelatoriocloseup")) > .join(table("produto")).on(field("prd_id").eq(field("asi_id_produto"))) > > .join(table("produtocodigobarras")).on(field("prb_id_produto").eq(field("asi_id_produto"))) > > .join(table("fabricante")).on(field("fab_id").eq(field("prd_id_fabricante"))) > > .join(table("grupoprincipal")).on(field("grp_id").eq(field("prd_id_grupo_principal"))); > // .fetchInto(ProdutosCloseUp.class); > List<Produtos> retorno = on.fetchInto(Produtos.class); > > > and this is my class Produtos: > > > private static final long serialVersionUID = 1L; > // @Column(name = "codigoProduto") > private Integer codigoProduto; > // @Column(name = "codigoBarras") > private String codigoBarras; > // @Column(name = "descricaoApresentacao") > private String descricaoApresentacao; > // @Column(name = "razaoFabricante") > private String razaoFabricante; > // @Column(name = "nomeGrupoPrincipal") > private String nomeGrupoPrincipal; > // @Column(name = "dataCadastroProduto") > private Date dataCadastroProduto; > > public Integer getCodigoProduto() { > return codigoProduto; > } > > public void setCodigoProduto(Integer codigoProduto) { > this.codigoProduto = codigoProduto; > } > > public String getCodigoBarras() { > return codigoBarras; > } > > public void setCodigoBarras(String codigoBarras) { > this.codigoBarras = codigoBarras; > } > > public String getDescricaoApresentacao() { > return descricaoApresentacao; > } > > public void setDescricaoApresentacao(String descricaoApresentacao) { > this.descricaoApresentacao = descricaoApresentacao; > } > > public String getRazaoFabricante() { > return razaoFabricante; > } > > public void setRazaoFabricante(String razaoFabricante) { > this.razaoFabricante = razaoFabricante; > } > > public String getNomeGrupoPrincipal() { > return nomeGrupoPrincipal; > } > > public void setNomeGrupoPrincipal(String nomeGrupoPrincipal) { > this.nomeGrupoPrincipal = nomeGrupoPrincipal; > } > > public Date getDataCadastroProduto() { > return dataCadastroProduto; > } > > public void setDataCadastroProduto(Date dataCadastroProduto) { > this.dataCadastroProduto = dataCadastroProduto; > } > > public Produtos(Integer codigoProduto, String codigoBarras, String > descricaoApresentacao, String razaoFabricante, String nomeGrupoPrincipal, > Date dataCadastroProduto) { > super(); > this.codigoProduto = codigoProduto; > this.codigoBarras = codigoBarras; > this.descricaoApresentacao = descricaoApresentacao; > this.razaoFabricante = razaoFabricante; > this.nomeGrupoPrincipal = nomeGrupoPrincipal; > this.dataCadastroProduto = dataCadastroProduto; > } > > public Produtos() { > } > > > > > Em quinta-feira, 1 de outubro de 2015 17:41:04 UTC-3, Lukas Eder escreveu: >> >> Hi Rafael, >> >> I'm sorry, but I'm not sure what you meant in your previous E-Mail. Could >> you pleas show some code examples with all the involved classes and queries >> that result in this behaviour? >> >> Best Regards, >> Lukas >> >> 2015-10-01 18:14 GMT+02:00 Rafael da Silva Monteiro Leite < >> [email protected]>: >> >>> Hi Lukas, >>> >>> I have one select, this select return:age and name , if i use fetchInto >>> of my object children, he return in my object age and not set name in my >>> object. In other select return all information in my object, more in >>> children no set name in object. >>> >>> Em quinta-feira, 3 de setembro de 2015 10:21:01 UTC-3, Lukas Eder >>> escreveu: >>>> >>>> >>>> >>>> 2015-09-03 14:58 GMT+02:00 Rafael da Silva Monteiro Leite < >>>> [email protected]>: >>>> >>>>> Tank you, >>>>> >>>>> One question, in my object is necessary any annotation? >>>>> >>>> >>>> No. But you can use JPA @Column annotations, if you want. >>>> >>>> Cheers, >>>> Lukas >>>> >>> -- >>> 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. >>> >> >> -- > 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. > -- 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.
