Insert Date into a database from java

Asked May 12 '14 at 19:36

Active May 12 '14 at 19:38

Viewed 105 times

I have a database where I have a field that is type DATE and I want to make a function in java to insert values in the database. The problem is that when I insert a Date I get a NULL in the database DATE field.

I'm doing this:

PreparedStatement stmt = null:
stmt = conn.prepareStatement("INSERT INTO DB1(print_date) values(?)";
stmt.setDate(1, database.getPrintDate());
stmt.executeUpdate();

How can I insert the PrintDate which is DATE type in the database? Thank you

asked May 12 '14 at 19:36

Alhar

4

Which database are you using? Are you **positive** that database.getPrintDate() returns != null? – FrobberOfBits May 12 '14 at 19:38
3

are you using java.util.Date or java.sql.Date? – EasterBunnyBugSmasher May 12 '14 at 19:43
I see absolutely nothing wrong in your code. And since it doesn't throw an exception, I can only assume that database.getPrintDate() must be null. Have you tried adding another column and stmt.setInt(2,1); to see if that works or if it is a Date issue? – EasterBunnyBugSmasher May 12 '14 at 20:20
3

Can you edit your post to show the output of `System.out.println(database.getPrintDate());` – durron597 May 12 '14 at 20:24
possible duplicate of [Java Date - Insert into database](http://stackoverflow.com/questions/1081234/java-date-insert-into-database) – Basil Bourque Jul 03 '15 at 19:04

Insert Date into a database from java

0 Answers0