insert into timestamp oracle column from java

Question

i got a table made in this way

CREATE TABLE WS_NAPACQ00T
( IDE_IDEN varchar2(20) PRIMARY KEY NOT NULL,
  CLB_CXML CLOB,
  SYS_DATE TIMESTAMP
);

and this java code to put in dt_date current date.

Timestamp dt_date = new Timestamp(System.currentTimeMillis());
String insertXML = "insert into WS_NAPACQ00T (IDE_IDEN, CLB_CXML, SYS_DATE) values ('10', 'test', '"+dt_date+"' ) ";
result = statement.executeQuery(insertXML);

the error is:

"not a valid month"

how can i resolve?

you need to convert the java timestamp into oracle timestamp format.. — Srinivas B
– Srinivas B, Commented Dec 1, 2014 at 11:59
how is possible convert from java timestamp into oracle timestamp? — RudiDudi
– RudiDudi, Commented Dec 1, 2014 at 12:02
Use a PreparedStatement (side benefit of protection against SQL injection) and call setTimestamp. — Xavi López
– Xavi López, Commented Dec 1, 2014 at 12:06

seenukarthi · Accepted Answer · 2014-12-01 13:08:19Z

4

Don't use Statement it can lead to SQLInjection, instead use PreparedStatement as follows.

String insertXML = "insert into WS_NAPACQ00T (IDE_IDEN, CLB_CXML, SYS_DATE) values (?, ?, ?) ";
PreparedStatement statement = connection.prepareStatement(insertXML);
statement.setString(1,"10");
statement.setString(2,"test");
statement.setTimestamp(3, new Timestamp(System.currentTimeMillis()));
result = statement.executeQuery();

Unrelated.

If you want to insert current timestamp you can use CURRENT_TIMESTAMP. SELECT CURRENT_TIMESTAMP from DUAL; will give the current timestamp.

edited Dec 1, 2014 at 13:08

answered Dec 1, 2014 at 12:10

seenukarthi

8,80510 gold badges51 silver badges75 bronze badges

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

2 Comments

RudiDudi Over a year ago

Perfect, it runs well. but apart the security, i don't understand why with prepared statement it runs ok, but with normal statement it goes in error.

seenukarthi Over a year ago

In normal statement you have to construct the query as you do in a SQL client like sqlplus.

Collectives™ on Stack Overflow

insert into timestamp oracle column from java

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related