facebook

ER Diagram mapping NUMBER(X,Y) to NUMBER(10,Y)

  1. MyEclipse Archived
  2.  > 
  3. Database Tools (DB Explorer, Hibernate, etc.)
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #285315 Reply

    Dexia_AG
    Member

    Currently I want to reverse engineer some tables into ER Diagram. The tables come from an oracle database using the thin jdbc driver.

    If a table in the database is created like

    create table foo (
         testfield NUMERIC(17,3)
    )

    and then imported to the ER Diagram it shows up as

    
                foo
    testfield NUMERIC(10,3)
    

    Thus the overall precision is truncated from 17 to 10.
    It seems like any fields with declaration NUMERIC(X,Y) in a table always are represented in the ER Diagram as NUMERIC (10,Y).

    Any hints to correct this truncated representation?

    Best Regards

    Martin

    Used Versions:
    MyEclipse “Build id: 6.0.1-GA-200710”
    oracle database (10.2.0.1.0 64 b)
    jdbc driver 9.2.0.1.0

    #285350 Reply

    Loyal Water
    Member

    I was able to reproduce the behavior that you have pointed out above. I’m not aware of a workaround but I’ll get this checked right away. Sorry for the inconvenience.

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: ER Diagram mapping NUMBER(X,Y) to NUMBER(10,Y)

You must be logged in to post in the forum log in