1 Reply Latest reply on Sep 30, 2014 10:31 AM by shawkins

Issue when previewing data from oracle 11g db

vince_fr Sep 30, 2014 10:26 AM

Worked quite a bit on JBDS and Teiid now.

Works fine and really exciting.

Until now, I was federating data from web services and flat files.

Now going to relational : oracle 11g data.

I have a server (Linux centos) and a client (Windows with JBDS and Teiid plugin ok).

Connecting to Oracle and creating source/view model by doing retro engineering is ok.

I have my structures, my tables.

But I face an issue when trying to preview a simple table :

Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for CEREP were not avaialable. The command could not be planned properly.

Please note :

- I use the ojdbc.jar driver both on client and server

- on the server, I copied the ojdbc.jar file in : /data/datavirt/jboss-eap-6.1/dataVirtualization/jdbc

- i didn't restart jboss after copying the ojdbc file.

Any suggestion please ?

I don't see where I failed.

Many thanks

Vincent

1. Re: Issue when previewing data from oracle 11g db

shawkins Sep 30, 2014 10:31 AM (in response to vince_fr)

In the log you should failures to obtain a connection from the oracle datasource. You'll want to recheck its configuration from there.
Actions