Issue Details (XML | Word | Printable)

Key: GEOT-729
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Andrea Aime
Reporter: Paolo Rizzi
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
GeoTools

OracleDataStore doesn't work for floats with Oracle before 10.x

Created: 14/Oct/05 12:00 PM   Updated: 06/Jul/07 12:46 PM
Component/s: data oraclespatial
Affects Version/s: 2.2.M0
Fix Version/s: None


 Description  « Hide
OracleDataStore uses the normal JDBCTextFeatureWriter
that puts every non geometry value between quotes.
Oracle before version 10 accepts '0' for a NUMBER field, but not '0.0'.
So any float attribute (or double or whatever) won't be accepted.

We should use a specific OracleFeatureWriter instead to not put quotes
around numbers or we can modifiy the normal JDBCTextFeatureWriter
to distinguish number attributes like this:
else if( Number.class.isAssignableFrom(attributeTypes[i].getType()) ) { attrValue = attributes[i] != null ? String.valueOf(attributes[i]) : null; }
else { attrValue = addQuotes(attributes[i]); }



 All   Comments   Change History      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.