How to create sequence based (SERIAL) primary key?

[Former Member]

Does anybody know any workaround to modify dictionary table outside Web Dynpro?

I specify default column value in SQL Studio:

ALTER TABLE PB_ORGANIZATION COLUMN ORG_ID ADD DEFAULT SERIAL(1)

Everything is OK, but when I try to insert values in modified table from Web Dinpro EJB application I get the error:

com.sap.engine.services.ejb.exceptions.
BaseReliableNoSuchEntityException: The entity does not 
exist in the database. Its value in the cache has to be
refreshed.

It seems WebAS keeps some metadata, generated by Web Dynpro, and manual changes in a database table put it out of sync with this metadata.

I need serial primary keys in my project. Is it possible to solve the above problem?

[Former Member]

Could you please post the SQL query also !

Are you getting this error in SQL studio ?

Regards, Anilkumar

[Former Member]

I'll better send You entire application. It has Web Service frontend (PhoneBook) which can be used for testing. Method createOrganization() throws the exception.

No, this error appears in EJB application only.

BTW, I have even made attempt to replace <default-value>0</default-value> by <default-value>SERIAL(1)</default-value> but it didn't help.