DataNucleus JIRA is now in read-only mode. Raise any new issues in GitHub against the plugin that it applies to. DataNucleus JIRA will remain for the foreseeable future but will eventually be discontinued
Issue Details (XML | Word | Printable)

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

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 207.zip (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 207.zip [ 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 ]