Skip to Main Content
Forums

Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLServer JDBC Adapter

554341Feb 21 2008 — edited Mar 11 2008
Folks I´m having this issue, 
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><env:Header/><env:Body><env:Fault xmlns:env="http://schemas.xmlsoap.org/soap/envelope/"><faultcode>env:Server</faultcode><faultstring>oracle.tip.esb.server.common.exceptions.BusinessEventRetriableException: Uma exceção não tratada foi gerada no sistema ESB. A exceção relatada é: "oracle.tip.esb.server.common.exceptions.BusinessEventRetriableException: Uma exceção não tratada foi gerada no sistema ESB. A exceção relatada é: "org.collaxa.thirdparty.apache.wsif.WSIFException: esb:///ESB_Projects/ESBIntegration_ESBIntegration/adpSQLServer.wsdl [ adpSQLServer_ptt::adpSQLServerSelect_status(adpSQLServerSelect_status_inparameters,IntegrationCollection) ] - WSIF JCA Execute of operation 'adpSQLServerSelect_status' failed due to: Não foi possível criar/acessar a Sessão TopLink.
Esta sessão é usada na conexão ao armazenamento de dados. [Caused by: No suitable driver]

	at oracle.tip.adapter.fw.wsif.jca.WSIFOperation_JCA.executeRequestResponseOperation(WSIFOperation_JCA.java:630)
	at oracle.tip.esb.server.common.wsif.WSIFInvoker.executeOperation(Unknown Source)
	at oracle.tip.esb.server.common.wsif.WSIFInvoker.nextService(Unknown Source)
	at oracle.tip.esb.server.service.impl.outadapter.OutboundAdapterService.nextService(Unknown Source)
	at oracle.tip.esb.server.service.impl.outadapter.OutboundAdapterService.processBusinessEvent(Unknown Source)
	at oracle.tip.esb.server.dispatch.InitialEventDispatcher.dispatchNonRoutingService(Unknown Source)
	at oracle.tip.esb.server.dispatch.InitialEventDispatcher.dispatch(Unknown Source)
	at oracle.tip.esb.server.dispatch.BusinessEvent.raise(Unknown Source)
	at oracle.tip.esb.utils.EventUtils.raiseBusinessEvent(Unknown Source)
	at oracle.tip.esb.server.service.EsbRouterSubscription.onBusinessEvent(Unknown Source)
	at oracle.tip.esb.server.dispatch.EventDispatcher.executeSubscription(Unknown Source)
	at oracle.tip.esb.server.dispatch.InitialEventDispatcher.processSubscription(Unknown Source)
	at oracle.tip.esb.server.dispatch.InitialEventDispatcher.processSubscriptions(Unknown Source)
	at oracle.tip.esb.server.dispatch.EventDispatcher.dispatchRoutingService(Unknown Source)
	at oracle.tip.esb.server.dispatch.InitialEventDispatcher.dispatch(Unknown Source)
	at oracle.tip.esb.server.dispatch.BusinessEvent.raise(Unknown Source)
	at oracle.tip.esb.utils.EventUtils.raiseBusinessEvent(Unknown Source)
	at oracle.tip.esb.server.service.EsbRouterSubscription.onBusinessEvent(Unknown Source)
	at oracle.tip.esb.server.dispatch.EventDispatcher.executeSubscription(Unknown Source)
	at oracle.tip.esb.server.dispatch.InitialEventDispatcher.processSubscription(Unknown Source)
	at oracle.tip.esb.server.dispatch.InitialEventDispatcher.processSubscriptions(Unknown Source)
	at oracle.tip.esb.server.dispatch.EventDispatcher.dispatchRoutingService(Unknown Source)
	at oracle.tip.esb.server.dispatch.InitialEventDispatcher.dispatch(Unknown Source)
	at oracle.tip.esb.server.dispatch.BusinessEvent.raise(Unknown Source)
	at oracle.tip.esb.server.service.impl.soap.EventOracleSoapProvider.raiseEvent(Unknown Source)
	at oracle.tip.esb.server.service.impl.soap.EventOracleSoapProvider.processMessage(Unknown Source)
	at oracle.j2ee.ws.server.provider.ProviderProcessor.doEndpointProcessing(ProviderProcessor.java:869)
	at oracle.j2ee.ws.server.WebServiceProcessor.invokeEndpointImplementation(WebServiceProcessor.java:349)
	at oracle.j2ee.ws.server.provider.ProviderProcessor.doRequestProcessing(ProviderProcessor.java:460)
	at oracle.j2ee.ws.server.WebServiceProcessor.processRequest(WebServiceProcessor.java:114)
	at oracle.j2ee.ws.server.WebServiceProcessor.doService(WebServiceProcessor.java:96)
	at oracle.j2ee.ws.server.WebServiceServlet.doPost(WebServiceServlet.java:177)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:711)
	at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
	at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
	at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
	at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
	at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
	at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
	at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
	at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)
	at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)
	at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)
	at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
	at java.lang.Thread.run(Thread.java:595)
".

	at oracle.tip.esb.server.common.wsif.WSIFInvoker.executeOperation(Unknown Source)
	at oracle.tip.esb.server.common.wsif.WSIFInvoker.nextService(Unknown Source)
	at oracle.tip.esb.server.service.impl.outadapter.OutboundAdapterService.nextService(Unknown Source)
	at oracle.tip.esb.server.service.impl.outadapter.OutboundAdapterService.processBusinessEvent(Unknown Source)
	at oracle.tip.esb.server.dispatch.InitialEventDispatcher.dispatchNonRoutingService(Unknown Source)
	at oracle.tip.esb.server.dispatch.InitialEventDispatcher.dispatch(Unknown Source)
	at oracle.tip.esb.server.dispatch.BusinessEvent.raise(Unknown Source)
	at oracle.tip.esb.utils.EventUtils.raiseBusinessEvent(Unknown Source)
	at oracle.tip.esb.server.service.EsbRouterSubscription.onBusinessEvent(Unknown Source)
	at oracle.tip.esb.server.dispatch.EventDispatcher.executeSubscription(Unknown Source)
	at oracle.tip.esb.server.dispatch.InitialEventDispatcher.processSubscription(Unknown Source)
	at oracle.tip.esb.server.dispatch.InitialEventDispatcher.processSubscriptions(Unknown Source)
	at oracle.tip.esb.server.dispatch.EventDispatcher.dispatchRoutingService(Unknown Source)
	at oracle.tip.esb.server.dispatch.InitialEventDispatcher.dispatch(Unknown Source)
	at oracle.tip.esb.server.dispatch.BusinessEvent.raise(Unknown Source)
	at oracle.tip.esb.utils.EventUtils.raiseBusinessEvent(Unknown Source)
	at oracle.tip.esb.server.service.EsbRouterSubscription.onBusinessEvent(Unknown Source)
	at oracle.tip.esb.server.dispatch.EventDispatcher.executeSubscription(Unknown Source)
	at oracle.tip.esb.server.dispatch.InitialEventDispatcher.processSubscription(Unknown Source)
	at oracle.tip.esb.server.dispatch.InitialEventDispatcher.processSubscriptions(Unknown Source)
	at oracle.tip.esb.server.dispatch.EventDispatcher.dispatchRoutingService(Unknown Source)
	at oracle.tip.esb.server.dispatch.InitialEventDispatcher.dispatch(Unknown Source)
	at oracle.tip.esb.server.dispatch.BusinessEvent.raise(Unknown Source)
	at oracle.tip.esb.server.service.impl.soap.EventOracleSoapProvider.raiseEvent(Unknown Source)
	at oracle.tip.esb.server.service.impl.soap.EventOracleSoapProvider.processMessage(Unknown Source)
	at oracle.j2ee.ws.server.provider.ProviderProcessor.doEndpointProcessing(ProviderProcessor.java:869)
	at oracle.j2ee.ws.server.WebServiceProcessor.invokeEndpointImplementation(WebServiceProcessor.java:349)
	at oracle.j2ee.ws.server.provider.ProviderProcessor.doRequestProcessing(ProviderProcessor.java:460)
	at oracle.j2ee.ws.server.WebServiceProcessor.processRequest(WebServiceProcessor.java:114)
	at oracle.j2ee.ws.server.WebServiceProcessor.doService(WebServiceProcessor.java:96)
	at oracle.j2ee.ws.server.WebServiceServlet.doPost(WebServiceServlet.java:177)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
	at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:711)
	at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:368)
	at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:866)
	at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:448)
	at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:216)
	at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:117)
	at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:110)
	at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
	at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239)
	at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34)
	at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880)
	at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
	at java.lang.Thread.run(Thread.java:595)
Caused by: org.collaxa.thirdparty.apache.wsif.WSIFException: esb:///ESB_Projects/ESBIntegration_ESBIntegration/adpSQLServer.wsdl [ adpSQLServer_ptt::adpSQLServerSelect_status(adpSQLServerSelect_status_inparameters,IntegrationCollection) ] - WSIF JCA Execute of operation 'adpSQLServerSelect_status' failed due to: Não foi possível criar/acessar a Sessão TopLink.
Esta sessão é usada na conexão ao armazenamento de dados. [Caused by: No suitable driver]

	at oracle.tip.adapter.fw.wsif.jca.WSIFOperation_JCA.executeRequestResponseOperation(WSIFOperation_JCA.java:630)
	... 46 more
".
</faultstring><faultactor></faultactor></env:Fault></env:Body></env:Envelope>
Where I´m must put my jdbc jar file ?
Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2008
Added on Feb 21 2008
#bpel, #soa-process-management
4 comments
2,330 views