]
Warren Gibson commented on TEIID-1382:
--------------------------------------
The blank error files are also showing up in ModeShape testing. Two (query 151 and 599)
are showing up with blank error files.
CTC test producing blank VQT errors but Squirrel does produce
expected results
-------------------------------------------------------------------------------
Key: TEIID-1382
URL:
https://jira.jboss.org/browse/TEIID-1382
Project: Teiid
Issue Type: Bug
Components: Integration Tests
Reporter: Warren Gibson
Assignee: Van Halbert
Priority: Minor
4 vqt queries for DB2 97 are producting a blank XML error file.
Mapping S1001=SELECT * FROM VQT.Mapping1 ORDER BY IntKey
Mapping S1002=SELECT VQT.Mapping1.* FROM VQT.Mapping1 ORDER BY IntKey
Mapping S1003=SELECT * FROM VQT.Mapping1 AS X ORDER BY IntKey
Mapping S1004=SELECT X.* FROM VQT.Mapping1 AS X ORDER BY IntKey
An xml error file is being produced but it is completely blank. It should be noted when
I attempt to generate new test results they are also blank. The summary text
indicates the problem is related to Lob:
- Mapping1_Queries_Mapping1_S-1001~Unable to read data from the stream:
java.io.IOException: Remote java.io.IOException: com.ibm.db2.jcc.am.SqlException:
[jcc][10120][11936][3.58.82] Invalid operation: Lob is closed. ERRORCODE=-4470,
SQLSTATE=null
- Mapping1_Queries_Mapping1_S-1002~Unable to read data from the stream:
java.io.IOException: Remote java.io.IOException: com.ibm.db2.jcc.am.SqlException:
[jcc][10120][11936][3.58.82] Invalid operation: Lob is closed. ERRORCODE=-4470,
SQLSTATE=null
- Mapping1_Queries_Mapping1_S-1003~Unable to read data from the stream:
java.io.IOException: Remote java.io.IOException: com.ibm.db2.jcc.am.SqlException:
[jcc][10120][11936][3.58.82] Invalid operation: Lob is closed. ERRORCODE=-4470,
SQLSTATE=null
- Mapping1_Queries_Mapping1_S-1004~Unable to read data from the stream:
java.io.IOException: Remote java.io.IOException: com.ibm.db2.jcc.am.SqlException:
[jcc][10120][11936][3.58.82] Invalid operation: Lob is closed. ERRORCODE=-4470,
SQLSTATE=null
When I run the 4 queries in Squirrel I get results and they seem to match the expected
results so I think the queries are actually
returning the proper results. Therefore, I am marking this as a "Minor"
problem. It appears to be an issue with the query testing framework choking on Lob.
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: