SQL statement SQLSyntaxErrorException

Question

I'm getting an error executing the following SQL statement:

String sql = "CREATE TABLE RESERVATION (";
sql = sql + " UID VARCHAR,";
sql = sql + " ISBN INTEGER,";
sql = sql + " DATEISSUE DATE,";
sql = sql + " DATERETURN DATE,";
sql = sql + " FOREIGN KEY (UID) REFERENCES USERS (UID),";
sql = sql + " FOREIGN KEY (ISBN) REFERENCES BOOKS (ISBN) )";

Here is the error I am getting:

java.sql.SQLSyntaxErrorException: Syntax error: Encountered "," at line 1, column 39.

VARCHAR(SIZE) maybe?

Luiggi Mendoza
– Luiggi Mendoza

2013-04-18 21:07:44 +00:00
Commented Apr 18, 2013 at 21:07 — Luiggi Mendoza
– Luiggi Mendoza, Commented Apr 18, 2013 at 21:07

paxdiablo · Accepted Answer · 2013-04-18 21:12:56Z

2

Column 39 is near the end of the varchar, so you probably need a size for it, such as varchar(20).

answered Apr 18, 2013 at 21:12

paxdiablo

888k243 gold badges1.6k silver badges2k bronze badges

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

1 Comment

farhan ansari Over a year ago

Thanks i was ignoring that and looking at different thins Thanks.

Collectives™ on Stack Overflow

SQL statement SQLSyntaxErrorException

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