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

Oracle LOB segments holding TEMP space after executing SP using SimpleJdbcCall with SqlParameterSource #22972

Closed
sean-che opened this issue May 14, 2019 · 0 comments
Closed

Oracle LOB segments holding TEMP space after executing SP using SimpleJdbcCall with SqlParameterSource #22972

sean-che opened this issue May 14, 2019 · 0 comments
Assignees
@jhoeller
Labels
in: data Issues in data modules (jdbc, orm, oxm, tx) status: backported An issue that has been backported to maintenance branches type: bug A general bug
Milestone
5.2.8

Comments

@sean-che
Copy link

spring-framework/spring-jdbc/src/main/java/org/springframework/jdbc/core/StatementCreatorUtils.java

Line 460 in e0654a5

public static void cleanupParameters(@Nullable Collection<?> paramValues) {

When using SimpleJdbcCall with MapSqlParameterSource but without initial parameters declaration - all parameters became as SqlParameterValue.

But cleanup method doesn't expect such type of parameters and therefore is not executing freetemporary for LOBs.
@spring-projects-issues spring-projects-issues added the status: waiting-for-triage An issue we've not yet triaged or decided on label May 14, 2019
@sbrannen sbrannen added the in: data Issues in data modules (jdbc, orm, oxm, tx) label May 14, 2019
@jhoeller jhoeller self-assigned this Jul 19, 2020
@jhoeller jhoeller added type: bug A general bug and removed status: waiting-for-triage An issue we've not yet triaged or decided on labels Jul 19, 2020
@jhoeller jhoeller added this to the 5.2.8 milestone Jul 19, 2020
@jhoeller jhoeller added the for: backport-to-5.1.x Marks an issue as a candidate for backport to 5.1.x label Jul 19, 2020
@spring-projects-issues spring-projects-issues added status: backported An issue that has been backported to maintenance branches and removed for: backport-to-5.1.x Marks an issue as a candidate for backport to 5.1.x labels Jul 19, 2020
Closed
Closed
Closed
jhoeller added a commit that referenced this issue Jul 19, 2020
@jhoeller
Unwrap SqlParameterValue for disposable value detection in cleanupPar…
7a79358 
…ameters

Closes gh-22972

(cherry picked from commit 43e315f)
jhoeller added a commit that referenced this issue Jul 19, 2020
@jhoeller
Unwrap SqlParameterValue for disposable value detection in cleanupPar…
eb4f91a 
…ameters

Closes gh-22972

(cherry picked from commit 43e315f)
jhoeller added a commit that referenced this issue Jul 19, 2020
@jhoeller
Unwrap SqlParameterValue for disposable value detection in cleanupPar…
6d524e1 
…ameters

Closes gh-22972
FelixFly pushed a commit to FelixFly/spring-framework that referenced this issue Aug 16, 2020
@jhoeller
Unwrap SqlParameterValue for disposable value detection in cleanupPar…
f2283b3 
…ameters

Closes spring-projectsgh-22972
zx20110729 pushed a commit to zx20110729/spring-framework that referenced this issue Feb 18, 2022
@jhoeller @zx20110729
Unwrap SqlParameterValue for disposable value detection in cleanupPar…
a69ce28 
…ameters

Closes spring-projectsgh-22972

(cherry picked from commit 43e315f)
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) status: backported An issue that has been backported to maintenance branches type: bug A general bug
Projects
None yet
Milestone
5.2.8
Development

No branches or pull requests
4 participants
@sbrannen @sean-che @jhoeller @spring-projects-issues