Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5252

Teiid Wildfly Swarm Odata

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Minor 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>

            rhn-engineering-rareddy Ramesh Reddy
            arvindo_jira Arvind Gopinath (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: