problem with data field from db

Ranch Hand

Posts: 52

posted 16 years ago

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.

Thanks,
Rafa

Nathaniel Stoddard

Ranch Hand

Posts: 1258

posted 16 years ago

What would you like to do?

Nathaniel Stodard<br />SCJP, SCJD, SCWCD, SCBCD, SCDJWS, ICAD, ICSD, ICED

Dirk Schreckmann

Sheriff

Posts: 7023

posted 16 years ago

Moving this to the JDBC forum...

[How To Ask Good Questions] [JavaRanch FAQ Wiki] [JavaRanch Radio]

Adeel Ansari

Ranch Hand

Posts: 2874

posted 16 years ago

what is the type of your "field". if it is Date then you should do like,

resultSet.getDate("field");

if it is String then you should do like,

resultSet.getString("field");

but it should be Date. and are you sure you have some values in your Date field?? try to get the record using some Database client tool.

Your mother was a hamster and your father was a tiny ad:

the value of filler advertising in 2020

https://coderanch.com/t/730886/filler-advertising