How do I retrieve a microsoft access date field. Here is my code in a case statement.<br>ResultSet rs;<br><br>case Types.DATE:<br> currentRow.addElement(<br> new Date( rs.getDate(i)) );<br> break;<br>This gives an error that "reference to date is ambigious - in both java.util and java.sql".<br>Changing to this gives another type of error<br> Date.valueof( rs.getDate(i)) );<br>error is: "no method with java.sql.Date "<br><br>Do I need to break the date down into individual parts such as year, month, day. if so, how would it look in code.<br><br>Thank you,<br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Retrieve MS Access Date using JDBC
- Thread starter cmmrfrds
- Start date
juliaroberts
Programmer
hi,<br><br><br>your problem is quite simple.<br><br>Date class can be found in the following 2 packages:-<br><br>java.sql<br>java.util<br><br>So in case you import all the classes from the above 2 packages then the compiler will complain that "new Date(.." is ambigous because it will not know which of the 2 Date classes to instantiate.<br><br><br>The solution would be to use...<br> " new java.sql.Date(... " or<br> "new java.util.Date(..." depending on which Date you require.<br><br><br>Regards
- Thread starter
- #3
Thank you for the information. I guess my real question is that I don't understand what kind of data comes back from MS Access in a date field. Apparently, Java picks up the field as a DATE type, but I don't know how to parse the field. I tried using getLong, which compiles but gives an exception. I tried creating a new String field of the data but get an arrayindex out of bound error. Do you have a code sample on how to manipulate a date field from MS Access or any other SQL database?<br><br>
- Status