René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Plugin fails when Oracle enforces network encryption (AES256/SHA512)","articleBody":"## Plugin fails when Oracle enforces network encryption (AES256/SHA512)\n\nHello,\nAfter our Oracle DBAs enabled **mandatory encrypted communication** on one of our environments, the utPLSQL plugin for PL/SQL Developer stopped working:\n\nIn other environments where encryption is not yet enforced, the plugin continues to work correctly. The issue started immediately after the encryption configuration was introduced.\nI needed to add `(Security=(ENCRYPTION_CLIENT=REQUIRED)(ENCRYPTION_TYPES_CLIENT=AES256)(CRYPTO_CHECKSUM_CLIENT=REQUIRED)(CRYPTO_CHECKSUM_TYPES_CLIENT=SHA512))` to connections in tnsnames.ora. PLSQL Developer works correctly with mandatory encryption.\n\n---\n\n### What happens\n\n- After clicking **\"Run tests\"**, the UI shows _“Running tests...”_, but **no tests are actually executed**.\n  \u003cimg width=\"465\" height=\"350\" alt=\"Image\" src=\"https://github.com/user-attachments/assets/2e7f8bb8-81e6-4450-ac80-909056e0b4d2\" /\u003e\n\n- No tests are running on the database (verified via logs).\n- When clicking **\"Abort\"**, the plugin throws:\n  \u003cimg width=\"424\" height=\"142\" alt=\"Image\" src=\"https://github.com/user-attachments/assets/d772901a-c1c7-49c1-823e-0a1e74b640dd\" /\u003e\n```\nSee the end of this message for details on invoking \njust-in-time (JIT) debugging instead of this dialog box.\n\n************** Exception Text **************\nSystem.InvalidOperationException: Connection must be open for this operation\n   at Oracle.ManagedDataAccess.Client.OracleCommand.ValidateStatePriorToExecution()\n   at Oracle.ManagedDataAccess.Client.OracleCommand.ExecuteNonQuery()\n   at utPLSQL.RealTimeTestRunner.UtRun(String id, List`1 paths)\n   at System.Threading.Tasks.Task.Execute()\n--- End of stack trace from previous location where exception was thrown ---\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\n   at utPLSQL.RealTimeTestRunner.\u003cRunTestsAsync\u003ed__0.MoveNext()\n--- End of stack trace from previous location where exception was thrown ---\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\n   at utPLSQL.TestRunnerWindow.\u003cRunTestsAsync\u003ed__26.MoveNext() in c:\\Users\\simon\\Workspace\\utPLSQL\\utPLSQL-PLSQL-Developer\\PlsqlDeveloperUtPlsqlPlugin\\utPLSQL.Ui\\TestRunnerWindow.cs:line 158\n--- End of stack trace from previous location where exception was thrown ---\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\n   at utPLSQL.TestRunnerWindow.\u003cbtnRun_Click\u003ed__52.MoveNext() in c:\\Users\\simon\\Workspace\\utPLSQL\\utPLSQL-PLSQL-Developer\\PlsqlDeveloperUtPlsqlPlugin\\utPLSQL.Ui\\TestRunnerWindow.cs:line 656\n--- End of stack trace from previous location where exception was thrown ---\n   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\n\n\n************** Loaded Assemblies **************\nmscorlib\n    Assembly Version: 4.0.0.0\n    Win32 Version: 4.8.9300.0 built by: NET481REL1LAST_C\n    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v4.0.30319/mscorlib.dll\n----------------------------------------\nPlsqlDeveloperUtPlsqlPlugin\n    Assembly Version: 1.2.4.0\n    Win32 Version: 1.2.4.0\n    CodeBase: file:///C:/Users/cen57757/OneDrive%20-%20Erste%20Group/Dokumenty/plsql%20developer%20plugins/PlsqlDeveloperUtPlsqlPlugin.dll\n----------------------------------------\nSystem\n    Assembly Version: 4.0.0.0\n    Win32 Version: 4.8.9282.0 built by: NET481REL1LAST_C\n    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll\n----------------------------------------\nutPLSQL.UI\n    Assembly Version: 1.2.4.0\n    Win32 Version: 1.2.4.0\n    CodeBase: file:///C:/Users/cen57757/OneDrive%20-%20Erste%20Group/Dokumenty/plsql%20developer%20plugins/PlsqlDeveloperUtPlsqlPlugin.dll\n----------------------------------------\nSystem.Windows.Forms\n    Assembly Version: 4.0.0.0\n    Win32 Version: 4.8.9251.0 built by: NET481REL1LAST_C\n    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll\n----------------------------------------\nSystem.Drawing\n    Assembly Version: 4.0.0.0\n    Win32 Version: 4.8.9032.0 built by: NET481REL1\n    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll\n----------------------------------------\nSystem.Data\n    Assembly Version: 4.0.0.0\n    Win32 Version: 4.8.9214.0 built by: NET481REL1LAST_B\n    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll\n----------------------------------------\nSystem.Core\n    Assembly Version: 4.0.0.0\n    Win32 Version: 4.8.9297.0 built by: NET481REL1LAST_C\n    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll\n----------------------------------------\nSystem.Xml\n    Assembly Version: 4.0.0.0\n    Win32 Version: 4.8.9032.0 built by: NET481REL1\n    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll\n----------------------------------------\nSystem.Configuration\n    Assembly Version: 4.0.0.0\n    Win32 Version: 4.8.9032.0 built by: NET481REL1\n    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll\n----------------------------------------\nFontAwesome.Sharp\n    Assembly Version: 5.15.3.0\n    Win32 Version: 1.2.4.0\n    CodeBase: file:///C:/Users/cen57757/OneDrive%20-%20Erste%20Group/Dokumenty/plsql%20developer%20plugins/PlsqlDeveloperUtPlsqlPlugin.dll\n----------------------------------------\nColorProgressBar\n    Assembly Version: 1.2.4.0\n    Win32 Version: 1.2.4.0\n    CodeBase: file:///C:/Users/cen57757/OneDrive%20-%20Erste%20Group/Dokumenty/plsql%20developer%20plugins/PlsqlDeveloperUtPlsqlPlugin.dll\n----------------------------------------\nSystem.Numerics\n    Assembly Version: 4.0.0.0\n    Win32 Version: 4.8.9032.0 built by: NET481REL1\n    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll\n----------------------------------------\nPresentationCore\n    Assembly Version: 4.0.0.0\n    Win32 Version: 4.8.9297.0 built by: NET481REL1LAST_C\n    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/PresentationCore/v4.0_4.0.0.0__31bf3856ad364e35/PresentationCore.dll\n----------------------------------------\nWindowsBase\n    Assembly Version: 4.0.0.0\n    Win32 Version: 4.8.9297.0 built by: NET481REL1LAST_C\n    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/WindowsBase/v4.0_4.0.0.0__31bf3856ad364e35/WindowsBase.dll\n----------------------------------------\nPresentationFramework\n    Assembly Version: 4.0.0.0\n    Win32 Version: 4.8.9297.0\n    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/PresentationFramework/v4.0_4.0.0.0__31bf3856ad364e35/PresentationFramework.dll\n----------------------------------------\nSystem.Xaml\n    Assembly Version: 4.0.0.0\n    Win32 Version: 4.8.9297.0 built by: NET481REL1LAST_C\n    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xaml/v4.0_4.0.0.0__b77a5c561934e089/System.Xaml.dll\n----------------------------------------\nutPLSQL.Api\n    Assembly Version: 1.5.6.0\n    Win32 Version: 1.2.4.0\n    CodeBase: file:///C:/Users/cen57757/OneDrive%20-%20Erste%20Group/Dokumenty/plsql%20developer%20plugins/PlsqlDeveloperUtPlsqlPlugin.dll\n----------------------------------------\nOracle.ManagedDataAccess\n    Assembly Version: 4.122.19.1\n    Win32 Version: 1.2.4.0\n    CodeBase: file:///C:/Users/cen57757/OneDrive%20-%20Erste%20Group/Dokumenty/plsql%20developer%20plugins/PlsqlDeveloperUtPlsqlPlugin.dll\n----------------------------------------\nSystem.Transactions\n    Assembly Version: 4.0.0.0\n    Win32 Version: 4.8.9032.0 built by: NET481REL1\n    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll\n----------------------------------------\nSystem.Web\n    Assembly Version: 4.0.0.0\n    Win32 Version: 4.8.9282.0 built by: NET481REL1LAST_C\n    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.Web/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Web.dll\n----------------------------------------\nSystem.EnterpriseServices\n    Assembly Version: 4.0.0.0\n    Win32 Version: 4.8.9032.0 built by: NET481REL1\n    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_64/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll\n----------------------------------------\n\n************** JIT Debugging **************\nTo enable just-in-time (JIT) debugging, the .config file for this\napplication or computer (machine.config) must have the\njitDebugging value set in the system.windows.forms section.\nThe application must also be compiled with debugging\nenabled.\n\nFor example:\n\n\u003cconfiguration\u003e\n    \u003csystem.windows.forms jitDebugging=\"true\" /\u003e\n\u003c/configuration\u003e\n\nWhen JIT debugging is enabled, any unhandled exception\nwill be sent to the JIT debugger registered on the computer\nrather than be handled by this dialog box.\n```\n\nAs more Oracle installations move toward encrypted communication, this plugin becomes unusable unless it supports those configurations.\n\nI’d be happy to help test a fix or submit a PR if guidance is provided.\n\nThanks for your work on this plugin. \n\n","author":{"url":"https://github.com/rbilek-cen57757","@type":"Person","name":"rbilek-cen57757"},"datePublished":"2025-07-14T08:39:30.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/32/utPLSQL-PLSQL-Developer/issues/32"}