File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes inserting date into ms access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "inserting date into ms access" Watch "inserting date into ms access" New topic

inserting date into ms access

damien farry

Joined: Mar 22, 2001
Posts: 6
hi, looked at previous posts and tried this code to add to my access database:
java.util.Date d = new java.util.Date();
java.sql.Date date = new java.sql.Date(d.getDate());

PreparedStatement ps;
ps = myConn.prepareStatement("INSERT INTO TestTable"+"(Eventdate)"+ "values (?)");
I tried this and got an java.sql.SQLException: General error
Having serious problems with this i am trying to create a calendar system in JSP so the date is key to my code

Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Try putting spaces between the pieces:

ps = myConn.prepareStatement("INSERT INTO TestTable "+"(Eventdate)"+ " values (?)");
Right now your statement would look like:
INSERT INTO TestTable(Eventdate)values (?)

Moderator of the JDBC Forum

Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
I agree. Here's the link:
subject: inserting date into ms access
jQuery in Action, 3rd edition