[stackoverflow] [progress Openedge Abl] Openedge Jdbc: Failure Getting Table Lock On Table...

[Vel]

In my application I am trying to add a column to the table, I will be using the column as unique identifier to update the other columns of the table.

In order to do that, i am locking the table in exclusive mode and then adding the new column UNIQ_ID. I am getting the below error while trying to alter the 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 am I missing here?

Continue reading...