Enumeration mapping doesn't work in JPA

[Vladimir Kroupa]

Hi,
I'm stuck on this problem and I'd like to ask you guys for help. I'm having trouble mapping an Enumeration using JPA annotations.
I'm using Hibernate 3.5.6 as a persistence provider and I'm also using Spring ORM (version 3.0.4).
One of my entities has an enum field. This entity doesn't get a corresponding table generated.

I'm getting following errors:

Unsuccessful: create table Player (id bigint generated by default as identity (start with 1), birthDate date, firstName varchar(255), position integer, surname varchar(255), primary key (id))
Unexpected token: POSITION in statement [create table Player (id bigint generated by default as identity (start with 1), birthDate date, firstName varchar(255), position]

If I remove the enumeration field, then Hibernate creates the table for this entity without problems.
Here is the entity class:

@Entity
public class Player implements Serializable {

    // this is the enumeration
    @Enumerated(EnumType.ORDINAL)
    private Position position;
    @Id
    @GeneratedValue( strategy = GenerationType.AUTO )
    private Long id;
    private String firstName;
    private String surname;
    @Temporal(value=TemporalType.DATE)
    private Date birthDate;
...

The class for this enumeration looks like this:

public enum Position {

    DEFENDER( 0 ),
    FORWARD( 1 ),
    GOALKEEPER( 2 ),
    MIDFIELDER( 3 );
    private int number;

    private Position( int number ) {
        this.number = number;
    }

Does anyone have any ideas? I just can't see what's wrong with the mapping. Without the Position enum, everything works OK.

[Vladimir Kroupa]

Well, it looks like that position is a reserved SQL keyword. Who would have thought that...