cancel
Showing results for 
Search instead for 
Did you mean: 

error with date field when inserting records into sql server from webdynpro

Former Member
0 Kudos

Dear SDN's,

I am trying to insert the records into sql server through my webDynpro program.

I have created a date field in a dictionary with the datatype date.

In my webdynpro program to insert the date i am following the below format.

String dateString = "2006/12/10";

java.util.Date d=new java.util.Date(dateString);

java.sql.Date <b>date</b> = new java.sql.Date(d.getTime());

int i=stmt.executeUpdate("INSERT INTO TRAVEL_HEADER(TRQID,PROJECTID,<b>REQDT</b>,ADVCE,ETADV,PURTR) values(21, '555-1212', '" + <b>date</b> + "', 5000, '20060501','hi')");

when i try to execute it, it gives the following error.

<b>com.sap.sql.log.OpenSQLException: The SQL statement "INSERT INTO "TRAVEL_HEADER" ("TRQID","PROJECTID","REQDT","ADVCE","ETADV","PURTR") VALUES (21,'555-1212','2006-12-10',5000,'20060501','hi')" contains the semantics error[s]: - type check error: new value (element number 3 (CHAR)) is not assignable to column >>REQDT<< (DATE)</b>

Please correct me.

Your help will be appreciated.

Regards,

Sireesha.B

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Try using

int i=stmt.executeUpdate("INSERT INTO TRAVEL_HEADER(TRQID,PROJECTID,REQDT,ADVCE,ETADV,PURTR) values(21, '555-1212', " + date + ", 5000, '20060501','hi')");

Regards, Anilkumar

Former Member
0 Kudos

Hi Anil,

i have tried it already but it is giving same as the previous error, instead of CHAR it is showing initnumeric.

Regards,

Sireesha.B

Former Member
0 Kudos

Hi,

int i=stmt.executeUpdate("INSERT INTO TRAVEL_HEADER(TRQID,PROJECTID,REQDT,ADVCE,ETADV,PURTR) values(21, '555-1212', 'date', 5000, '20060501','hi')");

try like this.

I Think in SQL the general format to take date as input like this.

INSERT INTO X VALUES ('10/30/56')

thaks,

Lohi.

Former Member
0 Kudos

Hi Lohita,

Thanks for ur reply.

I have tried in that format also.

Still it is giving the error.

Thanks & Regards,

Sireesha.B

Former Member
0 Kudos

Change the SQL datatype to "DateTime" and try

Regards, ANilkumar

Former Member
0 Kudos

Hi Anil,

In java Dictionary we don't have a datatype called, "dateTime".

Thanks & Regards,

Sireesha.B