Cast exception while executing query over VDB (OData datasource)

[ramanathan.p]

Experiencing cast exception while executing query over dynamic VDB that connects to OData datasource. Following are the steps to reproduce:

1. Dynamic VDB was created which points to JNDI DataSource that refers to OData service URL and ‘odata’ as translator.
2. JNDI DataSource and Dynamic VDB are deployed successfully in EAP 6.1.0.GA
3. Connected to VDB (DB Connection – Teiid Driver) using JBoss Developer Studio 7.0.0.GA & Teiid Designer 8.3 Beta 2
4. Experiencing cast exception while executing query as shown below:

select * from <TABLE_NAME>;

java.util.ArrayList cannot be cast to java.lang.String

-

Ramanathan

[rareddy]

Can you post whole stacktrace?

Also is this OData source that I can test against? Otherwise can you attach the <url>/$metadata contents of your odata service? I have not seen this before, definitely sounds like a bug. If you provide all the details I will provide the fix.

Thanks

Ramesh..

[rareddy]

I think you may be using older Teiid version before [TEIID-2678] Query against OData source throwing java.lang.NullPointerException - JBoss Issue Tracker fixed. The latest Teiid 8.6 Beta 1 should contain this fix. i saw same error,  I saw same error Designer base OData vdb executed against a older Teiid runtime version.

Ramesh..