Description
Driver version
12.8.1
SQL Server version
Microsoft SQL Server 2019 (RTM-CU29-GDR) (KB5046860) - 15.0.4410.1 (X64) Oct 23 2024 15:50:49 Copyright (C) 2019 Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Standard 10.0 (Build 17763: )
Client Operating System
Microsoft Windows [Version 10.0.14393]
JAVA/JVM version
21.0.5
Table schema
Problem description
We have a simple store procedure as a prepared statement that is executed several thousand times a day and only contains 2 simple UPDATE statements. It works most of the time, but after some weeks7months, suddenly the procuedure does not do anything anymore. We printed log statements before and after execution, there is no exception .... when it happens, it does not heal itself anymore! The only "solution" is to completely exit the whole application for the next start to prepare all statements again.
Expected behavior
A working prepared stored procedure should work all the time - no matter how often called.
Actual behavior
After several weeks7Months (with thousands of calls), it suddenly does not execute the UPDATE statements in the procedure code anymore. The call is finished in "0 ms". We expect the driver to somehow got corrupted and even does not through any exception but simple swallows the call / bug.
Error message/stack trace
Nothing, alas.
Any other details that can be helpful
Occurs only after many calls by accident.
JDBC trace logs
Metadata
Metadata
Assignees
Labels
Type
Projects
Status