db-ddlutils-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Thomas Dudziak (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DDLUTILS-20) Oracle FLOAT and DOUBLE type mappings have zero scale
Date Fri, 30 Sep 2005 14:05:47 GMT
    [ http://issues.apache.org/jira/browse/DDLUTILS-20?page=comments#action_12330959 ] 

Thomas Dudziak commented on DDLUTILS-20:
----------------------------------------

Hmm, could you run the DumpMetadataTask like so:

<taskdef name="dumpMetadata"
           classname="org.apache.ddlutils.task.DumpMetadataTask ">
    <classpath refid="runtime-classpath"/>
 </taskdef>
  <dumpMetadata outputfile="metadata.xml">
    <database url="jdbc:derby:ddlutils"
              driverClassName="org.apache.derby.jdbc.EmbeddedDriver"
              username=""
              password=""/>
  </dumpMetadata >

on an Oracle database that you created with the FLOAT datatype ? I'd like to see what Oracle
makes of this, eg. whether it converts it to some other datatype or uses FLOAT directly.
If it is the latter, I could introduce a new Oracle 10 platform (until I can test an Oracle
8 installation) that uses ANSI types.

> Oracle FLOAT and DOUBLE type mappings have zero scale
> -----------------------------------------------------
>
>          Key: DDLUTILS-20
>          URL: http://issues.apache.org/jira/browse/DDLUTILS-20
>      Project: DdlUtils
>         Type: Bug
>     Reporter: Richard Bounds
>     Assignee: Thomas Dudziak

>
> In Oracle8Platform, the types FLOAT and DOUBLE are mapped to NUMBER(38). According to
Oracle's docs, this type has zero scale. It looks like floating point numbers should be specified
either as just NUMBER or FLOAT(n). See:
> http://oraclelon1.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements001.htm#g196646

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message