Hi Ramesh, It worked now. But some query(ODATA GET) taking too much time and dd n't get result. Any thought..
2018-12-03 20:32:50.216 DEBUG 15336 --- [rocessorQueue55] org.teiid.CONNECTOR : 8upG4hVKOrjM.0.0.1 Getting results from connector
2018-12-03 20:32:50.241 DEBUG 15336 --- [nio-8080-exec-2] org.teiid.BUFFER_MGR : 8upG4hVKOrjM.0.0.1 Blocking on source query 8upG4hVKOrjM.0.0.1
2018-12-03 20:32:50.241 DEBUG 15336 --- [nio-8080-exec-2] org.teiid.BUFFER_MGR : 8upG4hVKOrjM.0 Blocking on source request(s).
2018-12-03 20:32:50.241 DEBUG 15336 --- [nio-8080-exec-2] org.teiid.PROCESSOR : Request Thread 8upG4hVKOrjM.0 - processor blocked
Is your data source returning the results slow? other than that teiid would only take additional time in marshalling the results. At TRACE level it log messages when it submitted to your DB2 and when the results returned etc, check to see if anything is wrong there.
Get below exception while fetching the column with XML content in it,
"message": "The value 'com.ibm.db2.jcc.am.pe@3266e95e' is not valid for property 'NOTES'."
aused by: org.apache.olingo.commons.api.edm.EdmPrimitiveTypeException: The value type class com.ibm.db2.jcc.am.pe is not supported.
What is the data type in database? And then how is this being represented through JDBC metadata? For example, if you connect through tools like SquirreL or DBVisualizer what the data type it reports?
XML is not supported type in OData, it needs to be defined as "stream" type. The data types that are defined in Teiid as blob, clob, xml would be automatically converted to a stream type. In your case the metadata of DB2 is downloaded during the startup and a Teiid model is created. It could be that either Teiid is not converting the DB2 XML type correctly into its runtime type or DB2 is reporting incorrectly.
You can define the Entity for Notes table and mark the column as Clob, try to figure out what is wrong with the above metadata import.
Aslo metadata url is only giving table informations not views,
http://localhost:8080/$metadata----> Gives only tables inside entity set
I have tried this but it not able to find the view from URL
http://localhost:8080/CUSTOMER_VIEW is giviing following error,
"message": "Cannot find EntitySet, Singleton, ActionImport or FunctionImport with name 'CUSTOMER_VIEW'."
How is View definition look like in the DB? Does it a have PK or Unique key in it? Also when I mentioned the View I was thinking of defining an Entity based view in Teiid, not in Database but that should work also as long as you took care of the data conversion of the column that is correctly represented in the Teiid.