I got syntax error for SQL on java, where there isn't any error

Question

Yeah,this is reall weired, we are using microsoft access 2010 for java ... then here is my printout sql statement

DB Query:

INSERT INTO FileShare(source,destination,date)
VALUES ('C:\Users\JunHai\Documents\Scenario.docx',
          'C:\Users\JunHai\Desktop\dfdfd.docx','29/01/2011 00:34:33')

It totally seems alright, but it just keeping giving me syntax error ... who can really see the problem ?

Date's a reserved name, you'll have to surround it with backticks — Marc B
– Marc B, Commented Jan 28, 2011 at 16:51
Post it as an answer @marc-b, the questoin deserves one, but it feels wrong to post you answer :) — Nanne
– Nanne, Commented Jan 28, 2011 at 16:57

Marc B · Accepted Answer · 2011-01-28 17:10:23Z

4

Date's a reserved name, you'll have to surround it with backticks (`)

answered Jan 28, 2011 at 17:10

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

1 Comment

Fionnuala Over a year ago

If this is being inserted into an Access database using JDBC, why to you use back ticks and not square brackets - [Date] - which would be standard for MS Access?

Collectives™ on Stack Overflow

I got syntax error for SQL on java, where there isn't any error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related