problem with data field

[eu.rafael]

Hello!
I´m developping an application with MySQL db. When I try to get a data field with resultset.getDate("field"), the date it´s null (when it shouldn´t be). If i use resultset.getString("field"), the date it´s 0000-00-00. What´s thr problem? What should i do?
Thank´s for your attention.

[ray326]

How do you know it shouldn't be null? Have you issued the same query from some other tool (like the mysql command line interface) and seen the date was there?

[Khalid Ali]

I bet date is null and is not parseable by getDate() object to convert it to sql.date....

[eu.rafael]

Well, i don´t now why but the date in the first try, really shouldn´t be null (i´ve checked on mysql prompt, i swear).... but it´s working now (i didn´t find any mistake).... take a look on the source code

this.resultset = this.statement.executeQuery("Select * from solicitacao_servico where cod_solicitacao="+Integer.parseInt(codigo)+"");
this.resultset.next();
this.codsol = this.resultset.getString("cod_solicitacao");
this.horacriacao = this.resultset.getString("hor_abertura");
this.d = this.resultset.getDate("dat_abertura");
this.priocc = this.resultset.getString("prioridade_cc");
this.sazon = this.resultset.getString("prioridade_cc_atendimento");
this.origem = this.resultset.getString("origem_solicitacao");
this.tipo = this.resultset.getString("tipo_solicitacao");
this.anexo = this.resultset.getString("anexos");
this.descricao = this.resultset.getString("observacoes");
this.id = this.resultset.getString("cod_equipamento");
this.data = this.d.toString();

Thank´s for your attentions

[ray326]

If the date is definitely in the database and the object only fails the first time it's used then that usually indicates the object is not being created the way you think it is.