Skip to content

Configure default LobHandler to use temporary LOBs on Oracle #1208

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.

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

Closed
vpavic opened this issue Sep 25, 2018 · 0 comments
Closed

Configure default LobHandler to use temporary LOBs on Oracle #1208

vpavic opened this issue Sep 25, 2018 · 0 comments
Assignees
Labels
in: jdbc type: backport An issue that is a backport of another issue to a maintenance branch type: bug A general bug
Milestone

Comments

@vpavic
Copy link
Contributor

vpavic commented Sep 25, 2018

Backport of #1203.

@vpavic vpavic added type: bug A general bug Data Store type: backport An issue that is a backport of another issue to a maintenance branch in: jdbc labels Sep 25, 2018
@vpavic vpavic added this to the 2.0.7 milestone Sep 25, 2018
@vpavic vpavic self-assigned this Sep 25, 2018
vpavic added a commit that referenced this issue Sep 25, 2018
JdbcOperationsSessionRepository recently introduced validation when inserting new session attributes in order to prevent data integrity violations in highly concurrent environments. This is done by using INSERT INTO ... SELECT statement to verify existence of session record in parent table. Such arrangement causes problems with Oracle if inserted attribute is of size 4 kb or more.

This commit enhances JdbcHttpSessionConfiguration to detect Oracle database is used, and set createTemporaryLob option on default LobHandler to true.

Resolves: #1208
@vpavic vpavic closed this as completed Sep 25, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
in: jdbc type: backport An issue that is a backport of another issue to a maintenance branch type: bug A general bug
Projects
None yet
Development

No branches or pull requests

1 participant