苏锦佩 created TRAFODION-2712: ------------------------------ Summary: 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)