Drop procedure error

[javisoft.us]

Hello,

I'm getting this error: [OPENEDGE]Failure to acquire exclusive schema lock for DDL operation. (7872) when i'm tryingto delete an store procedure in order to modify it. Nobody is connected to the DB.
Any suggestions?
Thanks so much!!

 

[durkadurka]

Mak sure u r simply runnign 1 qry at a tiem my main man. Jdbc driver not handling concurrent updates brother!!!

 

[javisoft.us]

Mak sure u r simply runnign 1 qry at a tiem my main man. Jdbc driver not handling concurrent updates brother!!!

Durkadurka thanks for the reply. I'm running only one instruction: "DROP PROCEDURE <name>"
I'm able to create more stored procedures, the problem is when you are trying to delete it. I can do the same with views: CREATE/DROP VIEW and I never got
any errors. Here are more details:

- OE Progress DB version: 10.1B
- Windows Server 2008 x64
- All the instructions are executed with SQLEXP batch.

Thanks.

 

[durkadurka]

Hello my main man. Sorry cant be more help but it sometime happen to me too, best bet is restart db if possible and making sure none else is connect. Also making sure u not having progress data dictionary or procedure editore open and connected at database at same time. It seem not like that for some reason????