You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "苏锦佩 (JIRA)" <ji...@apache.org> on 2017/09/18 08:19:00 UTC
[jira] [Resolved] (TRAFODION-2712) odb didn't extract data from
database to correct xml file
[ https://issues.apache.org/jira/browse/TRAFODION-2712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
苏锦佩 resolved TRAFODION-2712.
----------------------------
Resolution: Fixed
> odb didn't extract data from database to correct xml file
> ---------------------------------------------------------
>
> Key: TRAFODION-2712
> URL: https://issues.apache.org/jira/browse/TRAFODION-2712
> Project: Apache Trafodion
> Issue Type: Bug
> Components: db-utility-odb
> Affects Versions: 2.2-incubating
> Reporter: 苏锦佩
> Fix For: 2.3-incubating
>
>
> 1. data in database like below:
> -bash-4.1$ ./odb64luo -x "select * from testxml"
> odb [2017-08-07 17:55:22]: starting ODBC connection(s)... 0
> 1,hello
> 1,hello
> [0.0.0]--- 2 row(s) selected in 0.022s (prep 0.005s, exec 0.008s, fetch 0.009s/0.005s)
> odb [2017-08-07 17:55:22]: exiting. Session Elapsed time 0.288 seconds (00:00:00.288)
> 2. extract data to xml
> -bash-4.1$ ./odb64luo -e src=testxml:tgt=out.xml:xml
> Connected to Trafodion
> odb [2017-08-07 17:50:39]: starting ODBC connection(s)... 0
> [0] 2 records extracted
> [0] odb version 1.1.0 Extract statistics:
> [0] Source: TESTXML
> [0] Target: out.xml
> [0] Record buffer size: 33 bytes
> [0] Rowset size: 100
> [0] Rowset buffer size: 3.22 KiB
> [0] Pre-extract time: 0.540 s (00:00:00.540)
> [0] Extract time: 0.024 s (00:00:00.024)
> [0] Total records extracted: 2 (0.083 krec/s)
> [0] Total data bytes written: 138 (5.615 KiB/s)
> odb [2017-08-07 17:50:39]: exiting. Session Elapsed time 0.577 seconds (00:00:00.577)
> 3.check contents of xml
> -bash-4.1$ cat out.xml
> <row>
> <ID>1</ID>
> <NAME>hello </NAME>
> <row>
> <row>
> <ID>1</ID>
> <NAME>hello </NAME>
> <row>
> <TESTXML>
> this is not correct xml file.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)