ALTER TABLE statement cannot add an IDENTITY column to a table.

[serefayar]

Hi, i newbie for lift and scala.. im using eclipse. i create project by maven and i try to run. thats all bu i get :

INFO - CREATE TABLE users (id BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY , firstname VARCHAR(32) , lastname VARCHAR(32) , email VARCHAR(48) , locale VARCHAR(16) , timezone VARCHAR(32) , password_pw VARCHAR(48) , password_slt VARCHAR(20) , textarea VARCHAR(2048) , superuser SMALLINT , validated SMALLINT , uniqueıd VARCHAR(32))
INFO - ALTER TABLE users ADD CONSTRAINT users_PK PRIMARY KEY(id)
INFO - ALTER TABLE users ADD COLUMN id BIGINT NOT NULL GENERATED ALWAYS AS IDENTITY
ERROR - Failed to Boot
java.sql.SQLSyntaxErrorException: ALTER TABLE statement cannot add an IDENTITY column to a table.
at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)

[aboisvert]

Can you provide some additional information on how to reproduce this? Are you building the pocketchange application?

[indrajitr]

Moved to Assembla: http://www.assembla.com/spaces/liftweb/tickets/115

[github-importer]

Imported from GitHub: http://github.com/dpp/liftweb/issues/115/find

[nafg]

Updating tickets (#115, #233, #251, #299, #300, #301, #302, #200, #258)

[dpp]

I can't reproduce this. I just fired up a new project with Derby and a new Derby DB is created correctly.

[indrajitr]

Updating tickets (#416, #371, #115, #417, #488)

[github-importer]

Imported from Assembla: http://www.assembla.com/spaces/liftweb/tickets/115