Issue Details (XML | Word | Printable)

Key: NUCRDBMS-790
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Unassigned
Reporter: Kaarel Kann
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

Boolean fields are left as null when selecting objects using SQL query

Created: 22/Apr/14 09:26 AM   Updated: 10/Aug/14 12:57 PM   Resolved: 07/Aug/14 07:54 AM
Component/s: ORM
Affects Version/s: 3.2.12
Fix Version/s: 4.0.2

File Attachments: 1. Java Source File SimpleTest.java (3 kB)
2. Zip Archive sql_boolean_select.zip (9 kB)

Environment: Any

Severity: Development


 Description  « Hide
Boolean fields are not mapped correctly when selecting with SQL query. They work fine with JDOQL queries.

Kaarel Kann added a comment - 22/Apr/14 09:27 AM
Attached testcases (including entire testcase project)

Kaarel Kann made changes - 22/Apr/14 09:27 AM
Field Original Value New Value
Attachment SimpleTest.java [ 12060 ]
Attachment sql_boolean_select.zip [ 12061 ]
Kaarel Kann added a comment - 22/Apr/14 09:28 AM
Problematic for databases that don't have BOOLEAN data type (e.g Oracle).

Andy Jefferson added a comment - 04/Aug/14 08:12 PM
i.e user stores a column as an integer/long, and expects it to magically be converted back to Boolean (nothing in the spec to expect that). Simply adding a method setXXX (to the result class) that takes in an integer/long and does the mapping (to boolean) would solve that. Some code is now in ClassUtils.convertValue to attempt such things also.

Andy Jefferson made changes - 07/Aug/14 07:54 AM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 4.0.2 [ 12235 ]
Resolution Fixed [ 1 ]
Andy Jefferson made changes - 10/Aug/14 12:57 PM
Status Resolved [ 5 ] Closed [ 6 ]