How can I deploy VDB for a SOAP interface in Te...| JBoss.org Content Archive (Read Only)

1. Re: How can I deploy VDB for a SOAP interface in TeiidDesigner?

rareddy Jan 12, 2018 8:51 AM (in response to kevinyjn)

See if this blog helps you create SOAP-based service. Generating Web Services for View Models in JBoss Data Virtualization 6.1 – Everything JBoss

2. Re: How can I deploy VDB for a SOAP interface in TeiidDesigner?

kevinyjn Jan 14, 2018 7:15 AM (in response to rareddy)

Thanks a lot

3. Re: How can I deploy VDB for a SOAP interface in TeiidDesigner?

kevinyjn Jan 15, 2018 2:47 AM (in response to rareddy)

Sorry for asking you again, when I deployed the SOAP war from vdb, the soap interface was able to be accessed, but it returns error bellow every time, would you please give me some suggestions?

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

<soap:Body>

<soap:Fault>

<faultcode>soap:Server</faultcode>

<faultstring>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.getuser_info_result('<?xml version="1.0" encoding="UTF-8"?><com:getUser_Input x' at line 1</faultstring>

</soap:Fault>

</soap:Body>

</soap:Envelope>

4. Re: How can I deploy VDB for a SOAP interface in TeiidDesigner?

rareddy Jan 15, 2018 8:53 AM (in response to kevinyjn)

You should first test your VDB using the any SQL Client like SquirreL and make sure there are no errors in your design. Then build the SOAP interface on it. From the error, it looks like there an error either in VDB or MySQL based procedure?

5. Re: How can I deploy VDB for a SOAP interface in TeiidDesigner?

kevinyjn Jan 15, 2018 8:39 PM (in response to rareddy)

Thanks for reply me, I've found that I forgot to do the [Create VDB Data Source] operation from my test1.vdb.

However when I create the test1.vdb jndi name as java:/test1, and deployed the vdb, it still prompts errors like 'For input string "1.0.0"' and org.teiid.designer.datasource.ui exception, the screenshot is:

but it seams that the vdb was deployed successfully on teiid runtime server, when i test the soap interface using SoapUI, the teiid server throws the exception：

09:37:22,125 WARN [org.teiid.SECURITY] (NIO2) TEIID40011 Processing exception 'TEIID50072 The username "anonymous" and/or password and/or payload token could not be authenticated by security domain teiid-security.' for session null. Exception type org.teiid.client.security.LogonException thrown from org.teiid.jboss.JBossSecurityHelper.authenticate(JBossSecurityHelper.java:154). Enable more detailed logging to see the entire stacktrace.

09:37:22,128 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (default task-9) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: IJ031084: Unable to create connection

at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:336)

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

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

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

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

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

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

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

at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:430)

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

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

at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:67)

at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:91)

at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:299)

at org.teiid.soap.provider.Application.invoke(Application.java:22)

at org.teiid.soap.provider.Application.invoke(Application.java:15)

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

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:181)

at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97)

at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.invoke(AbstractJAXWSMethodInvoker.java:232)

at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:69)

at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75)

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

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at org.apache.cxf.interceptor.ServiceInvokerInterceptor$2.run(ServiceInvokerInterceptor.java:126)

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

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

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

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

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

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

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

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

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

at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:212)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)

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

at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)

at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:86)

at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)

at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)

at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)

at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)

at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)

at io.undertow.server.handlers.DisableCacheHandler.handleRequest(DisableCacheHandler.java:33)

at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

at io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:51)

at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)

at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)

at io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:56)

at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)

at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:72)

at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)

at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)

at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)

at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:282)

at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:261)

at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:80)

at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:172)

at io.undertow.server.Connectors.executeRootHandler(Connectors.java:199)

at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:774)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

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

at java.lang.Thread.run(Thread.java:748)

Caused by: org.teiid.jdbc.TeiidSQLException: TEIID50072 The username "anonymous" and/or password and/or payload token could not be authenticated by security domain teiid-security.

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:66)

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.createLocalManagedConnection(LocalManagedConnectionFactory.java:312)

... 72 more

Caused by: org.teiid.net.ConnectionException: TEIID50072 The username "anonymous" and/or password and/or payload token could not be authenticated by security domain teiid-security.

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

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

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

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

... 75 more

Caused by: org.teiid.client.security.LogonException: TEIID50072 The username "anonymous" and/or password and/or payload token could not be authenticated by security domain teiid-security.

at org.teiid.transport.LogonImpl.logon(LogonImpl.java:162)

at org.teiid.transport.LogonImpl.logon(LogonImpl.java:127)

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

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87)

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

at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:237)

at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:223)

at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:212)

at org.teiid.transport.SSLAwareChannelHandler.channelRead(SSLAwareChannelHandler.java:218)

at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)

at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)

at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)

at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)

at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)

at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242)

at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)

at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)

at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847)

at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131)

at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511)

at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468)

at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382)

at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)

at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)

... 1 more

Caused by: javax.security.auth.login.LoginException: TEIID50072 The username "anonymous" and/or password and/or payload token could not be authenticated by security domain teiid-security.

at org.teiid.jboss.JBossSecurityHelper.authenticate(JBossSecurityHelper.java:154)

at org.teiid.jboss.JBossSecurityHelper.authenticate(JBossSecurityHelper.java:60)

at org.teiid.services.SessionServiceImpl.createSession(SessionServiceImpl.java:207)

at org.teiid.transport.LogonImpl.logon(LogonImpl.java:142)

... 27 more

09:37:22,130 SEVERE [org.teiid.soap] (default task-9) Exception in executeDataservice: {0}: java.lang.Throwable: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/test1

at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:175)