-
1. Re: LINQPad4 returns unsupported schema when connecting to ODATA
rareddy Jun 15, 2015 5:33 PM (in response to camperor)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..
-
2. Re: LINQPad4 returns unsupported schema when connecting to ODATA
camperor Jun 15, 2015 5:47 PM (in response to rareddy)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>
-
3. Re: LINQPad4 returns unsupported schema when connecting to ODATA
camperor Jun 15, 2015 5:48 PM (in response to camperor)forgot to mention, those return from within a web browser, neither link works from LINQPad or VisualStudio.
-
4. Re: LINQPad4 returns unsupported schema when connecting to ODATA
rareddy Jun 15, 2015 5:51 PM (in response to camperor)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..
-
5. Re: LINQPad4 returns unsupported schema when connecting to ODATA
camperor Jun 15, 2015 6:03 PM (in response to rareddy)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.
-
6. Re: LINQPad4 returns unsupported schema when connecting to ODATA
camperor Jun 15, 2015 6:07 PM (in response to 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.
-
7. Re: LINQPad4 returns unsupported schema when connecting to ODATA
rareddy Jun 15, 2015 6:16 PM (in response to camperor)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..
-
8. Re: LINQPad4 returns unsupported schema when connecting to ODATA
rareddy Jun 15, 2015 6:22 PM (in response to camperor)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
-
9. Re: LINQPad4 returns unsupported schema when connecting to ODATA
camperor Jun 15, 2015 6:23 PM (in response to rareddy)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/
-
10. Re: LINQPad4 returns unsupported schema when connecting to ODATA
rareddy Jun 15, 2015 6:29 PM (in response to camperor)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.. -
11. Re: LINQPad4 returns unsupported schema when connecting to ODATA
camperor Jun 15, 2015 6:34 PM (in response to rareddy)Ramesh,
Thanks and I look forward to your response.
Rich
-
12. Re: LINQPad4 returns unsupported schema when connecting to ODATA
rareddy Jun 16, 2015 1:33 PM (in response to camperor)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..
-
13. Re: LINQPad4 returns unsupported schema when connecting to ODATA
camperor Jun 16, 2015 3:30 PM (in response to rareddy)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.
-
14. Re: LINQPad4 returns unsupported schema when connecting to ODATA
rareddy Jun 17, 2015 11:38 AM (in response to camperor)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..