[TRAFODION-2712] odb didn't extract data from database to correct xml file

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.3
• Component/s: db-utility-odb
• Assignee: Unassigned
• Reporter: 苏锦佩
• Created: 14/Aug/17 12:31
• Updated: 15/Sep/18 07:30
• Resolved: 18/Sep/17 08:18

Description

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.

Issue Links

• links to: GitHub Pull Request #1205