View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000447 | Database Workbench v4 | Data Import & Export | public | 2012-09-24 09:57 | 2013-01-22 12:34 |
| Reporter | Martijn Tonies | Assigned To | Martijn Tonies | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Fixed in Version | 4.4.0 | ||||
| Summary | 0000447: Oracle NUMBER fails export to XML | ||||
| Description | Using DBW 4.3.1.0 I exported 10 records from an oracle table to XML but the resulting file is not well-formed in the <METADATA> section - specifically: <FIELD attrname="ACSDREF" fieldtype=/> That field is of type Number (see below) so I guess some routing that converts DataTypes to a string representation doesn't know what to do with Oracle Number fields. Sample file attached. Regards Dave CREATE TABLE AC_DOCUMENTSUB ( ACSDREF Number NOT NULL, ACSACREF Number(6) NOT NULL, ACSDOCREF Number NOT NULL, ACSDOCDATE Date NOT NULL, ACSDOCTYPE VarChar2(5) NOT NULL, ACSDOCSUBTYPE VarChar2(5) NOT NULL, ACSDOCITEMREF VarChar2(35) NOT NULL, ACSCLIDOCREF VarChar2(25), ACSFROMDATE Date, ACSTODATE Date, ACSENGRELATED VarChar2(1), ACSENGESN Number, ACSDOCINFO VarChar2(300), ACSCREATED_USER VarChar2(50), ACSCREATED_DATE Date, ACSLAST_UPDT_USER VarChar2(50), ACSLAST_UPDT_DATE Date, ACSDBKRELATED VarChar2(1) DEFAULT 'N', ACSDBKSDTYPE Number, ACSPHYSICALLOC VarChar2(40), ACSDOCLEVEL Number, ACSDOCPROCESSED VarChar2(1), FIELDREF Number DEFAULT -1, LOCKED Number DEFAULT -1, CONSTRAINT PK_AC_DOCSUB PRIMARY KEY ( ACSDREF ) ) | ||||
| Tags | No tags attached. | ||||
| DBMS & Version | |||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-09-24 09:57 | Martijn Tonies | New Issue | |
| 2012-09-24 09:57 | Martijn Tonies | File Added: SLDs.xml.zip | |
| 2012-09-24 09:58 | Martijn Tonies | File Deleted: SLDs.xml.zip | |
| 2012-09-24 09:58 | Martijn Tonies | Status | new => acknowledged |
| 2012-10-24 13:07 | Martijn Tonies | Assigned To | => Martijn Tonies |
| 2012-10-24 13:07 | Martijn Tonies | Status | acknowledged => assigned |
| 2012-10-26 09:55 | Martijn Tonies | Status | assigned => resolved |
| 2012-10-26 09:55 | Martijn Tonies | Fixed in Version | => 4.3.2 |
| 2012-10-26 09:55 | Martijn Tonies | Resolution | open => fixed |
| 2013-01-22 12:34 | Martijn Tonies | Status | resolved => closed |
