Comments (6)
Thanks taking a look..
This likely broke because of the switch to execute stored procedures directly.
from mssql-jdbc.
We would rather have a fix put in place by Microsoft for this issue. And it would be great to understand when we might expect a fix for this so that we can plan accordingly.
The hotfix will likely be sometime this month. I don't have an exact date yet, but I'll keep you posted.
from mssql-jdbc.
As a temporary workaround, you can rewrite your sql string sproc as:
exec dbo.getContactMaybe ?, ?, 1
This will get the 12.6.2 driver to respect the default argument.
from mssql-jdbc.
That really doesn't work for us because we're talking about an entire enterprise with millions of lines of code, multiple teams, etc. They have relied on the previous behavior for years. I'm guessing that the rest of the community would be running into this as well.
I appreciate the work around but this would be considered a breaking change that should be documented and a major version bump of the driver. We are more likely to stay on old versions of the driver that we know works well.
Also, this behavior works fine with other drivers and other databases so my guess is that it's correct based on the JDBC specification.
We would rather have a fix put in place by Microsoft for this issue. And it would be great to understand when we might expect a fix for this so that we can plan accordingly.
It would also be great to add a unit test suite like this to the driver to capture regressions like this in the future.
Let me know if you need any help or feedback in accomplishing these goals.
from mssql-jdbc.
A tentative hotfix is scheduled for June 20th.
from mssql-jdbc.
Awesome! Thank you!
from mssql-jdbc.
Related Issues (20)
- Does this version run on Android? HOT 5
- Implementation bug in `SqlAuthenticationToken` constructor accepting unix epoch HOT 1
- Slowness in MS SQL Server JDBC driver HOT 42
- Conversion exception when calling a stored procedure with a datetime in-out parameter while setting a String value HOT 4
- Intermittent driver exception on shutdown HOT 9
- Reconnection issue with `lockTimeout` configured HOT 2
- Azure TokenCredential class required if using Always Encrypted but not using Azure HOT 1
- Bulk Copy with SQL Variant type fails due to null sourceResultSet HOT 6
- Temp tables are accessible across JdbcTemplate calls in a Transaction, but not across NamedParameterJdbcTemplates HOT 3
- Issue with Batch Insertion using PreparedStatement in SQL Server HOT 7
- Release naming causing issues for revision checking software HOT 3
- identifier enquoting not implemented (JDBC 4.3) HOT 1
- [QUESTION] Is bulk copy supported on Microsoft Fabric? HOT 2
- Accept concatenated PEM files for trustStore (aka make it easy to use SSL with Amazon RDS) HOT 3
- Mark a (former "stable") release as unstable. HOT 1
- org.apache.ddlutils.DatabaseOperationException: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'change_streams_destination_type'. HOT 2
- Calling a function with parentheses at the end of the function name returns always 0 HOT 4
- [FEATURE REQUEST] Set Bulk Copy options via connection string HOT 4
- Connection closed after a few seconds HOT 8
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mssql-jdbc.