Unable to Create JDBC Connection in VS Code - The runtime Java language worker could not be found.

[hrenato-bt]

Severity

P3 - Medium (Minor functionality affected)

Describe the Bug with repro steps

Description

I’m running into errors when trying to configure a JDBC connection in my workflow using VS Code.
I’ve tried placing the JDBC driver JARs in different locations, but I keep getting different errors depending on where the files are located.

---

JARs placed in the workflow root (lib/builtInOperationSdk)

When the JARs were placed here, I received this error:

Failed to create connection: JDBC client library is missing. Please add pre-requisites JDBC Connector client library assemblies to the workflow application.
This suggested that the connector wasn’t detecting the JDBC libraries at all.

JARs moved to workflow-designtime/lib/builtInOperationSdk

After moving the lib folder into the workflow-designtime folder, I now get a different error:

Failed to create connection: The runtime Java language worker could not be found. It might be due to incorrect JARs for java version 8 or host under high load.

So I have some questions about this

• Does the JDBC connector require Java 8 specifically?
• Where exactly should JDBC driver JARs be placed in a workflow project so the connector can load them correctly?
  lib/builtInOperationSdk
  workflow-designtime/lib/builtInOperationSdk

Or another folder?

• Is this error related to the JARs themselves, or is the Java worker failing to start for another reason?

NOTE: Im also testing this on my company pc which doesn't have jdk installed

What type of Logic App Is this happening in?

Standard (VSCode)

Are you experiencing a regression?

No response

Which operating system are you using?

Windows

Did you refer to the TSG before filing this issue? https://aka.ms/lauxtsg

Yes

Workflow JSON

Screenshots or Videos

Environment

• VS CODE version 1.108.2

Additional context

No response