java - Openedge JDBC: Failure getting table lock on table PUB._File -

in application trying add column table, using column unique identifier update other columns of table.

in order that, locking table in exclusive mode , adding new column uniq_id. getting below error while trying alter table.

update query : lock table pub."customer" in exclusive mode

update query : alter table pub."customer" add (uniq_id integer)

java.sql.sqlexception: [datadirect][openedge jdbc driver][openedge] failure getting table lock on table pub._file.

what missing here?

directly manipulating meta schema bad idea , won't work.

you should use tools progress provides add tables, columns, indexes etc.