SQL trigger not working for java function apps
Nobody has claimed this yet.
Assessment
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Newbie friendliness
- 25/100
Research direction
Start with the Java function shown in the issue, host.json, and the generated extensions.csproj, then compare their configuration with the linked Azure SQL trigger tutorial and the added azure-functions-java-library-sql dependency. Reproduce the missing sqlTrigger binding and the Microsoft.Data.SqlClient platform error using the reported Core Tools and .NET versions. Done means the Java SQL trigger is discovered and its listener starts without either error.
Written by the indexing model from the issue text.
Description
I try to create a SQL trigger in a java function app. However I get this error:
Azure Functions Core Tools
Core Tools Version: 4.0.5413 Commit hash: N/A (64-bit)
Function Runtime Version: 4.25.3.21264
[2023-10-23T10:55:58.376Z] No job functions found. Try making your job classes and methods public. If you're using binding extensions (e.g. Azure Storage, ServiceBus, Timers, etc.) make sure you've called the registration method for the extension(s) in your startup code (e.g. builder.AddAzureStorage(), builder.AddServiceBus(), builder.AddTimers(), etc.).
[2023-10-23T10:55:58.403Z] The 'MySQLTrigger' function is in error: The binding type(s) 'sqlTrigger' were not found in the configured extension bundle. Please ensure the type is correct and the correct version of extension bundle is configured.
For detailed output, run func with --verbose flag.
Here is my java code:
@FunctionName("MySQLTrigger")
public void run(
@SQLTrigger(
name = "items",
tableName = "[dbo].[TodoItem]",
connectionStringSetting = "SqlConnectionString")
TodoItems[] items,
final ExecutionContext context) {
...
}
Here is my host.json:
{
"version": "2.0",
"extensionBundle": {
"id": "Microsoft.Azure.Functions.ExtensionBundle",
"version": "[4.*, 5.0.0)"
}
}
I also tried removing the extension bundle and installing the sql extension directly by running this command:
func extensions install --package Microsoft.Azure.WebJobs.Extensions.Sql --version 3.0.396
which creates a file named extensions.csproj in my root folder and results in this error message:
[2023-10-23T11:03:11.118Z] Failed to start SQL trigger listener for table: 'partner.kontaktmapping', function ID: '302b12208735c890'. Exception: System.PlatformNotSupportedException: Microsoft.Data.SqlClient is not supported on
this platform.
[2023-10-23T11:03:11.119Z] at Microsoft.Data.SqlClient.SqlConnection..ctor(String connectionString)
[2023-10-23T11:03:11.120Z] at Microsoft.Azure.WebJobs.Extensions.Sql.SqlTriggerListener`1.StartAsync(CancellationToken cancellationToken)
[2023-10-23T11:03:11.121Z] The listener for function 'Functions.PartnerSenderCosmosDBTrigger' was unable to start.
[2023-10-23T11:03:11.123Z] The listener for function 'Functions.PartnerSenderCosmosDBTrigger' was unable to start. Microsoft.Data.SqlClient: Microsoft.Data.SqlClient is not supported on this platform.
This is the output of dotnet --info
dotnet --info
.NET SDK:
Version: 7.0.402
Commit: 791db8e2d8
Laufzeitumgebung:
OS Name: Windows
OS Version: 10.0.19045
OS Platform: Windows
RID: win10-x64
Base Path: C:\Program Files\dotnet\sdk\7.0.402\
Environment variables:
Not set
global.json file:
Not found
Learn more:
https://aka.ms/dotnet/info
Download .NET:
https://aka.ms/dotnet/download
I'd expect SQLTrigger to work as stated in this tutorial.
In addition to this tutorial I had to install the additional maven dependencies azure-functions-java-library-sql that was not mentioned in the tutorial. I have absolutely no experience working with dotnet and its runtime environment and development kits, so I might have done a mistake somewhere or missed some more steps needed.
If you need some more information on my setup, please let me know. I'm looking forward to any news on this.
- Dominant language
- Java
- Stars
- 45
- Forks
- 49
- PR merge metrics
- No merged PRs in 30d
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from Azure/azure-functions-java-library
-
area:java-functions
Difficulty 4/5 3-5 days Newbie friendliness 48/100
Azure/azure-functions-java-library#229 · 1 comment ·
-
area:java-functions
Difficulty 4/5 3-5 days Newbie friendliness 35/100
Azure/azure-functions-java-library#222 · 1 reaction ·
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
-
area:java-functions
Difficulty 2/5 1-3 hours Newbie friendliness 45/100
-
area:java-functions
Difficulty 5/5 Over a week Newbie friendliness 25/100
All issues in Azure/azure-functions-java-library
Similar issues
-
certification
Difficulty 1/5 Under an hour Newbie friendliness 80/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
[BUG] ECR GetAuthorizationToken returns a proxyEndpoint for the default region, not the request's Openbug ecr
Difficulty 2/5 1-3 hours Newbie friendliness 75/100
-
Needs: Triage Type: Feature request
Difficulty 2/5 1-3 hours Newbie friendliness 70/100
AntennaPod/AntennaPod#8794 ·
-
agentic-workflows
Difficulty 2/5 1-3 hours Newbie friendliness 65/100
github/copilot-sdk#2760 ·