Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

SimpleJdbcCall with namedBinding=true for MS SQL Server #26072

Closed
iignateva opened this issue Nov 11, 2020 · 1 comment
Closed

SimpleJdbcCall with namedBinding=true for MS SQL Server #26072

iignateva opened this issue Nov 11, 2020 · 1 comment
Assignees
@jhoeller
Labels
in: data Issues in data modules (jdbc, orm, oxm, tx) type: enhancement A general enhancement
Milestone
6.1.2

Comments

@iignateva
Copy link

iignateva commented Nov 11, 2020 •
edited by sbrannen

spring version: 5.0.8.RELEASE

I try to use setNamedBinding(true) on SimpleJdbcCall and get the generated statement in oracle syntax (call @P0 = proc_name Param1 => @P1, Param2=> @P2 ...).

I found this comment: #17398 (comment)

Was it implemented for the MS SQL Server?
@spring-projects-issues spring-projects-issues added the status: waiting-for-triage An issue we've not yet triaged or decided on label Nov 11, 2020
@rstoyanchev rstoyanchev added the in: data Issues in data modules (jdbc, orm, oxm, tx) label Nov 10, 2021
@snicoll snicoll mentioned this issue Sep 28, 2023
Merged
@sbrannen sbrannen changed the title SimpleJdbcCall with namedBinding=true for Ms Sql Server SimpleJdbcCall with namedBinding=true for MS Sql Server Sep 28, 2023
@jhoeller
Copy link
Contributor

MS SQL Server seems to use the same @<parameter> = <value> syntax as Sybase, so we should be able to deal with this along with #30231.

@jhoeller jhoeller added type: enhancement A general enhancement and removed status: waiting-for-triage An issue we've not yet triaged or decided on labels Nov 24, 2023
@jhoeller jhoeller self-assigned this Nov 24, 2023
@jhoeller jhoeller added this to the 6.1.2 milestone Nov 24, 2023
@jhoeller jhoeller changed the title SimpleJdbcCall with namedBinding=true for MS Sql Server SimpleJdbcCall with namedBinding=true for MS SQL Server Nov 24, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@jhoeller jhoeller

Labels
in: data Issues in data modules (jdbc, orm, oxm, tx) type: enhancement A general enhancement
Projects
None yet
Milestone
6.1.2
Development

No branches or pull requests
4 participants
@rstoyanchev @jhoeller @spring-projects-issues @iignateva