LINQPad4 returns unsupported schema when connecting to ODATA

[camperor]

Teiid Versions 8.11.0.Beta3 and also tested 8.10.1

Encountering issue accessing the ODATA served by Teiid for VDBs created with the designed as well as a dynamic VDB tested (shown below).  The VDB/$metadata retuens when looking at it from within a web browser.

Error for LINQPad is the following when accessing the Dynamic VDB:

- This schema is unsupported - EntityClassGenerator returned the following error: XmlSchemaValidationException.  The 'name' attribute is invalid - the value 'NorthwindModel.Alphabetical_List-of-Product' is invalid according to its datatype 'HTTP://schemaes.microsoft.com/ado/2007/05edm:TSimpleIdentifier

Similar error when accessing the VDBs built with the designer

The Schema is unsupported.  ... Value 'List(Edm:Int16)' is invalid according to its datatype ...

Dynamic VDB.

<vdb name="northwind-rw" version="1">

    <model name="nw">

        <property name="importer.importKeys" value="true"/>

        <property name="importer.importProcedures" value="true"/>

         <source connection-jndi-name="java:/northwindDS" name="northwind-connector" translator-name="odata"/>

    </model>

</vdb>

and associated Data Source

                <resource-adapter id="northwindDS">

                    <module slot="main" id="org.jboss.teiid.resource-adapter.webservice"/>

                    <connection-definitions>

                        <connection-definition class-name="org.teiid.resource.adapter.ws.WSManagedConnectionFactory" jndi-name="java:/northwindDS" enabled="true" use-java-context="true" pool-name="northwindDS">

                            <config-property name="EndPoint">

                                http://services.odata.org/Northwind/Northwind.svc

                            </config-property>

                        </connection-definition>

                    </connection-definitions>

                </resource-adapter>

[rareddy]

Richard,

What your URL look like for OData. Teiid has two different URLs right now, one for V2 another is V4. The root context is "odata" for V2, and "odata4" for V4. 

http://localhost:8080/odata/northwind-rw/$metadata for V2

http://localhost:8080/odata/northwind-rw/nw/$metadata for V4

I have not tested on LINQPad, I will also try to download and test.

Ramesh..

[camperor]

Currently the following link works (the V2, the V4 does not work also below):

http://teiidserver.m2mdatalake.net:8080/odata/northwind-rw.1/$metadata

This XML file does not appear to have any style information associated with it. The document tree is shown below.

<edmx:Edmx xmlns:edmx="http://schemas.microsoft.com/ado/2007/06/edmx" Version="1.0">

<edmx:DataServices xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata" m:DataServiceVersion="2.0">

<Schema xmlns="http://schemas.microsoft.com/ado/2008/09/edm" Namespace="nw">

<EntityType Name="NorthwindModel.Alphabetical_list_of_product">

This one returns an error

http://teiidserver.m2mdatalake.net:8080/odata/northwind-rw.1/nw/$metadata

This XML file does not appear to have any style information associated with it. The document tree is shown below.

<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">

<code>ServerErrorException</code>

<message lang="en-US">Internal Server Error</message>

</error>

[camperor]

forgot to mention, those return from within a web browser, neither link works from LINQPad or VisualStudio.

[rareddy]

Sorry, it should have been

v4: http://teiidserver.m2mdatalake.net:8080/odata4/northwind-rw.1/nw/$metadata

v2: http://teiidserver.m2mdatalake.net:8080/odata/northwind-rw.1/$metadata

Ramesh..

[camperor]

From the web-browser the v2 link returns, v4 throws and error (let me know if you need the server side log file)

http://teiidserver.m2mdatalake.net:8080/odata4/northwind-rw.1/nw/$metadata

JBWEB000065: HTTP Status 500 - JBWEB000247: Filter execution threw an exception

---

JBWEB000309: type JBWEB000066: Exception report

JBWEB000068: message JBWEB000247: Filter execution threw an exception

JBWEB000069: description JBWEB000145: The server encountered an internal error that prevented it from fulfilling this request.

JBWEB000070: exception

javax.servlet.ServletException: JBWEB000247: Filter execution threw an exception 

JBWEB000071: root cause

java.lang.NoClassDefFoundError: org/apache/olingo/server/core/OData4Impl org.teiid.olingo.service.OlingoBridge.getHandler(OlingoBridge.java:52) org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:176) 

JBWEB000072: note JBWEB000073: The full stack trace of the root cause is available in the JBoss Web/7.5.3.Final logs.

[camperor]

A few more details.

When running on teiid-8.11.0.Beta3 V4 returned the error above

re-loaded to teiid-8.10.1 and v4 returns from the web-browser

now with 8.10.1 and v4 LINQPad throws the following error

This schema is unsupported - EntityClassGenerator returned the following error: XmlSchemaValidationException.  The required attribute 'Relationship' is missing.

[rareddy]

Yes, the ClassNotFound Exception in V4 case was my mistake. Can you add following line to "<jboss-eap>//modules/system/layers/dv/org/apache/olingo/main/module.xml" file

<resource-root path="odata-server-core-ext-4.0.0-beta-03.jar" />

And restart the server. Then issue the V4 metadata query. That should fix the error. I will fix this in the next revision o Teiid. V4 stuff is all brand new, I grateful for your feed back.

Ramesh..

[rareddy]

Ignore 8.10.1, V4 version as lot of it was re-written in 8.11 cycle. I can fix any issues with 8.11, as the Final is not released yet

[camperor]

Ramesh,

Added that to teiid-8.11.0.Beta 3 and V4 returns in the web browser but LINQPad is still retuning an error (and this error is different than when I ran with 8.10.1).  Error is as follows:

This schema is unsupported - EntityClassGenerator reutned the following error: XmlSchemaValidationException.  The 'Namespace' attribute is invalid - The value 'northwind-rw.1.nw' is invalid according to its datatype - the Pattern constrint failed.

Address in LINQPad is http://<server>/odata4/northwind-rw.1/nw/

[rareddy]

Richard,

As I mentioned, I have not tested with LINQPad, as I do not have Windows box readily available. I will find one and take a look at the error you are mentioning and fix it.

Thanks

Ramesh..

[camperor]

Ramesh,

Thanks and I look forward to your response.

Rich

[rareddy]

Richard,

Do you know if the LINQPad has support for OData v4? I saw it say 'WCF Data Services 5.5 (OData3)" for the connection type.

Ramesh..

[camperor]

I am not sure but it does not work on either the Odata or Odata4 links.  We originally tested with Visual Studio and it would not connect either so download LinqPad as an alternative.  I can view the services fine in the web browser but we could not get Visual Studio or linqpad to access properly.

[rareddy]

Richard,

Looks like LINQPad does not have OData V4 support yet. If the service compatible with OData v2 & V3 it seems to work. Especially one thing that is not working is what you mention above about "namespace", V4 does support a naming in form of "org.company.data", and LINQpad does not like it.

Can you give some instructions on how to test in Visual Studio?

Ramesh..