Unable to Create JDBC Connection in VS Code - The runtime Java language worker could not be found.
- Dominant language
- TypeScript
- Stars
- 111
- Forks
- 109
- Avg merge
- 1d 23h
- Merged PRs (30d)
- 20
Description
### 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:
```json
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:
```json
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
```json
```
### Screenshots or Videos
### Environment
- VS CODE version 1.108.2
### Additional context
_No response_
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.