lochdsmile
New Member
Hi All,
I am new to Progress SQL9.2. I am doing my project that using OpenEdge as a database. My application using JDBC to connect to database and excuting sql statement such as SELECT, DELETE, INSERT, CREATE TRIGGER, DROP TRIGER, CREATE TABLE, DROP TABLE statement (both of DDL and DML).
It is OK when I create table, trigger via JDBC but i get a errors when I DROP TABLE or TRIGER (using JDBC).
Here is the error:
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Failure to
acquire exclusive schema lock for DDL.
Anyone, Please help me to fix it.
Many thanks,
Rokku,
I am new to Progress SQL9.2. I am doing my project that using OpenEdge as a database. My application using JDBC to connect to database and excuting sql statement such as SELECT, DELETE, INSERT, CREATE TRIGGER, DROP TRIGER, CREATE TABLE, DROP TABLE statement (both of DDL and DML).
It is OK when I create table, trigger via JDBC but i get a errors when I DROP TABLE or TRIGER (using JDBC).
Here is the error:
[DataDirect][OpenEdge JDBC Driver][OpenEdge] Failure to
acquire exclusive schema lock for DDL.
Anyone, Please help me to fix it.
Many thanks,
Rokku,