Improve handling of NUMERIC and DECIMAL types
---------------------------------------------
Key: GEOT-2362
URL: http://jira.codehaus.org/browse/GEOT-2362
Project: GeoTools
Issue Type: Improvement
Components: data jdbc-ng
Affects Versions: 2.5.3
Reporter: Andrea Aime
Assignee: Andrea Aime
Fix For: 2.5.4
At the moment both of those types are mapped to BigDecimal, but there is room
for more accurate type mapping.
Databases such as Oracle do not have a real "integer" type and compensate the
lack using NUMBER(x,0), which we should try to map to some integral type.
Now, the issue is that int and long require something like 11 and 19 digits
respectively, but cannot represent any number with that many digits.
So the issue would be that we can recognize NUMBER(18,0) as Long, but when we
go and use createSchema, we'd have to generate NUMBER(19,0) to allow every Long
to be mapped, and then map it back to BigInteger because we cannot really
represent any 19digits number with Long. Meh...
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Geotools-devel mailing list
Geotools-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
