Two Laptop Bag
The moose likes JDBC and the fly likes inserting a date in MS Access Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "inserting a date in MS Access" Watch "inserting a date in MS Access" New topic
Author

inserting a date in MS Access

anupama rc
Greenhorn

Joined: Mar 01, 2001
Posts: 3
hi freinds
i am doing this servlet program where i have to insert dates into a data base...i accept the date as a string ...convert into Date object ...but when i try toinsert into the data base ...its giving me an error saying Syntax error (operator missing)..
I have converted the string into date object using SimpleDateFormat class...and its parse mtd
pls help

------------------
anu


anu
Joe Paolangeli
Ranch Hand

Joined: Apr 05, 2000
Posts: 73
When creating the date object for the insert try using java.sql.Date instead of java.util.Date
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: inserting a date in MS Access
 
Similar Threads
Runtime Exception
Assigning sub class reference to super class object
java.text.ParseException in Web service
Difference in "? extends Object" and "Object" in Generics
date format issue. can you please tell