Navigation Menu

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.

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

Add support for customizing the JsonType underlying Oracle column type #424

Closed
vladmihalcea opened this issue Apr 11, 2022 · 0 comments
Closed
Assignees
Milestone

Comments

@vladmihalcea
Copy link
Owner

When using Oracle, there are three ways to store JSON objects:

  • using the 21c JSON column type
  • using a VARCHAR2 column
  • using a BLOB or CLOB column

Traditionally, the JsonType assumed the VARCHAR2 column is used, but now you can customize the default column type, like this:

properties.setProperty(
	Configuration.PropertyKey.DEFAULT_JSON_TYPE.getKey(),
	"blob"
);

or

properties.setProperty(
	Configuration.PropertyKey.DEFAULT_JSON_TYPE.getKey(),
	"varchar"
);

or

properties.setProperty(
	Configuration.PropertyKey.DEFAULT_JSON_TYPE.getKey(),
	"json"
);
@vladmihalcea vladmihalcea added this to the 2.15.3 milestone Apr 11, 2022
@vladmihalcea vladmihalcea self-assigned this Apr 11, 2022
vladmihalcea added a commit that referenced this issue Apr 11, 2022
Add support for customizing the JsonType underlying Oracle column type #424
vladmihalcea added a commit that referenced this issue Apr 12, 2022
Add support for customizing the JsonType underlying Oracle column type #424
vladmihalcea added a commit that referenced this issue Apr 12, 2022
Add support for customizing the JsonType underlying Oracle column type #424
vladmihalcea added a commit that referenced this issue Apr 12, 2022
Add support for customizing the JsonType underlying Oracle column type #424
vladmihalcea added a commit that referenced this issue Apr 12, 2022
Add support for customizing the JsonType underlying Oracle column type #424
vladmihalcea added a commit that referenced this issue Apr 12, 2022
Add support for customizing the JsonType underlying Oracle column type #424
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant