6 Replies Latest reply on Sep 24, 2012 2:58 PM by rareddy

Connection error from CXF web service based on VDB

gioppoluca Sep 24, 2012 9:11 AM

I've created a webService based on a VDB (the usual books example)

Created the data source

	<datasource jndi-name="java:/BookXMLDB_ws" pool-name="BookXMLDB_ws" enabled="true" use-java-context="true">
	<connection-url>jdbc:teiid:BookXMLDB@mm://localhost:31000</connection-url>
	<driver-class>org.teiid.jdbc.TeiidDriver</driver-class>
	<driver>teiid</driver>
	<pool>
	<prefill>false</prefill>
	<use-strict-min>false</use-strict-min>
	<flush-strategy>FailingConnectionOnly</flush-strategy>
	</pool>
	<security>
	<user-name>user</user-name>
	<password>user</password>
	</security>
	</datasource>

and getting this connection error:

15:01:36,178 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2) processing message:MessageHolder: key=0 contents=javax.crypto.SealedObject@326d888e

15:01:36,192 DEBUG [org.teiid.SECURITY] (New I/O server worker #1-2) authenticateUser user JDBC

15:01:36,247 DEBUG [org.teiid.SECURITY] (New I/O server worker #1-2) Logon successful for " user "

15:01:36,250 DEBUG [org.teiid.SECURITY] (New I/O server worker #1-2) Logon successful, created session: sessionid=+dGRWmlV6iP+; userName=user@teiid-security; vdbName=BookXMLDB; vdbVersion=1; createdTime=Mon Sep 24 15:01:36 CEST 2012; applicationName=JDBC; clientHostName=LTR9PKEAG.domnt.csi.it; clientHardwareAddress=null; IPAddress=10.102.62.63; securityDomain=teiid-security; lastPingTime=Mon Sep 24 15:01:36 CEST 2012

15:01:36,262 DEBUG [org.teiid.TRANSPORT] (New I/O server worker #1-2) send message: MessageHolder: key=0 contents=javax.crypto.SealedObject@63988175

15:01:36,265 FINE [org.teiid.client.sockets] (http--127.0.0.1-8080-1) reading packet

15:01:36,267 FINE [org.teiid.client.sockets] (http--127.0.0.1-8080-1) read asynch message:0

15:01:36,282 GRAVE [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:113)

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

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

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

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

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.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:368)

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.BooksDB_books_books.invoke(BooksDB_books_books.java:22) [classes:]

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

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

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:441) [rt.jar:1.6.0_35]

at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

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:662) [rt.jar:1.6.0_35]

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

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

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.BookXMLDB.war:main" from Service Module Loader]

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

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

at $Proxy41.logon(Unknown Source) at org.teiid.net.socket.SocketServerConnection.logon(SocketServerConnection.java:176)

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

... 57 more

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

at org.teiid.core.crypto.BasicCryptor.unsealObject(BasicCryptor.java:147) [teiid-common-core-8.1.0.Final.jar:8.1.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

15:01:36,416 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)