Hi
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
In the log you should failures to obtain a connection from the oracle datasource. You'll want to recheck its configuration from there.