Issue in creating and accessing data from VDB in Teiid 7.4
maytagu Jul 11, 2011 5:58 AMHi
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)
at java.lang.Thread.run(Thread.java:619)
-
Logs.txt.zip 961 bytes