12 Replies Latest reply on Feb 2, 2013 2:13 PM by rareddy

Simplest web service generation problems

dsusin Jan 31, 2013 9:32 AM

first of all forgive my battery of questions these last days

I'm using Designer 8 with Teiid 8.2 and I'm trying to create a web service from relational data sources and I'm not capable of it... I created the simplest example I can think of following the user's guide:

Data source is a simple static csv file on my filesystem of simply 3 columns and 4 rows.
I create the source and view models and a table.
No problem deploying and querying the vdb.
I create a data source to the vdb with the management console to be used later when creating the WAR.
I create a web service via Modeling -> Create web service on the table.
1. Here, the virtual procedure is a simple "SELECT *" from the corresponding table_OutputView but I get the following message "The SELECT transformation is valid, but NOT fully reconciled:The number of transformation output symbols is zero".
2. I generate the WAR via Modeling -> Generate JbossWS-CXF WAR, using the datasource of the VDB generated in (2) and with security "None".
I add the web service model to the vdb and redeploy.
I deploy the WAR with no apparent errors. the following log is generated:

13:07:00,632 INFO [org.jboss.wsf.stack.cxf.metadata.MetadataBuilder] (MSC service thread 1-2) Add Service

id=simplest_csv_view_simplest_csv_table

address=http://localhost:8080/simplest_vdb_ws/simplest_csv_view_simplest_csv_table

implementor=org.teiid.soap.provider.simplest_csv_view_simplest_csv_table

invoker=org.jboss.wsf.stack.cxf.JBossWSInvoker

serviceName={http://teiid.org}simplest_vdb_ws

portName={http://teiid.org}simplest_csv_view_simplest_csv_table

wsdlLocation=null

mtomEnabled=false

Once done all that I try to access the web service and I get this error on the server console:

I attach the csv file, the vdb, the war file and the datasource code in case it's of any help.

Thanks.

13:07:09,181 SEVERE [org.teiid.jdbc] (http--127.0.0.1-8080-1) Could not create connection: org.teiid.jdbc.TeiidSQLException: TEIID20018 Unable to find a component used authenticate on to Teiid

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

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

at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:56)

at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)

at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55)

at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)

at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)

at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:761)

at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:343)

at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:397)

at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:365)

at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:329)

at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:302)

at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)

at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)

at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:110) [classes:]

at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

at org.teiid.soap.provider.simplest_csv_view_simplest_csv_table.invoke(simplest_csv_view_simplest_csv_table.java:22) [classes:]

at org.teiid.soap.provider.simplest_csv_view_simplest_csv_table.invoke(simplest_csv_view_simplest_csv_table.java:15) [classes:]

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_10]

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_10]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_10]

at java.lang.reflect.Method.invoke(Method.java:601) [rt.jar:1.7.0_10]

at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.7.0_10]

at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) [rt.jar:1.7.0_10]

at java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_10]

at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:113)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_10]

Caused by: org.teiid.net.CommunicationException: TEIID20018 Unable to find a component used authenticate on to Teiid

at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:144)

at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:92)

at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:312)

at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:54)

... 54 more

Caused by: org.teiid.core.TeiidComponentException: TEIID10006 Decryption failed: java.lang.ClassNotFoundException org.teiid.client.security.LogonResult from [Module "deployment.simplest_vdb_ws.war:main" from Service Module Loader]

at org.teiid.client.util.ExceptionUtil.convertException(ExceptionUtil.java:59)

at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:374)

at $Proxy36.logon(Unknown Source) at org.teiid.net.socket.SocketServerConnection.logon(SocketServerConnection.java:173)

at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:125)

... 57 more

Caused by: org.teiid.core.crypto.CryptoException: TEIID10006 Decryption failed: java.lang.ClassNotFoundException org.teiid.client.security.LogonResult from [Module "deployment.simplest_vdb_ws.war:main" from Service Module Loader]

at org.teiid.core.crypto.BasicCryptor.unsealObject(BasicCryptor.java:147) [teiid-common-core-8.2.0.Final.jar:8.2.0.Final]

at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler$1.convertResult(SocketServerInstanceImpl.java:326)

at org.teiid.client.util.ResultsFuture.get(ResultsFuture.java:116)

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

at org.teiid.net.socket.SocketServerInstanceImpl$RemoteInvocationHandler.invoke(SocketServerInstanceImpl.java:366)

... 60 more

13:07:09,213 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (http--127.0.0.1-8080-1) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection

at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)