Issue Details (XML | Word | Printable)

Type: Bug Bug
Status: Closed Closed
Resolution: Won't Fix
Priority: Major Major
Assignee: Unassigned
Reporter: Yang ZHONG
Votes: 0
Watchers: 0

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

sql-type="NUMBER" isn't exactly honored towards Oracle

Created: 25/Jun/09 07:33 AM   Updated: 26/Dec/09 12:57 PM   Resolved: 10/Dec/09 09:54 AM
Component/s: SchemaTool
Affects Version/s: 1.1.3
Fix Version/s: None

File Attachments: 1. Zip Archive (2 kB)

Environment: Linux, Java 5

Datastore: Oracle
Severity: Production

 Description  « Hide
SchemaTool 1.1.3 still generates NUMBER(10) although sql-type="NUMBER".

Yang ZHONG added a comment - 25/Jun/09 07:35 AM
Can't test against 1.1.4 due to NUCRDBMS-205

Yang ZHONG made changes - 25/Jun/09 07:35 AM
Field Original Value New Value
Attachment [ 10964 ]
Andy Jefferson added a comment - 10/Dec/09 09:54 AM
The NUMBER type on Oracle accepts precision (according to their JDBC driver) and setting to 10 is simply setting to a large enough number to fit the type of the java type ... in this case an "int" needs 10. So thats what happens. No error occurs.

Andy Jefferson made changes - 10/Dec/09 09:54 AM
Status Open [ 1 ] Resolved [ 5 ]
Resolution Won't Fix [ 2 ]
Andy Jefferson made changes - 26/Dec/09 12:57 PM
Status Resolved [ 5 ] Closed [ 6 ]