Table-lock or Record-lock with Corticon EDC 5.4.1.4 on SQLSe

Posted by Gertjan Hendriks on 16-Jul-2015 07:24

Hi folks,


A quick question: Does EDC in Corticon 5.4.1.4 lock an entire database table (for SQLSerber 2014) when reading and writing, or does it just lock the specific records it is using? As far as I have experienced in SQLServer 2008, it does lock the entire table. But I need to be 100% sure on this with SQLServer 2014 (64-bit).

Thanks in advance for your input!

-Gertjan

Corticon - Forum
Posted by James Arsenault on 17-Jul-2015 10:58

Corticon EDC specifies the NONE for the hibernate lockmode, so no lock required.
 
SQL Server 2014 will be certified in either 5.5.1 or 5.5.2.
 
[collapse]
From: Gertjan H [mailto:bounce-hendrige@community.progress.com]
Sent: Thursday, July 16, 2015 10:27 AM
To: TU.Corticon@community.progress.com
Subject: RE: [Technical Users - Corticon] Table-lock or Record-lock with Corticon EDC 5.4.1.4 on SQLServer 2014?
 
Reply by Gertjan H

Hi Jan,

I assume SQLServer 2014 is supported in Corticon 5.5. If so, will EDC in 5.5 lock an entire table, or just a record?

Thank you,

Gertjan

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse]

All Replies

Posted by Jan Krishnamurthy on 16-Jul-2015 07:52

Gertjan,
 
SQL Server 2014 is not a certified/supported platform for Corticon 5.4.x.x version.
See : https://community.progress.com/community_groups/corticon/w/rulesworld/2555.02-progress-corticon-5-4-supported-platforms-matrix-updated.aspx
 
 
Thanks,
Jan
 
[collapse]
From: Gertjan H [mailto:bounce-hendrige@community.progress.com]
Sent: Thursday, July 16, 2015 8:25 AM
To: TU.Corticon@community.progress.com
Subject: [Technical Users - Corticon] Table-lock or Record-lock with Corticon EDC 5.4.1.4 on SQLServer 2014?
 
Thread created by Gertjan H

Hi folks,


A quick question: Does EDC in Corticon 5.4.1.4 lock an entire database table (for SQLSerber 2014) when reading and writing, or does it just lock the specific records it is using? As far as I have experienced in SQLServer 2008, it does lock the entire table. But I need to be 100% sure on this with SQLServer 2014 (64-bit).

Thanks in advance for your input!

-Gertjan

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse]

Posted by Gertjan Hendriks on 16-Jul-2015 09:26

Hi Jan,

I assume SQLServer 2014 is supported in Corticon 5.5. If so, will EDC in 5.5 lock an entire table, or just a record?

Thank you,

Gertjan

Posted by James Arsenault on 17-Jul-2015 10:58

Corticon EDC specifies the NONE for the hibernate lockmode, so no lock required.
 
SQL Server 2014 will be certified in either 5.5.1 or 5.5.2.
 
[collapse]
From: Gertjan H [mailto:bounce-hendrige@community.progress.com]
Sent: Thursday, July 16, 2015 10:27 AM
To: TU.Corticon@community.progress.com
Subject: RE: [Technical Users - Corticon] Table-lock or Record-lock with Corticon EDC 5.4.1.4 on SQLServer 2014?
 
Reply by Gertjan H

Hi Jan,

I assume SQLServer 2014 is supported in Corticon 5.5. If so, will EDC in 5.5 lock an entire table, or just a record?

Thank you,

Gertjan

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse]

Posted by Gertjan Hendriks on 28-Jul-2015 04:33

A belated "Thank you", James! :)

Any info on an estimated releasedate for 5.5.1 or 5.5.2 yet?

Posted by James Arsenault on 28-Jul-2015 09:00

Gertjan,
 
Corticon 5.5.1 is planned for September and 5.5.2 for EOY.  We have begun testing with SQLServer 2014. Assuming no major issues are found, it will be certified in 5.5.1.
 
Jim
 
[collapse]
From: Gertjan H [mailto:bounce-hendrige@community.progress.com]
Sent: Tuesday, July 28, 2015 5:33 AM
To: TU.Corticon@community.progress.com
Subject: RE: [Technical Users - Corticon] Table-lock or Record-lock with Corticon EDC 5.4.1.4 on SQLServer 2014?
 
Reply by Gertjan H

A belated "Thank you", James! :)

Any info on an estimated releasedate for 5.5.1 or 5.5.2 yet?

Stop receiving emails on this subject.

Flag this post as spam/abuse.

[/collapse]

This thread is closed