insert date value into oracle using java not working

Question

I'm trying to insert date format into Oracle from Java EE Eclipes. I'm able to insert a null value but not date value. The date prints out in the console okay but does not update the database. Here are my queries:

Inserting Date value: (NOT WORKING) Console output for uDate = 20/Sep/16

public void updateUnsubscribe(String empid) { 
  DateFormat df = new SimpleDateFormat("dd/MMM/yy");
  String uDate = df.format(new Date());
  String unSub = "udate MYDB set edate ='" + uDate + '" where emp = "empid"';
}

Inserting NULL value: (WORKING) Console output for uDate = null

public void updateSubscribe(String empid) { 
  Date toNull = null;
  String sub = "udate MYDB set edate ='" + toNull + '" where emp = "empid"';
}

I don't get any errors, at all, the only issue is the date field not inserting the date. What am I missing? Am I not formatting my date field correctly.

Your DateFormat is probably wrong (try d.d./MM/yy)

dsp_user
– dsp_user

2016-09-20 11:39:49 +00:00
Commented Sep 20, 2016 at 11:39 — dsp_user
– dsp_user, Commented Sep 20, 2016 at 11:39
what's your date format in oracle? is it same as dd/MMM/yy?

Sunil Lulla
– Sunil Lulla

2016-09-20 11:40:14 +00:00
Commented Sep 20, 2016 at 11:40 — Sunil Lulla
– Sunil Lulla, Commented Sep 20, 2016 at 11:40
output is like this 'Tue SEp 20 11:45:02 UTC 2016'

Gee
– Gee

2016-09-20 11:46:16 +00:00
Commented Sep 20, 2016 at 11:46 — Gee
– Gee, Commented Sep 20, 2016 at 11:46

mv200580 · Accepted Answer · 2016-09-20 11:52:31Z

2

You could use oracle to_date function to convert varchar to date value, for your example:

public void updateUnsubscribe(String empid) { 
  DateFormat df = new SimpleDateFormat("dd/MM/yy");
  String uDate = df.format(new Date());
  String unSub = "udate MYDB set edate =to_date('" + uDate + ', 'dd/MM/yyyy')" where emp = "empid"';
}

But rather that, it is better to use JDBC PreparedStatement for this task:

public void updateUnsubscribe(String empid) { 
  PreparedStatement ps = conn.prepareStatement("update MYDB set edate=? where emp=?");
  ps.setTimestamp(1, new java.sql.Timestamp(new Date()));
  ps.setString(2, empid);
  ps.executeUpdate();
}

edited Sep 20, 2016 at 11:52

answered Sep 20, 2016 at 11:46

mv200580

7421 gold badge6 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

insert date value into oracle using java not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related