-
Feature Request
-
Resolution: Done
-
Minor
-
None
-
None
-
None
-
None
Through Teiid Wildfly SWARM (examples code), I could able to run connecting below VDB and through SQL client, I could able to access my tables as well.
To expose the same through Odata, in my pom.xml, I added below dependency.
<dependency>
<groupId>org.wildfly.swarm</groupId>
<artifactId>odata</artifactId>
<version>2018.1.0</version>
</dependency>
When my jar starts, I saw odata.war deployed and even my VDB added and through Sql client I could able to connect.
2018-02-08 15:30:31,119 INFO [org.jboss.as.server] (main) WFLYSRV0010: Deployed "odata.war" (runtime-name : "odata.war")
2018-02-08 15:30:31,493 INFO [org.teiid.RUNTIME.VDBLifeCycleListener] (MSC service thread 1-2) TEIID40118 VDB sqlite.1 added to the repository
2018-02-08 15:30:31,497 INFO [org.teiid.RUNTIME] (MSC service thread 1-2) TEIID50029 VDB sqlite.1 model "client" metadata is currently being loaded. Start Time: 8/02/18 3:30 PM
But when I hit the URL,
http://localhost:8080/odata4/sqlite.1/client.client
I am getting error message below - Is it something I am missing?
{ "error":
{ "code": "38000", "message": "38000 TEIID10036 org.teiid.core.TeiidException: TEIID10036 org.teiid.core.TeiidRuntimeException: TEIID40067 javax.naming.NameNotFoundException: teiid\/queryengine\/odata -- service jboss.naming.context.java.teiid.queryengine.odata" }}
Teiid Designer - Generated simple VDB.xml
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<vdb name="sqlite" version="1">
<description>SQLite VDB</description>
<model name="client">
<property name="importer.useFullSchemaName" value="false"/>
<!-- https://access.redhat.com/documentation/en-us/red_hat_jboss_data_virtualization/6.2/html/development_guide_volume_3_reference_material/sect-jdbc_translator -->
<!-- <property name="importer.tableNamePattern" value="CLI%"/> -->
<property name="importer.excludeTables" value="FIL.|ORDER."/>
<source name="sqlite-connector" translator-name="jdbc-simple" connection-jndi-name="java:jboss/datasources/demoDS"/>
</model>
</vdb>