I am exploring Data virtualization using Teiid 7.4 version. Following Quick Start example I have successfully deployed a VDB (VDB is up and active i.e. verified through jboss-admin console) but when I am trying to fetch data from tables through VDB it is throwing org.teiid.jdbc.TeiidSQLException and message is displyed that table Group does not exist. Can anyone tell me how to fetch data using VDB and in which Group server is searching for tables whereas they all exists in database. Data retreival is done through Simple Client example given in Teiid itself and fetched query is : run localhost 31000 DynamicPortfolio "Select * from Customer"

Logs attached:

org.teiid.jdbc.TeiidSQLException: Remote org.teiid.api.exception.query.QueryResolverException: Group does not exist: Customer

at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:109)

at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:69)

at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:629)

at org.teiid.jdbc.StatementImpl.access$000(StatementImpl.java:71)

at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:543)

at org.teiid.client.util.ResultsFuture.done(ResultsFuture.java:130)

at org.teiid.client.util.ResultsFuture.access$200(ResultsFuture.java:37)

at org.teiid.client.util.ResultsFuture$1.receiveResults(ResultsFuture.java:75)

at org.teiid.net.socket.SocketServerInstanceImpl.receivedMessage(SocketServerInstanceImpl.java:218)

at org.teiid.net.socket.SocketServerInstanceImpl.read(SocketServerInstanceImpl.java:253)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.teiid.net.socket.SocketServerConnectionFactory$ShutdownHandler.invoke(SocketServerConnectionFactory.java:108)

at $Proxy1.read(Unknown Source)

at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:347)

at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.get(SocketServerInstanceImpl.java:333)

at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:555)

at org.teiid.jdbc.StatementImpl.executeQuery(StatementImpl.java:354)

at JDBCClient.execute(JDBCClient.java:106)

at JDBCClient.main(JDBCClient.java:55)

Caused by: [TeiidProcessingException]Remote org.teiid.api.exception.query.QueryResolverException: Group does not exist: Customer

at org.teiid.query.resolver.util.ResolverUtil.handleUnresolvedGroup(ResolverUtil.java:824)

at org.teiid.query.resolver.util.ResolverUtil.resolveGroup(ResolverUtil.java:911)

at org.teiid.query.resolver.QueryResolver.isXMLQuery(QueryResolver.java:372)

at org.teiid.query.resolver.QueryResolver.chooseResolver(QueryResolver.java:317)

at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:291)

at org.teiid.query.resolver.QueryResolver.resolveCommand(QueryResolver.java:147)

at org.teiid.dqp.internal.process.Request.resolveCommand(Request.java:283)

at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:383)

at org.teiid.dqp.internal.process.Request.processRequest(Request.java:452)

at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:425)

at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:224)

at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:56)

at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:197)

at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:118)

at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:288)

at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)

Yes I have checked the table Customer and it is accessble through SQL command prompt.

I have tried creating VDB and Datasource through Eclipse installed Teiid Designer and there I am able to create VDB but when trying to access data error thrown is to validate the jdbc username and password in Teiid server, don't know where to validate them.

If you are using Teiid Designer, it needs to connect to your server for deploying the VDB, datasource and execute queries. Teiid as two separate connections one for the administrative stuff (deploy, undeploy) and one for execution (jdbc connection), those need to setup these connections before you can execute. See the below picture, to see where those connection properties need be entered.

yes I have given credentials for both Teiid server connection and Teiid JDBC connection. Also VDB is successfully deployed with Datasources but after that while executing the VDB it asks for validation of JDBC username and password. I think it is not able to establish connection with database.

If you can also try it out at your end (will hardly take much time) then it will be very helpful for me as we can examine it, is it working fine or not or i am missing some configuration setting somewhere.

What verion of JBoss AS you are using? You must use JBoss-AS 5.1.0 GA. The above indicates that Teiid is not installed correctly on JBoss AS. Start with fresh install of JBoss AS and unzip the Teiid, if one of profile directories like "default". Check out the installation instructions.

I follow all instructions as metioned in the readme folder's HTML file.

Simple client example works and it spit out the data. But when i try to deploy part project, I'm able to generate DDL and create table and Load data to tables on remote Linux box, but when I run Preview Data for VDB, it fails. It create PREVIEW****.xml and PREVIEW.vdb file also under deploy folder on server.

I do not think I know what exactly is the issue you are having? The solution above I mentioned is for

"Error: Unable to find a component used authenticate on to Teiid"

Looks like you are past that error, if you have made the simple client work. Now from you description you seem to having issues with previewing the data from Designer. What is the error you are seeing in message log panel?

As the error says the designer is failing to find the connection to the source thus it is failing. We have seen this issue before, sometimes restarting the Designer will fix the issue. Otherwise Right Click on the source model for which the connection is not found, select

Modeling ->View Connection Profile Info

if that is not source you are going after then, use

Modeling -> Set Connection Profile Info

to set the correct connection profile for your source, then use the preview.

Did you copy "mysql" JDBC jar into JBoss AS server's "<jboss-as>/server/<profile>/lib" directory, and restarted the server? If not please do. If you already did that then, do you see any errors on the server side?