V
Vel
Guest
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...
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...