HSQL db for JPA: auto incremented for a regular column

[H Paul]

This is just a regular column that I want to have it auto incremented

    @Column(name = "NUMBER", columnDefinition="int GENERATED BY DEFAULT AS IDENTITY (start with 1) ")
    @Basic
    private int number;	

After loading data, the NUMBER is always zero.

Am I missing something or doing something wrong or is HSQL db sql syntax incorrect?

[James Sutherland]

Try adding,

@GeneratedValue(IDENTITY)

See,
http://en.wikibooks.org/wiki/Java_Persistence/Identity_and_Sequencing#Sequencing

[H Paul]

0. Thanks, James.

1. From
HyperSQL User Guide
HyperSQL Database Engine (HSQLDB) 2.2

CREATE TABLE star (id INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
firstname VARCHAR(20),
lastname VARCHAR(20))
CREATE TABLE movies (starid INTEGER, movieid INTEGER PRIMARY KEY, title VARCHAR(40))
INSERT INTO star (id, firstname, lastname) VALUES (DEFAULT, 'Felix', 'the Cat')
INSERT INTO movies (starid, movieid, title) VALUES (IDENTITY(), 10, 'Felix in Hollywood')

2. Below is OK. Nothing unusual.

    @Id
    @Column(name = "ID")
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    @Basic
    private long id;

3. What I want is NOT an ID, rather a regular colum with auto-incremented.
This is OK by point 1. That's if we create using DDL itself.
But below is not OK. Could there be something else?

	@Column(name = "NUMBER")
	@GeneratedValue(strategy=GenerationType.IDENTITY) 
	private int number;