{"id":503,"date":"2020-08-06T21:42:10","date_gmt":"2020-08-06T21:42:10","guid":{"rendered":"https:\/\/servoycomponents.com\/?p=503"},"modified":"2021-03-05T18:04:50","modified_gmt":"2021-03-05T18:04:50","slug":"progress-openedge-jdbc-no-lock-driver","status":"publish","type":"post","link":"https:\/\/servoycomponents.com\/components\/plugins\/progress-openedge-jdbc-no-lock-driver","title":{"rendered":"Progress OpenEdge JDBC No Lock Driver"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><p>[vc_row][vc_column][vc_text_separator title=&#8221;OVERVIEW&#8221; i_icon_fontawesome=&#8221;fa fa-home&#8221; i_color=&#8221;custom&#8221; add_icon=&#8221;true&#8221; el_id=&#8221;overview&#8221; i_custom_color=&#8221;#126790&#8243;][vc_column_text]The Servoy Progress OpenEdge JDBC No Lock Driver is a drop-in wrapper to the official openedge.jar driver which adds functionality to expand concurrency by avoiding database locks.[\/vc_column_text][vc_text_separator title=&#8221;BENEFITS&#8221; i_icon_fontawesome=&#8221;fa fa-lightbulb-o&#8221; i_color=&#8221;custom&#8221; add_icon=&#8221;true&#8221; el_id=&#8221;benefits&#8221; i_custom_color=&#8221;#126790&#8243;][vc_column_text]<\/p>\n<ul class=\"square\">\n<li>Avoids getting this error:\u00a0&#8220;Failure to get record lock on a record from table &lt;tablename&gt;&#8221; when running SELECT queries<\/li>\n<li>Automatically adds &#8221;\u00a0WITH (NOLOCK)&#8221; to the end of every SELECT query ran through the driver, including Servoy generated and ad-hoc queries.<\/li>\n<\/ul>\n<p>[\/vc_column_text][vc_text_separator title=&#8221;COMPATIBILITY&#8221; i_icon_fontawesome=&#8221;fa fa-chain-broken&#8221; i_color=&#8221;custom&#8221; add_icon=&#8221;true&#8221; el_id=&#8221;compatibility&#8221; i_custom_color=&#8221;#126790&#8243;][vc_column_text]<\/p>\n<ul>\n<li>OpenEdge 10.1A02 and later.<\/li>\n<li>All versions of Servoy<\/li>\n<li>Java 8+<\/li>\n<li>Also works with other Java tools besides Servoy. Any JDBC connection can utilize this driver.<\/li>\n<\/ul>\n<p>[\/vc_column_text][vc_text_separator title=&#8221;DOCUMENTATION&#8221; i_icon_fontawesome=&#8221;fa fa-code&#8221; i_color=&#8221;custom&#8221; add_icon=&#8221;true&#8221; el_id=&#8221;documentation&#8221; i_custom_color=&#8221;#126790&#8243;][vc_column_text]How to use:<\/p>\n<ul>\n<li>Since this component is a JDBC Driver, it is not part of the Components Installer (IT2BE Manager) like the rest of our components.\u00a0 After you sign up for the 30 day trial, you&#8217;ll receive an email from us with links to download your trial components.\u00a0 After purchase, we&#8217;ll send you the fully licensed component.<\/li>\n<li>The component includes the itech-openedge-nolock.jar driver and the config file,\u00a0itech-openedge-nolock.properties<\/li>\n<li>In Servoy Developer, place both of those in your &lt;servoy_install&gt;\/application_server\/drivers folder\n<ul>\n<li>Also make sure you have the official openedge.jar in that folder as well<\/li>\n<\/ul>\n<\/li>\n<li>In Servoy Developer, edit your DB connection settings, and change the Driver property from &#8220;com.ddtec.jdbc.openedge.OpenEdgeDriver&#8221; to &#8220;com.itechpros.drivers.openedge.NoLockDriver&#8221;.\u00a0 You should see that as a selectable option from the drop-down. If you don&#8217;t, double check it is installed correctly.<\/li>\n<li>For Servoy Developer, that completes the install and configuration.<\/li>\n<li>For Servoy Application Server or WAR deployment, the\u00a0itech-openedge-nolock.properties must exist in one of these places\n<ul>\n<li>The same directory the driver is in\u00a0 <em>(for non-WAR deployment)<\/em><\/li>\n<li>{SERVOY_USER_HOME}\/.servoy\/{context}\/\u00a0 <em>(for WAR deployment)<\/em><\/li>\n<li>{USER_HOME}\/.servoy\/{context}\/\u00a0<em> (for WAR deployment)<\/em><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>[\/vc_column_text][vc_text_separator title=&#8221;BUY NOW&#8221; i_icon_fontawesome=&#8221;fa fa-credit-card&#8221; i_color=&#8221;custom&#8221; add_icon=&#8221;true&#8221; el_id=&#8221;buynow&#8221; i_custom_color=&#8221;#126790&#8243;][vc_row_inner][vc_column_inner width=&#8221;1\/3&#8243;]<div class=\"pricing-box  pricing-box-box\"><div class=\"plan-header\"><h2 class=\"title\">Server<\/h2><div class=\"price\"><sup class=\"currency\">$<\/sup><span>399<\/span><sup class=\"period\"><\/sup><\/div><hr class=\"hr_color\" \/><p class=\"subtitle\"><big>Single Server<\/big><\/p><\/div><div class=\"plan-inside\"><span class=\"pi-content\"><\/p>\n<ul>\n<li>+35% p\/y<br \/>\nmaintenance fee<\/li>\n<\/ul>\n<p><\/span><\/div><div class=\"plan-footer\"><a href=\"https:\/\/subscriptions.zoho.com\/subscribe\/ecd30e00d022efa2293b765c8525987479bc88ff48c14354ad482bf477cf719e\/openedge-driver-server\" class=\"button button_theme has-icon\"  title=\"Free Trial\"><span class=\"button_icon\"><i class=\"icon-credit-card\" aria-hidden=\"true\"><\/i><\/span><span class=\"button_label\">Free Trial<\/span><\/a><\/div><\/div>\n[\/vc_column_inner][\/vc_row_inner][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p>Drop-in wrapper to the official OpenEdge driver which adds functionality to expand concurrency by avoiding database locks.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"_links":{"self":[{"href":"https:\/\/servoycomponents.com\/wp-json\/wp\/v2\/posts\/503"}],"collection":[{"href":"https:\/\/servoycomponents.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/servoycomponents.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/servoycomponents.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/servoycomponents.com\/wp-json\/wp\/v2\/comments?post=503"}],"version-history":[{"count":9,"href":"https:\/\/servoycomponents.com\/wp-json\/wp\/v2\/posts\/503\/revisions"}],"predecessor-version":[{"id":629,"href":"https:\/\/servoycomponents.com\/wp-json\/wp\/v2\/posts\/503\/revisions\/629"}],"wp:attachment":[{"href":"https:\/\/servoycomponents.com\/wp-json\/wp\/v2\/media?parent=503"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/servoycomponents.com\/wp-json\/wp\/v2\/categories?post=503"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/servoycomponents.com\/wp-json\/wp\/v2\/tags?post=503"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}