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

TypeConversion for boolean not working with Oracle #485

Closed
aley2003 opened this issue Apr 19, 2023 · 1 comment · Fixed by #486
Closed

TypeConversion for boolean not working with Oracle #485

aley2003 opened this issue Apr 19, 2023 · 1 comment · Fixed by #486
Labels
bug
Milestone
6.0.5

Comments

@aley2003
Copy link

aley2003 commented Apr 19, 2023 •
edited

In Oracle boolean is mapped to NUMBER(1).
The Oracle JDBC driver returns BigDecimal for NUMBER fields.
The datanucleus TypeConversionHelper does not implement a mapping from BigDecimal to boolean.
This results to boolean values read from an Oracle database are alway false in memory (for SQL queries at least).

Tested with datanucleus-core 6.0.4.

I will deliver a test case an a pull request.
@aley2003
Copy link
Author

test-boolean-convert.zip

aley2003 pushed a commit to aley2003/datanucleus-core-485 that referenced this issue Apr 19, 2023
issue datanucleus#485: Fix boolean mapping in TypeConversionHelper
95c9e42
aley2003 pushed a commit to aley2003/datanucleus-core-485 that referenced this issue Apr 19, 2023
issue datanucleus#485: Fix boolean mapping in TypeConversionHelper
3828238
@aley2003 aley2003 mentioned this issue Apr 19, 2023
Merged
@andyjefferson andyjefferson added this to the 6.0.5 milestone Apr 21, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
6.0.5
Development

Successfully merging a pull request may close this issue.

Boolean mapping 485 aley2003/datanucleus-core-485
2 participants
@andyjefferson @aley2003