Java DB error when creating a table in Netbeans

Question

I am creating a table within my database in Netbeans (Java DB).

I have created the database and I am connected to it.

This is my first and only table:

enter image description here

and the error I am receiving is this:

enter image description here

I am an amateur when it comes to databases and I have tried searching high and low to find what I'm doing wrong. I've tried:

Changing the table name to all lower case, all capitals and how it is now too.
Changing the primary key.
Changing the column names.
Changing the size of the column uid (which is fixed to 0 unless the data type is changed - I assume for obvious reasons this is correct anyway)

Where am I going wrong?

user462963 · Accepted Answer · 2013-01-26 12:24:55Z

2

User is a reserved keyword in many databases. You should choose another name, or add quotation marks (") around the table name.

answered Jan 26, 2013 at 12:24

user462963

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

1 Comment

Thanks! - Decided to call it Person.